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)
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.
Comment 1•15 years ago
|
||
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
Updated•15 years ago
|
Target Milestone: --- → Bugzilla 3.4
Comment 2•14 years ago
|
||
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 → ---
Comment 3•14 years ago
|
||
Same (similar?) problem when searching for multiple boolean values of: "Severity changed by LpSolit@gmail.com" OR "Status changed by LpSolit@gmail.com" This also returns Zarro Boogs: https://bugzilla.mozilla.org/buglist.cgi?field0-0-0=bug_severity&type0-0-1=changedby&field0-0-1=bug_status&classification=Server%20Software&query_format=advanced&version=3.2&value0-0-1=LpSolit%40gmail.com&type0-0-0=changedby&value0-0-0=LpSolit%40gmail.com&component=Query%2FBug%20List&product=Bugzilla
Comment 4•13 years ago
|
||
This is still broken in Bugzilla 4.0.
Comment 5•11 years ago
|
||
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.
Description
•