Description of problem:
Certain queries, using "Advanced Searching Using Boolean Charts", do not return the expected result sets, and this does not refer to issues with respect to logical precedence, which is a separate issue.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Go to the following URL:
2. Check the parameters, i.e. NEW or ASSIGNED bugs against the Bugzilla Metrics View product, where I am either the Assignee, or the Attachment creator.
3. Click on [Search]
The list of bugs which have attachments, where I am either the Assignee, or the Attachment creator.
The list of bugs, where I am either the Assignee, or the Attachment creator, irrespective of whether these bugs have attachments, or not.
Seems like Bugzilla applies the wrong join here, i.e. an ordinary INNER JOIN, instead of a LEFT OUTER JOIN. If I'm asking for all bugs where I am the Assignee, OR something else, I at least expect all bugs where I am the Assignee. Currently, I do not get any bugs which do not have any attachments.
Red Hat Bugzilla is now using version 3.4 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.4.
Red Hat has now upgraded to Bugzilla 3.6 and this bug will now be reassigned to that version. It would be helpful to the Bugzilla Development Team if this bug is verified to still be an issue with the latest version. If it is no longer an issue, then feel free to close, otherwise please comment that it is still a problem and we will try to address the issue as soon as we can.
Bugzilla Development Team
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.
This requires testing, to see whether it still is an issue. I can have a test run within the next couple of days.
(In reply to comment #0)
> Actual results:
> The list of bugs which have attachments, where I am either the Assignee, or
> the Attachment creator.
> Expected results:
> The list of bugs, where I am either the Assignee, or the Attachment creator,
> irrespective of whether these bugs have attachments, or not.
I disagree. If you specify 'Attachment creator' 'is equal to' 'email@example.com', then if a bug didn't have an attachment, it wouldn't be listed. In any case, with Bugzilla 4.2 you can write more advance queries that do you what you want. For example, 'NOT' 'Attachment creator' 'is not equal to' 'firstname.lastname@example.org'
You disagree? I've just done a test run, and yes, it does the right thing in Bugzilla 4.2, i.e. if you say 'Attachment creator' 'is equal to' 'email@example.com' OR 'Assignee' 'is equal to' 'firstname.lastname@example.org', you'll get the bugs where I am the Assignee, even if these have no attachments. Surely, you can't disagree with that, or? But I can confirm the issue has been fixed in 4.2.