Closed Bug 584414 Opened 12 years ago Closed 11 years ago

In Bugzilla 3.6, searching for bugs with at least X votes is broken

Categories

(Bugzilla :: Query/Bug List, defect)

3.6.1
defect
Not set
normal

Tracking

()

VERIFIED FIXED
Bugzilla 3.6

People

(Reporter: karl156, Assigned: mkanat)

References

()

Details

(Keywords: regression, Whiteboard: [3.6 only; 4.x not affected])

Attachments

(1 file)

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.2.8) Gecko/20100722 Firefox/3.6.8
Build Identifier: 

Now it is possible to enter every valid field in the serarch query. But that is the problem:
1. The serach mask says: "Only bugs with at least: ____ votes".
2. If you enter 50 you will get a query with "votes=50".
3. This ends with that result filter: "Votes: (is greater than) 49, Votes: 50"


Reproducible: Always
Version: 3.6.1:

http://www.bugzilla.org/releases/3.6.1/release-notes.html
"Search: For those who like to make their own buglist.cgi URLs (and for people working on customizations), buglist.cgi now accepts nearly every valid field in Bugzilla as a direct URL parameter, like &field=value"
Version: unspecified → 3.6.1
This is really blocking 3.6.3, but I'll change that when we have the flag.
Status: UNCONFIRMED → NEW
Ever confirmed: true
Flags: blocking3.6.2+
Summary: With the latest Bugzilla it is no longer possible to search for bugs with at least x votes → In Bugzilla 3.6, searching for bugs with at least X votes is broken
Target Milestone: --- → Bugzilla 3.6
The SQL query has:

WHERE ((bugs.votes > '3') AND ( bugs.votes IN ('4') ))


Bugzilla 3.4 doesn't have this 2nd condition.
For the record, Bugzilla 4.0 and 4.1 are not affected. So this is a 3.6 only regression.
Keywords: regression
Flags: blocking3.6.2+ → blocking3.6.3+
Is there any workaround for this in 3.6? Any query that I could use to show all bugs of a given product with more than 50 votes?
Attached patch v1Splinter Review
Here's a patch to fix it in 3.6.
Assignee: query-and-buglist → mkanat
Status: NEW → ASSIGNED
Attachment #472589 - Flags: review?(LpSolit)
Comment on attachment 472589 [details] [diff] [review]
v1

Cool, thanks for the fix. :) r=LpSolit
Attachment #472589 - Flags: review?(LpSolit) → review+
Flags: approval3.6+
Whiteboard: [3.6 only; 4.x not affected]
Hey, you're welcome! :-) Thanks for the review!

Committing to: bzr+ssh://bzr.mozilla.org/bugzilla/3.6/                         
modified Bugzilla/Search.pm
Committed revision 7169.
Status: ASSIGNED → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
Duplicate of this bug: 596890
Duplicate of this bug: 598005
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.