Closed Bug 1064678 Opened 10 years ago Closed 10 years ago

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

Categories

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

Production
x86
macOS
defect
Not set
normal

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: 10 years ago
Resolution: --- → FIXED
Component: Extensions: TrackingFlags → Extensions
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Creator:
Created:
Updated:
Size: