Bug 1679014 - Can not search with condition pool id is not empty
Summary: Can not search with condition pool id is not empty
Keywords:
Status: CLOSED DUPLICATE of bug 1257476
Alias: None
Product: Bugzilla
Classification: Community
Component: Creating/Changing Bugs
Version: 5.0
Hardware: Unspecified
OS: Unspecified
unspecified
low
Target Milestone: ---
Assignee: PnT DevOps Devs
QA Contact: tools-bugs
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2019-02-20 06:12 UTC by Rony Gong 🔥
Modified: 2019-02-20 10:03 UTC (History)
2 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2019-02-20 10:03:04 UTC
Embargoed:

Attachments (Terms of Use)

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 ***
Note You need to log in before you can comment on or make changes to this bug.