Red Hat Bugzilla – Bug 163572
notregex and notsubstring queries don't return all expected results
Last modified: 2015-01-04 18:18:57 EST
Description of problem: notregex and notsubstring queries seem to work against the status_whiteboard field, but don't return all expected results when used against the other *_whiteboards Version-Release number of selected component (if applicable): most recent RH bugzilla How reproducible: consistently Steps to Reproduce: 1. This query returns 22 Fedora DS bugs (since none of them contains regex "Screened" in the status_whiteboard field): https://bugzilla.redhat.com/bugzilla/buglist.cgi?query_format=&short_desc_type=allwordssubstr&short_desc=&product=Fedora+Directory+Server&component_text=&query_format=advanced&long_desc_type=substring&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=notregexp&status_whiteboard=Screened&fixed_in_type=allwordssubstr&fixed_in=&keywords_type=allwords&keywords=&cust_facing=&cust_facing_type=substring&emailassigned_to1=1&emailtype1=exact&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailcc2=1&emailtype2=exact&email2=&bugidtype=include&bug_id=&votes=&changedin=&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&order=Reuse+same+sort+as+last+time&field0-0-0=noop&type0-0-0=noop&value0-0-0= 2. Same query except changing status_whiteboard to either qa_ or devel_ or internal_whiteboard, it will only return 9 Fedora DS bugs (even though none of them contains regex "Screened" in the *_whiteboard field): https://bugzilla.redhat.com/bugzilla/buglist.cgi?query_format=&short_desc_type=allwordssubstr&short_desc=&product=Fedora+Directory+Server&component_text=&query_format=advanced&long_desc_type=substring&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&devel_whiteboard_type=notregexp&devel_whiteboard=Screened&fixed_in_type=allwordssubstr&fixed_in=&keywords_type=allwords&keywords=&cust_facing=&cust_facing_type=substring&emailassigned_to1=1&emailtype1=exact&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailcc2=1&emailtype2=exact&email2=&bugidtype=include&bug_id=&votes=&changedin=&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&order=Reuse+same+sort+as+last+time&field0-0-0=noop&type0-0-0=noop&value0-0-0= Actual results: The 2 queries return different results Expected results: Expect the 2 queries to return same results as all the same bugs contains the same empty *_whiteboard fields.
Red Hat's current Bugzilla version is 2.18. I am moving all older open bugs to this version. Any bugs against the older versions will need to be verified that they are still bugs. This will help me also to sort them better.
Red Hat Bugzilla is now using version 3.2 of the Bugzilla codebase and therefore this bug will need to be re-verified against the new release. With the updated code this bug may no longer be relevant or may have been fixed in the new code. Updating bug version to 3.2.
no reply == closed