Closed
Bug 926557
Opened 11 years ago
Closed 11 years ago
searching for tracking flags is broken for negated terms where values are unset, breaking the leo+ b2g triage query
Categories
(bugzilla.mozilla.org :: Extensions, defect)
Tracking
()
RESOLVED
FIXED
People
(Reporter: jsmith, Assigned: glob)
Details
Run the following query: https://bugzilla.mozilla.org/buglist.cgi?o5=nowordssubstr&f1=OP&list_id=6430815&f0=OP&f8=status_whiteboard&o2=equals&f4=OP&v5=fixed%20verified%20unaffected%20wontfix&query_format=advanced&j1=OR&f3=CP&f2=cf_blocking_b2g&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=READY&bug_status=ASSIGNED&bug_status=REOPENED&j4=OR&f5=cf_status_b2g18&v8=NPOTB%20POVB&f6=CP&v2=leo%2B&f7=CP&o8=nowordssubstr Notice that there's no bugs being returned, even though there are leo+ bugs still present.
Guys, we need to jump on this. We are doing near daily triage of these bugs to keep the b2g 1.2 work on track. Hopefully it will be a quick fix.
Severity: normal → blocker
Flags: needinfo?(glob)
Flags: needinfo?(dkl)
Assignee: nobody → glob
Component: Administration → Extensions: TrackingFlags
Flags: needinfo?(glob)
Flags: needinfo?(dkl)
OS: Gonk (Firefox OS) → All
Hardware: ARM → All
ah, the problem is when we moved to rows, unset values are no longer present in the database, so return NULL to the query's operators. INSTR on NULL doesn't work. wrapping the values in COALESCE results in the following buglist: bug 895739 bug 900326 bug 903279 bug 908581 bug 911716 bug 914942 bug 915645 bug 920639 bug 923473 bug 924383 which looks correct. working on a code fix now.
fix committed: Committing to: bzr+ssh://bjones%40mozilla.com@bzr.mozilla.org/bmo/4.2/ modified extensions/TrackingFlags/Extension.pm Committed revision 9064. will get this pushed to production asap.
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
Summary: leo+ B2G Triage bug query is returning zero bugs on search, even though there are leo+ bugs present post 10/12/2013 BMO upgrade → searching for tracking flags is broken for negated terms where values are unset, breaking the leo+ b2g triage query
this has been pushed to production, the query now returns 10 bugs.
Updated•5 years ago
|
Component: Extensions: TrackingFlags → Extensions
You need to log in
before you can comment on or make changes to this bug.
Description
•