264192 - Cannot search where BugsThisDependsOn or OtherBugsDependingOnThis is empty

Status: RESOLVED FIXED

(Bugzilla :: Query/Bug List, defect, P3)

Description

[Nicko]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; rv:1.7.3) Gecko/20040913 Firefox/0.10
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; rv:1.7.3) Gecko/20040913 Firefox/0.10

Cannot search where BugsThisDependsOn or OtherBugsDependingOnThis is empty.

Using the boolean chart query I want to filter the search results to include
only bugs that are NOT blocked by any other bugs, i.e. where dependson
(OtherBugsDependingOnThis) is empty.

Because dependencies is a link table a natural join between the bugs and
dependencies table will only include rows where are included in both tables,
i.e. it will not include rows that don't have dependencies. To include these
rows an outer join can be performed, this will include all the rows from the
bugs table even where they do not match up against the dependencies table, null
values will be inserted where there is no corresponding row.

Reproducible: Always
Steps to Reproduce:
1.
2.
3.

Comment 1

[Max Kanat-Alexander]

OK, I'll look into this, if nobody else does, because we need it for PostgreSQL
support.

Tomas, if you (somehow, magically) have some free time, you can take this bug
from me, too. :-)

Comment 2

[Marc Schumann [:Wurblzap]]

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

Comment 3

[Dave Miller [:justdave]]

This is a bug, the bug it was duped against is a feature request.  I'd rather
not combine them if possible.

I originally reopened this thinking it was already fixed since we got negation,
but it does appear we still have the wrong join type on it.  I still think this
is a separate issue from searching on fields on the dependent bugs.

Comment 4

[Joel Peshkin]

Attachment: Patch - use left join

Comment 5

[Joel Peshkin]

Attachment: v2 - fully specify table name

Comment 6

[Max Kanat-Alexander]

Comment on attachment 175257 [details] [diff] [review]
v2 - fully specify table name

Hooray, it works! :-)

Comment 7

[Joel Peshkin]

Checking in Bugzilla/Search.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/Search.pm,v  <--  Search.pm
new revision: 1.84; previous revision: 1.83
done