543837 - add recursive "blocks" search from boolean charts

Status: NEW

(Bugzilla :: Query/Bug List, enhancement, P2)

Description

[Alan Crosswell]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6
Build Identifier: 

Is it possible to add a a boolean search of all bugs that ultimately block a given
bug?  For example, I want to do a search showing stuff nearing or past deadline
that rolls up to a parent bug.  Which deadline is a good question:  the root of the tree's or each bugs' deadline.  Hmmm...

Reproducible: Always

Comment 1

[Frédéric Buclin]

For PostgreSQL, it seems we need WITH:

http://www.postgresql.org/docs/8.4/static/queries-with.html

This doesn't seem to exist in MySQL.

Comment 2

[Frédéric Buclin]

Oh, WITH seems to only exists since Pg 8.4. :(

Comment 3

[Pami Ketolainen]

Attachment: Patch to include dependencies in queries based on bug IDs

We needed queries showing certain bugs and all their dependencies, so I created new operators for the bug_id field to get all bugs blocking or depending on the given bug ids.

The solution is quite hackish, but I couldn't figure out a better way to include the dependencies in the result.