274532 - Adding an or to boolean charts reduced the number of bugs found

Status: VERIFIED DUPLICATE of bug 252889

(Bugzilla :: Query/Bug List, defect)

Description

[timeless]

First query:
https://bugzilla.mozilla.org/buglist.cgi?chfieldfrom=-1m&chfieldto=Now&chfield=%5BBug+creation%5D&field0-0-0=bug_group&type0-0-0=notequals&value0-0-0=0
(X bugs at time of filing)

Second query:
https://bugzilla.mozilla.org/buglist.cgi?chfieldfrom=-1m&chfieldto=Now&chfield=%5BBug+creation%5D&field0-0-0=bug_group&type0-0-0=notequals&value0-0-0=0&field0-0-1=bug_group&type0-0-1=changedto&value0-0-1=0
(X-2 bugs at time of filing)

I'm a member of security and webtools-security

Comment 1

[Dave Miller [:justdave]]

For reference,

Query #1 is:
Bugs between -1m and Now where [Bug creation] changed
Group     is not equal to        0

Query #2:
Bugs between -1m and Now where [Bug creation] changed
Group     is not equal to        0    OR
Group     changed to             0

(figured out by copying the URL and replacing buglist with query in the url)

First thing I have to say is that "group change to 0" will *never* happen,
because group is a multi-select field, not a single value.  That said, it
shouldn't reduce the number of hits obtained by the first part.

Oh!  "changed to" creates a join on the activity table, which would cause fewer
hits if two of those bugs had never had any changes made to them because the
joins were done incorrectly.  This was fixed in CVS the day after we upgraded
bmo.  I'll add it to my list of post-upgrade patches to take.

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