Bug 553938 - Filtering against bug_status has stopped working for some bookmarked query URLs (attribute ordering?)
Summary: Filtering against bug_status has stopped working for some bookmarked query UR...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Bugzilla
Classification: Community
Component: Query/Bug List
Version: 3.4
Hardware: All
OS: Linux
low
medium
Target Milestone: ---
Assignee: David Lawrence
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2010-01-09 16:47 UTC by Dave Malcolm
Modified: 2013-06-24 03:37 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2010-01-11 21:58:27 UTC
Embargoed:


Attachments (Terms of Use)

Description Dave Malcolm 2010-01-09 16:47:19 UTC
Description of problem:
Some of my URLs into bugzilla have changed behavior

I have URLs bookmarked that attempt to retrieve all open bugs matching some criteria.  I did this using the Advanced Search page, by listing all "bug_status" values other than "CLOSED".

An example query is this:
https://bugzilla.redhat.com/buglist.cgi?query_format=advanced&classification=Fedora&component=python&component=python-docs&bug_status=NEW&bug_status=ASSIGNED&bug_status=MODIFIED&bug_status=ON_DEV&bug_status=ON_QA&bug_status=VERIFIED&bug_status=FAILS_QA&bug_status=RELEASE_PENDING&bug_status=POST

i.e.
  - query_format=advanced
  - classification=Fedora
  - component=python&component=python-docs
  - bug_status= every bug status other than CLOSED

Previously these would filter out the CLOSED bugs; the above query would give "44 bugs found."

As of 2010-01-09 this query now includes all CLOSED bugs, giving me "375 bugs found".

Interestingly, if I use the "Edit Search" feature on the above query, the "Status" information is blank in the web UI; if I reenter the statuses, I get this URL, which (correctly) gives me "44 bugs found.":
https://bugzilla.redhat.com/buglist.cgi?query_format=advanced&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&component=python&component=python-docs&classification=Fedora

i.e.:
 - query_format=advanced
 - bug_status= every bug status other than CLOSED
 - component=python&component=python-docs
 - classification=Fedora

which appears to be the same URL as above, only with the attributes in a different order.  (has the new code introduced some ordering assumptions into the attributes?)

Version-Release number of selected component (if applicable):
Front page identifies itself as "version 3.4.4+"

This started happening on the morning of Saturday 2010-01-09 (Friday night upgrade?)

How reproducible:
100%

Other info:
https://bugzilla.redhat.com/buglist.cgi?product=Fedora&component=python,python-docs&bug_status=__open__ correctly lists 44

Comment 1 David Lawrence 2010-01-11 04:37:43 UTC
This is because we recently removed the FAILS_QA status and the code in Bugzilla is incorrectly comparing the number of statuses in your query URL with the actual number of statuses now in the system. If the two numbers match then Bugzilla assumes you want all statuses and removes the criteria altogether to make the SQL simpler. This is not the smartest way to do it.

1. I will fix the code to work properly
2. Until then you can remove bug_status=FAILS_QA from your bookmarks, stored queries, etc.

Dave

Comment 2 David Lawrence 2010-01-11 21:03:22 UTC
This should be fixed now on live. Can you verify that your bookmarks are working again?

Dave

Comment 3 Dave Malcolm 2010-01-11 21:09:33 UTC
Yes - my old bookmarks URLs are now working again

Thanks!


Note You need to log in before you can comment on or make changes to this bug.