Bug 681474

Summary: strange behaviour of "AND"/"OR" search in Flags
Product: [Community] Bugzilla Reporter: Martin Kudlej <mkudlej>
Component: Query/Bug ListAssignee: Simon Green <sgreen>
Status: CLOSED WONTFIX QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 3.6CC: cward, ebaak, sgreen
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-05-09 23:25:34 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Martin Kudlej 2011-03-02 10:03:47 UTC 
Description of problem:
I've tried to search bugs where Flags contain "pm_ack+" AND "devel_ack+" AND "mrg-2.0.0", so I've used "Advanced Searching Using Boolean Charts".
I've put there those 3 conditions like this:
Flags contains the string mrg-2.0.0
AND
Flags contains the string pm_ack+
AND
Flags contains the string devel_ack+

and it found no bug.

If I've put there 
Flags contains the string mrg-2.0.0
OR
Flags contains the string pm_ack+
OR
Flags contains the string devel_ack+

It found those bugs, which I would see.

Version-Release number of selected component (if applicable):
version 3.6.3+

Do I anything wrong?

How reproducible:
100%

Actual results:
And/or don't mean and/or.

Expected results:
AND will be AND and OR will be OR. 

Additional info:
AND url:
https://bugzilla.redhat.com/buglist.cgi?type0-1-0=substring&field0-1-0=flagtypes.name&field0-0-0=flagtypes.name&classification=Red%20Hat&query_format=advanced&value0-2-0=devel_ack&value0-1-0=pm_ack&bug_status=NEW&bug_status=ASSIGNED&bug_status=MODIFIED&bug_status=ON_DEV&bug_status=ON_QA&bug_status=VERIFIED&bug_status=RELEASE_PENDING&bug_status=POST&bug_status=CLOSED&field0-2-0=flagtypes.name&type0-0-0=substring&value0-0-0=mrg-2.0.0&type0-2-0=substring&component=grid&component=grid-condor&component=grid-condor-ec2-enhanced&component=grid-condor-ec2-enhanced-hooks&component=grid-condor-job-hooks&component=grid-condor-low-latency&component=grid-condor-qmf&component=grid-condor-vm-gahp&component=grid-condor-wallaby-base-db&component=grid-condor-wallaby-client&component=grid-condor-wallaby-tools&component=grid-ruby-rhubarb&component=grid-ruby-spqr&component=grid-wallaby&component=grid-wallaby-utils&product=Red%20Hat%20Enterprise%20MRG

OR url:
https://bugzilla.redhat.com/buglist.cgi?type1-0-0=substring&field0-0-0=flagtypes.name&columnlist=priority%2Cassigned_to%2Cbug_status%2Ccomponent%2Cshort_desc%2Cflags%2Ctarget_milestone%2Ckeywords&value2-0-0=devel_ack%2B&field2-0-0=flagtypes.name&classification=Red%20Hat&query_based_on=mrg-2.0&type2-0-0=substring&query_format=advanced&value1-0-0=pm_ack%2B&bug_status=MODIFIED&bug_status=ON_DEV&bug_status=ON_QA&bug_status=VERIFIED&bug_status=RELEASE_PENDING&bug_status=POST&type0-0-0=substring&value0-0-0=mrg-2.0.0&component=grid&component=grid-condor&component=grid-condor-ec2-enhanced&component=grid-condor-ec2-enhanced-hooks&component=grid-condor-job-hooks&component=grid-condor-low-latency&component=grid-condor-qmf&component=grid-condor-vm-gahp&component=grid-condor-wallaby-base-db&component=grid-condor-wallaby-client&component=grid-condor-wallaby-tools&component=grid-ruby-rhubarb&component=grid-ruby-spqr&component=grid-wallaby&component=grid-wallaby-utils&field1-0-0=flagtypes.name&product=Red%20Hat%20Enterprise%20MRG&known_name=mrg-2.0
Comment 1 Chris Ward 2011-12-14 11:29:48 UTC 
See https://bugzilla.redhat.com/show_bug.cgi?id=428173#c7
Comment 2 Simon Green 2012-05-09 23:25:34 UTC 
Bugzilla 3.6 is in maintenance only mode at the moment, with Bugzilla 4.2 being released in less than a fortnight.

The searching code in Bugzilla 4.2 has been completely rewritten, and will be able to handle the search that you need.

  -- simon