bugs in the unofficial RC bug tracker @ turmzimmer

[Lucas Nussbaum <lucas@lucas-nussbaum.net>]

Hi,

I investigated some differences between http://bts.turmzimmer.net/details.php
and what UDD sees, and found out that the unofficial RC bug tracker
seems to be missing quite a lot of bugs.

The main problem seems to be that it doesn't know about the 'src:'
syntax (examples: #577321, #577364).

It also seems wrong about other bugs, though it's harder to understand
what it does wrong in those cases.

As a result, where turmzimmer sees 437 RC bugs in the default view, I
see 565 bugs affecting sid or squeeze with the following query:
 select id, source, package, affects_testing, affects_unstable from bugs
 where severity >= 'serious' and (affects_unstable or affects_testing)
 and source in (select source from sources where release = 'squeeze')
 and id not in (select id from bugs_tags where tag='squeeze-ignore')
 and id not in (select id from bugs_merged_with where id > merged_with);

Affecting squeeze:
 select id, source, package, affects_testing, affects_unstable from bugs
 where severity >= 'serious' and affects_testing
 and source in (select source from sources where release = 'squeeze')
 and id not in (select id from bugs_tags where tag='squeeze-ignore')
 and id not in (select id from bugs_merged_with where id > merged_with);
=> 482

Affecting squeeze only:
 select id, source, package, affects_testing, affects_unstable from bugs
 where severity >= 'serious' and affects_testing and not affects_unstable
 and source in (select source from sources where release = 'squeeze')
 and id not in (select id from bugs_tags where tag='squeeze-ignore')
 and id not in (select id from bugs_merged_with where id > merged_with);
=> 157

If someone is interested in rewriting the unofficial RC bug tracker
using UDD, I could provide some help with the SQL part.

- Lucas