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.

Lucas

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)

Lucas

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