Bug 698703

Summary:	Booleans: Contains None of the strings not working
Product:	[Community] Bugzilla	Reporter:	Chris Ward <cward>
Component:	Query/Bug List	Assignee:	PnT DevOps Devs <hss-ied-bugs>
Status:	CLOSED WONTFIX	QA Contact:
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	3.6	CC:	pfrields
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-07-19 05:26:05 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Chris Ward 2011-04-21 14:46:17 UTC

Description of problem:

Take these two queries:

First query uses 'flags' 'Does not contain the string' 'blocker+'

https://bugzilla.redhat.com/buglist.cgi?type4-0-0=anywordssubstr&type1-0-0=anywordssubstr&type3-0-0=nowordssubstr&field0-0-0=product&value3-0-0=Tracking%2C%20ABIAssurance%2C%20Documentation%2C%20TestOnly&field4-0-0=bug_status&value2-0-0=CLOSED&value6-0-0=exception%2B&field2-0-0=bug_status&field6-0-0=flagtypes.name&field5-0-0=flagtypes.name&field3-0-0=keywords&type2-0-0=notequals&query_format=advanced&type5-0-0=notsubstring&value1-0-0=rhel-6.1.0%2B&type6-0-0=nowordssubstr&value5-0-0=blocker%2B&value4-0-0=NEW%2C%20ASSIGNED%2C%20MODIFIED%2C%20POST&type0-0-0=equals&value0-0-0=Red%20Hat%20Enterprise%20Linux%206&field1-0-0=flagtypes.name

Second query uses 'flags' Contains none of the strings' 'blocker+'

Actual results:
First query returns the expected results
Second query includes bugs which DO contain 'blocker+'; but these should be filtered out.

Expected results:
These two operators should work the same when only one 'string' value is used.
eg: these two statements should be equivalent (i would think)
'field' 'does not contain the string' 'ONE_VALUE'
'field' 'contains none of the strings' ONE_VALUE'

Additional info:
it might have something to do with the blocker+ value? this query return the correct results for both cases when i changed that boolean to 'keywords' '...' 'ONE_VALUE'... but i didn't test anything else.

Comment 1 Paul W. Frields 2011-11-22 14:58:29 UTC

Current BZ queries for RHEL 6.3 where this bug can be observed:

Uses 'flags' 'contains none of the strings' 'blocker+':

https://bugzilla.redhat.com/buglist.cgi?type4-0-0=anywordssubstr&type1-0-0=anywordssubstr&type3-0-0=nowordssubstr&field0-0-0=product&value3-0-0=Tracking%2C%20ABIAssurance%2C%20Documentation%2C%20TestOnly&field4-0-0=bug_status&value2-0-0=CLOSED&value6-0-0=exception%2B&field2-0-0=bug_status&field6-0-0=flagtypes.name&field5-0-0=flagtypes.name&field3-0-0=keywords&type2-0-0=notequals&query_format=advanced&type5-0-0=nowordssubstr&value1-0-0=rhel-6.3.0%2B&type6-0-0=nowordssubstr&value5-0-0=blocker%2B&value4-0-0=NEW%2C%20ASSIGNED%2C%20MODIFIED%2C%20POST&type0-0-0=equals&value0-0-0=Red%20Hat%20Enterprise%20Linux%206&field1-0-0=flagtypes.name

Uses 'flags' 'does not contain the string' 'blocker+':

https://bugzilla.redhat.com/buglist.cgi?type4-0-0=anywordssubstr&type1-0-0=anywordssubstr&type3-0-0=nowordssubstr&field0-0-0=product&value3-0-0=Tracking%2C%20ABIAssurance%2C%20Documentation%2C%20TestOnly&field4-0-0=bug_status&value2-0-0=CLOSED&value6-0-0=exception%2B&field2-0-0=bug_status&field6-0-0=flagtypes.name&field5-0-0=flagtypes.name&field3-0-0=keywords&type2-0-0=notequals&query_format=advanced&type5-0-0=notsubstring&value1-0-0=rhel-6.3.0%2B&type6-0-0=nowordssubstr&value5-0-0=blocker%2B&value4-0-0=NEW%2C%20ASSIGNED%2C%20MODIFIED%2C%20POST&type0-0-0=equals&value0-0-0=Red%20Hat%20Enterprise%20Linux%206&field1-0-0=flagtypes.name

Comment 2 Jeff Fearn 🐞 2012-05-30 04:38:49 UTC

As part of the recent Bugzilla 2.4 upgrade the Bugzilla team are cleaning up bugs opened against old versions of Bugzilla. This bug has been flagged as an old bug and will be CLOSED WONTFIX in 7 days time.

If you believe this bug is an issue in the latest Bugzilla version please comment on this bug within 7 days. Doing so will ensure this bug is not closed automatically.

Thanks, the Bugzilla team.

Comment 3 Jeff Fearn 🐞 2012-07-19 05:26:05 UTC

As noted previously, the Bugzilla Team is cleaning up a large number of outstanding issues that have bit rotted. This bug is being closed as there has been no response to that notification.

If you believe this bug is still important please reopen this bug in the NEW status and PM will consider it.

Comment 4 Paul W. Frields 2012-07-19 14:48:15 UTC

Should be OK to stay CLOSED, if these queries are good tests (revising links in comment #1 to target RHEL 6.4 instead):

https://bugzilla.redhat.com/buglist.cgi?type4-0-0=anywordssubstr&type1-0-0=anywordssubstr&type3-0-0=nowordssubstr&field0-0-0=product&value3-0-0=Tracking%2C%20ABIAssurance%2C%20Documentation%2C%20TestOnly&field4-0-0=bug_status&value2-0-0=CLOSED&value6-0-0=exception%2B&field2-0-0=bug_status&field6-0-0=flagtypes.name&field5-0-0=flagtypes.name&field3-0-0=keywords&type2-0-0=notequals&query_format=advanced&type5-0-0=nowordssubstr&value1-0-0=rhel-6.4.0%2B&type6-0-0=nowordssubstr&value5-0-0=blocker%2B&value4-0-0=NEW%2C%20ASSIGNED%2C%20MODIFIED%2C%20POST&type0-0-0=equals&value0-0-0=Red%20Hat%20Enterprise%20Linux%206&field1-0-0=flagtypes.name&list_id=314915

https://bugzilla.redhat.com/buglist.cgi?type4-0-0=anywordssubstr&type1-0-0=anywordssubstr&type3-0-0=nowordssubstr&field0-0-0=product&value3-0-0=Tracking%2C%20ABIAssurance%2C%20Documentation%2C%20TestOnly&field4-0-0=bug_status&value2-0-0=CLOSED&value6-0-0=exception%2B&field2-0-0=bug_status&field6-0-0=flagtypes.name&field5-0-0=flagtypes.name&field3-0-0=keywords&type2-0-0=notequals&query_format=advanced&type5-0-0=nowordssubstr&value1-0-0=rhel-6.4.0%2B&type6-0-0=nowordssubstr&value5-0-0=blocker%2B&value4-0-0=NEW%2C%20ASSIGNED%2C%20MODIFIED%2C%20POST&type0-0-0=equals&value0-0-0=Red%20Hat%20Enterprise%20Linux%206&field1-0-0=flagtypes.name&list_id=314915