If you think a bug might affect users in the 57 release, please set the correct tracking and status flags for Release Management.

advanced search for multiple boolean OR values returns no results

RESOLVED WORKSFORME

Status

()

Bugzilla
Query/Bug List
RESOLVED WORKSFORME
8 years ago
4 years ago

People

(Reporter: Minh Dang, Unassigned)

Tracking

Details

(URL)

(Reporter)

Description

8 years ago
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

8 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

8 years ago
Target Milestone: --- → Bugzilla 3.4

Comment 2

8 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

7 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

6 years ago
This is still broken in Bugzilla 4.0.
query in comment 0 and comment 3 now wurk
Status: NEW → RESOLVED
Last Resolved: 4 years ago
Resolution: --- → WORKSFORME
You need to log in before you can comment on or make changes to this bug.