Bug 1679014

Summary:	Can not search with condition pool id is not empty
Product:	[Community] Bugzilla	Reporter:	Rony Gong 🔥 <qgong>
Component:	Creating/Changing Bugs	Assignee:	PnT DevOps Devs <hss-ied-bugs>
Status:	CLOSED DUPLICATE	QA Contact:	tools-bugs <tools-bugs>
Severity:	low	Docs Contact:
Priority:	unspecified
Version:	5.0	CC:	khong, qgong
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2019-02-20 10:03:04 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Rony Gong 🔥 2019-02-20 06:12:16 UTC

Description of problem:
Can not search with condition pool id is not empty

Version-Release number of selected component (if applicable):


How reproducible:
100%

Steps to Reproduce:
1.Try to do an advanced search, in the coustom search, select pool id and is not empty, search
2.
3.

Actual results:
ERROR:  invalid input syntax for integer: ""
LINE 12: ... NULL AND COALESCE(bug_agile_pool.pool_id, -1) != '' AND ( b...

Expected results:


Additional info:

Comment 1 Jeff Fearn 🐞 2019-02-20 10:03:04 UTC

This is another example of an invalid comparison as per Bug 1257476.

*** This bug has been marked as a duplicate of bug 1257476 ***