How do we want CC list or commenter "does not match" to work??

[David Miller]

On 2/6/2004 11:54 AM -0800, Myk Melez wrote:

> Joel Peshkin wrote:
>
>>
>> I am looking for input from the development team on bug 226434.
>> http://bugzilla.mozilla.org/show_bug.cgi?id=226434
>>
>> Today, a search for CC list member doesn't match justdave, will return
>> every bug on which someone other than justdave is copied and there
>> seems to be no way to express that I am looking for bug on which
>> justdave is not copied.
>>
>> I believe I can teach Search.pm how to do this.  The question is....
>> how do we want this to look from the UI?
>
> We want it to look the same.  The overwhelming majority of people
> searching on "CC list member doesn't match justdave" are looking for
> bugs where justdave isn't on the list, not bugs where someone other than
> justdave is on the list, so we should make it work the way people expect.

The other question is....

how do you do it from SQL?

I can't think of any SQL to produce that which doesn't involve subselects
(and would probably be a major performance hit, even if we required a new
enough version of MySQL to do it that way).
-- 
Dave Miller      Project Leader, Bugzilla Bug Tracking System
http://www.justdave.net/             http://www.bugzilla.org/