Closed Bug 1064678 Opened 5 years ago Closed 5 years ago

searching for tracking flag "is empty" is generating incorrect sql

Categories

(bugzilla.mozilla.org :: Extensions: TrackingFlags, defect)

Production
x86
macOS
defect
Not set

Tracking

()

RESOLVED FIXED

People

(Reporter: glob, Assigned: glob)

Details

Attachments

(1 file)

you cannot use advanced search to build a query involving tracking flags and the "is empty" or "is not empty" operators.

the generated sql looks like:

( COALESCE(tracking_flags_bugs_1.value, '---') IS NOT NULL AND COALESCE(tracking_flags_bugs_1.value, '---') != '' )
Attached patch 1064678_1.patchSplinter Review
Assignee: nobody → glob
Status: NEW → ASSIGNED
Attachment #8486203 - Flags: review?(dkl)
Comment on attachment 8486203 [details] [diff] [review]
1064678_1.patch

Review of attachment 8486203 [details] [diff] [review]:
-----------------------------------------------------------------

r=dkl
Attachment #8486203 - Flags: review?(dkl) → review+
To ssh://gitolite3@git.mozilla.org/webtools/bmo/bugzilla.git
   5b25f5c..a446e19  master -> master
Status: ASSIGNED → RESOLVED
Closed: 5 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.