Closed Bug 880315 Opened 11 years ago Closed 11 years ago

malformed sql generated as a result of bug 879055

Categories

(Bugzilla :: Query/Bug List, defect, P1)

Tracking

()

RESOLVED FIXED
Bugzilla 4.4

People

(Reporter: glob, Assigned: glob)

References

Details

(Keywords: regression)

Attachments

(1 file)

the query:

buglist.cgi?bug_status=NEW&bug_status=ASSIGNED&bugidtype=include&chfieldfrom=-2d&chfieldto=Now&product=Core&product=Firefox&product=Thunderbird&product=Toolkit&query_format=advanced&short_desc= &short_desc_type=allwordssubstr&order=changeddate%2Cbug_status%2Cpriority%2Cassigned_to%2Cbug_id&limit=0

results in:

SELECT bugs.bug_id AS bug_id, bugs.delta_ts AS changeddate, bugs.bug_status AS bug_status, bugs.priority AS priority, map_assigned_to.login_name AS assigned_to FROM bugs ... OR bugs.assigned_to = 13647 OR bugs.qa_contact = 13647) AND () AND bugs.bug_status IN ('NEW','ASSIGNED') AND bugs.product_id IN (1,21,23,30) AND bugs.delta_ts >= '2013-06-05 00:40:17' GROUP BY bugs.bug_id ..

note "AND ()" which is a sql error.
Severity: normal → major
Flags: blocking4.4.1+
Keywords: regression
Target Milestone: --- → Bugzilla 4.4
Attached patch patch v1 β€” β€” Splinter Review
Attachment #759233 - Flags: review?(LpSolit)
Comment on attachment 759233 [details] [diff] [review]
patch v1

Looks good. r=LpSolit assuming you tested it.
Attachment #759233 - Flags: review?(LpSolit) → review+
Flags: approval4.4+
Flags: approval+
Committing to: bzr+ssh://bjones%40mozilla.com@bzr.mozilla.org/bugzilla/trunk/
modified Bugzilla/Search.pm
Committed revision 8635.

Committing to: bzr+ssh://bjones%40mozilla.com@bzr.mozilla.org/bugzilla/4.4/
modified Bugzilla/Search.pm
Committed revision 8567.
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Creator:
Created:
Updated:
Size: