On 24/03/23 at 21:12 +0100, Lucas Nussbaum wrote: > On 24/03/23 at 20:52 +0100, Lucas Nussbaum wrote: > > Package: bugs.debian.org > > Severity: normal > > > > Hi, > > > > Two examples: > > > > 1/ #999526 is filed against the 'mdp' source. It affects testing, but > > there's no version-tracking graph, and the BTS does not recognize it > > affects testing. > > 'mdp' also happens to be a binary package from the 'mdp-src' source. > > > > 2/ Same situation with #965794, filed against the python-ooolib source. > > python-ooolib is also a binary package from the ooolib-python source. > > A UDD query to identify those (with some false positives): > select distinct b.* from bugs b > inner join packages_summary ps on (b.source = ps.package and b.source != > ps.source) > where severity>='serious' and b.package ~ '^src:' > order by id asc; > > Other occurences are: > #1031747 (not seen as affecting unstable). > #1025894 (not seen as affecting testing and unstable) > #997084 (not seen as affecting stable, testing, unstable)
Better SQL query: select distinct b.* from bugs b inner join packages_summary ps on (b.source = ps.package and b.source != ps.source) inner join packages_summary ps2 on (b.source = ps2.source) where b.package ~ '^src:' and not affects_oldstable and not affects_stable and not affects_testing and not affects_unstable and not affects_experimental order by id asc; Lucas