bug search form filters interact poorly with context filters on the same fields

This happens because the code ends up doing a search for "Bugs assigned to pitti" OR "Bugs owned-by/subscribed-to ubuntu-main-sponsors". We'll have a similar problem if you try to filter by bug reporter (as that'll generate a search for "Bugs reported by <foo>" OR "Bugs subscribed/assigned to <bar>".

To fix this we need to do a search for "Bugs assigned to pitti AND reported by ubuntu-main-sponsors" OR "Bugs assigned to pitti AND to which ubuntu-main-sponsors is subscribed to".

On Tue, Jul 24, 2007 at 02:14:14PM -0000, Guilherme Salgado wrote:
> This happens because the code ends up doing a search for "Bugs assigned
> to pitti" OR "Bugs owned-by/subscribed-to ubuntu-main-sponsors". We'll
> have a similar problem if you try to filter by bug reporter (as that'll
> generate a search for "Bugs reported by <foo>" OR "Bugs
> subscribed/assigned to <bar>".
>

Strike that -- it's not what happens.

We're in fact doing a search for "Bugs assigned to pitti" UNION "Bugs assigned
to pitti AND subscribed by ubuntu-main-sponsors" UNION "Bugs assigned to pitti
AND reported by ubuntu-main-sponsors". And since there are no bugs which
match the two final clauses we end up with all the bugs assigned to pitti.

> To fix this we need to do a search for "Bugs assigned to pitti AND
> reported by ubuntu-main-sponsors" OR "Bugs assigned to pitti AND to
> which ubuntu-main-sponsors is subscribed to".

This would be the correct fix, still.

Bjorn will re-assign to someone else.
The branch: bzr+ssh://devpad.canonical.com/code/matsubara/launchpad/bug-127055
contains a couple of tests and a partial fix.

As seen in bug #187897 the same issue happens when searching for subscriber

Untargeting this for now to help with planning. Will retarget it later.