305563 - contains none of the keywords does not work

Status: RESOLVED WORKSFORME

(Bugzilla :: Query/Bug List, defect)

Description

[Bernd Eckenfels]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; de-DE; rv:1.7.10) Gecko/20050717 Firefox/1.0.6
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; de-DE; rv:1.7.10) Gecko/20050717 Firefox/1.0.6

I I search in 2.20rc and specify "contains none of the keywords" with an
existing keyord (no substring all uppercase) bugs show up in the result even if
the keyword is resent.

Workaround to use boolean chart "does not contain substring" works.

Reproducible: Always

Steps to Reproduce:
advanced search for all open bugs "keywords does contain none of the keywords":
ALPHATEST
Actual Results:  
got a list with bugs which have keyword "ALPHATEST" and bugs with "ALPHATEST,PA"

Expected Results:  
list where no bug shows up which has the keyword present.

Comment 1

[Bernd Eckenfels]

ok i found my problem it is related to the fact, that the mysql colation for
this table/column was latin1_bin and not the case insensitive version, since the
query looks like:

SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bug_status,
bugs.resolution, bugs.bug_severity, bugs.priority, bugs.rep_platform,
map_assigned_to.login_name, bugs.bug_status, bugs.resolution, bugs.short_desc
FROM bugs INNER JOIN profiles AS map_assigned_to ON (bugs.assigned_to =
map_assigned_to.userid) LEFT JOIN bug_group_map ON bug_group_map.bug_id =
bugs.bug_id AND bug_group_map.group_id NOT IN (10,3,8,11,4,1,6,12,9,2,5,7) LEFT
JOIN cc ON cc.bug_id = bugs.bug_id AND cc.who = 1 WHERE ((bugs.bug_status IN
('NEW','ASSIGNED','REOPENED')) AND (NOT (bugs.keywords REGEXP
'(^|[^a-z0-9])alphatest($|[^a-z0-9])'))) AND bugs.creation_ts IS NOT NULL AND
((bug_group_map.group_id IS NULL) OR (bugs.reporter_accessible = 1 AND
bugs.reporter = 1) OR (bugs.cclist_accessible = 1 AND cc.who IS NOT NULL) OR
(bugs.assigned_to = 1) OR (bugs.qa_contact = 1) ) GROUP BY bugs.bug_id ORDER BY
bugs.bug_id

this did not work. However I wonder why the keyword (ALPHATES) is lower-cased in
this query at all?

Comment 2

[Joel Peshkin]

You have a keyword with a comma in it?

The query assumes that keywords are all made up of a-z0-9 characters. 

Comment 3

[Frédéric Buclin]

I cannot reproduce using Bugzilla 3.5.