Closed Bug 521520 Opened 15 years ago Closed 11 years ago

advanced search for multiple boolean OR values returns no results

Categories

(Bugzilla :: Query/Bug List, defect)

3.2.4
defect
Not set
normal

Tracking

()

RESOLVED WORKSFORME

People

(Reporter: mdang, Unassigned)

References

()

Details

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 (.NET CLR 3.5.30729)
Build Identifier: 3.2

This advanced search for multiple boolean OR values of "Status Changed By mkanat@bugzilla.org" and "Status Changed by LpSolit@gmail.com" returns no results:

https://bugzilla.mozilla.org/buglist.cgi?query_format=advanced&short_desc_type=allwordssubstr&short_desc=&classification=Server+Software&product=Bugzilla&version=3.2&long_desc_type=substring&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&keywords_type=allwords&keywords=&emailassigned_to1=1&emailtype1=exact&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailtype2=exact&email2=&bugidtype=include&bug_id=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&order=Reuse+same+sort+as+last+time&field0-0-0=bug_status&type0-0-0=changedby&value0-0-0=mkanat%40bugzilla.org&field0-0-1=bug_status&type0-0-1=changedby&value0-0-1=LpSolit%40gmail.com

Doing each search individually works:
Status Changed By mkanat@bugzilla.org:
https://bugzilla.mozilla.org/buglist.cgi?query_format=advanced&short_desc_type=allwordssubstr&short_desc=&classification=Server+Software&product=Bugzilla&component=Query%2FBug+List&version=3.2&long_desc_type=substring&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&keywords_type=allwords&keywords=&emailassigned_to1=1&emailtype1=exact&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailtype2=exact&email2=&bugidtype=include&bug_id=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&order=Reuse+same+sort+as+last+time&field0-0-0=bug_status&type0-0-0=changedby&value0-0-0=mkanat%40bugzilla.org

Status Changed by LpSolit@gmail.com:
https://bugzilla.mozilla.org/buglist.cgi?query_format=advanced&short_desc_type=allwordssubstr&short_desc=&classification=Server+Software&product=Bugzilla&component=Query%2FBug+List&version=3.2&long_desc_type=substring&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&keywords_type=allwords&keywords=&emailassigned_to1=1&emailtype1=exact&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailtype2=exact&email2=&bugidtype=include&bug_id=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&order=Reuse+same+sort+as+last+time&field0-0-0=bug_status&type0-0-0=changedby&value0-0-0=LpSolit%40gmail.com



Reproducible: Always

Steps to Reproduce:
Perform the above searches.
Actual Results:  
No results are returned.

Expected Results:  
The results of both users should be listed.
The relevant part of the query is:

LEFT JOIN bugs_activity AS act_0 ON (act_0.bug_id = bugs.bug_id AND act_0.fieldid = 29 AND act_0.who = 73187) AND (act_0.bug_id = bugs.bug_id AND act_0.fieldid = 29 AND act_0.who = 120380)

Note the AND between both parentheses. It should be an OR. No idea why that's wrong. The problem still exists in Bugzilla 3.5.
Severity: major → normal
Status: UNCONFIRMED → NEW
Ever confirmed: true
OS: Linux → All
Hardware: x86 → All
Version: unspecified → 3.2.4
Target Milestone: --- → Bugzilla 3.4
Bugzilla 3.4 is now restricted to security bugs. We will retarget this bug (to 3.6 or later) when it's fixed.
Target Milestone: Bugzilla 3.4 → ---
This is still broken in Bugzilla 4.0.
query in comment 0 and comment 3 now wurk
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → WORKSFORME
You need to log in before you can comment on or make changes to this bug.