package: bugs.debian.org

==
debbugs=> select a.bug_id, a.archived, b.type_id, c.bug_id, c.archived
from bug a join bug_assoc b on a.bug_id = b.from_id join bug c on
b.to_id = c.bug_id where a.archived = 'N' and c.archived = 'Y' and
b.type_id = 'MERGED_WITH';
 bug_id | archived |   type_id   | bug_id | archived
--------+----------+-------------+--------+----------
 518921 | N        | MERGED_WITH | 526519 | Y
(1 row)
==
doogie@busoni:/org/bugs.debian.org/spool$ grep Merged-With
db-h/21/518921.summary  archive/63/521863.summary
archive/19/526519.summary
db-h/21/518921.summary:Merged-With: 521863 526519
archive/63/521863.summary:Merged-With: 518921 526519
archive/19/526519.summary:Merged-With: 518921 521863
==



-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Reply via email to