337670 - query.cgi: NOT("Group" "is equal to" "Y") does not work

Status: RESOLVED WORKSFORME

(Bugzilla :: Query/Bug List, defect)

Description

[Ingolf Steinbach]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.0; de; rv:1.8.0.2) Gecko/20060308 Firefox/1.5.0.2
Build Identifier: 2.20, 2.20.1, 2.20.2

Our database is configured with product groups: for a certain product X, the bugs associated to this product are restricted to group X (mandatory).

Some of the bugs are additionally restricted to group Y.

There does not seem to be a good way to limit a search to those bugs of product X which are *not* restricted to group Y.

Reproducible: Always

Steps to Reproduce:
See details.
Actual Results:  
You can easily search for bugs which are restricted to Y -- there are several ways to do so, e.g. "Group" "is equal to" "Y". However, just negating the complete boolean chart leads to the wrong result: We now find *all* bugs associated to the product as each bug is in group X, so NOT("Group" "is equal to" "Y") matches.

Expected Results:  
Negating the "Group" "is equal to" "Y" chart should in my opinion display all bugs which are not restricted to Y.

Comment 1

[Marc Schumann [:Wurblzap]]

Dupe of bug 323905?

Comment 2

[Ingolf Steinbach]

Yes, Marc is right. I did not find this bug in the database (probably because I had searched for summaries including query.cgi).

*** This bug has been marked as a duplicate of 323905 ***

Comment 3

[Ingolf Steinbach]

Re-opened as a result of the discussion in bug 323905.
Also clarified the summary.

Comment 4

[Marc Schumann [:Wurblzap]]

Any chance to make this a blocker? For some reason, this started to crop up a lot around where I am, so it's kinda "locally major" by now.

Comment 5

[Frédéric Buclin]

I'm pretty sure this won't be taken as a blocker. But if someone can attach a patch very soon, that would be great.

Comment 6

[Max Kanat-Alexander]

No, strange boolean chart errors aren't release blockers.

Comment 7

[Marc Schumann [:Wurblzap]]

While I can (I hope) live with this not being a blocker, I cannot live with your reason for it not to be. This is not a strange error in Boolean Charts but an error in Boolean Chart basic functionality (this is me thinking "is equal to" to be a basic functionality).

Comment 8

[Max Kanat-Alexander]

(In reply to comment #7)
> While I can (I hope) live with this not being a blocker, I cannot live with
> your reason for it not to be. This is not a strange error in Boolean Charts but
> an error in Boolean Chart basic functionality (this is me thinking "is equal
> to" to be a basic functionality).

  Oh, okay. Yes, "is equal to" is a basic functionality.

  NOT(Group "is equal to") is not.

Comment 10

[Max Kanat-Alexander]

This should be working properly now, on trunk.

Comment 11

[Ingolf Steinbach]

Max, can you confirm that the fix is already included in 4.0 (or approved for inclusion in 4.0.1)?

Comment 12

[Max Kanat-Alexander]

(In reply to comment #11)
> Max, can you confirm that the fix is already included in 4.0 (or approved for
> inclusion in 4.0.1)?

  Hey Ingolf. The fix was only possible on the trunk--there was a huge refactoring of Search.pm that made this possible, so it won't be making it into 4.0.x.