udd.debian.org

On this site we show results of queries executed on the Ultimate Debian Database.

layout

The following table layout is used:

This layout is outdated; please look there for a more up-to-date version.

Debian packages and sources:
Ubuntu packages and sources:
Carnivore:
Upload history:
Testing migrations
Bugs:
- View bugs_rt_affects_stable:
  - SELECT id, package, source FROM bugs WHERE affects_stable AND (id NOT IN (SELECT id FROM bugs_tags WHERE tag IN ('sid', 'sarge', 'lenny', 'experimental')) OR id IN (SELECT id FROM bugs_tags WHERE tag = 'etch')) AND id NOT IN (select id FROM bugs_tags WHERE tag = 'etch-ignore') AND ( package IN (SELECT DISTINCT package FROM packages_summary p WHERE release = 'etch') OR source IN (SELECT DISTINCT package FROM sources WHERE release = 'etch'))
- View bugs_rt_affects_testing:
  - SELECT id, package, source FROM bugs WHERE affects_testing AND (id NOT IN (SELECT id FROM bugs_tags WHERE tag IN ('sid', 'sarge', 'etch', 'experimental')) OR id IN (SELECT id FROM bugs_tags WHERE tag = 'lenny')) AND id NOT IN (select id FROM bugs_tags WHERE tag = 'lenny-ignore') AND ( package IN (SELECT DISTINCT package FROM packages_summary p WHERE release = 'lenny') OR source IN (SELECT DISTINCT package FROM sources WHERE release = 'lenny'))
- View bugs_rt_affects_unstable:
  - SELECT id, package, source FROM bugs WHERE affects_unstable AND (id NOT IN (SELECT id FROM bugs_tags WHERE tag IN ('lenny', 'sarge', 'etch', 'experimental')) OR id IN (SELECT id FROM bugs_tags WHERE tag = 'sid')) AND ( package IN (SELECT DISTINCT package FROM packages_summary p WHERE release = 'sid') OR source IN (SELECT DISTINCT package FROM sources WHERE release = 'sid'))
- View bugs_rt_affects_testing_and_unstable:
  - SELECT id, package, source FROM bugs WHERE affects_unstable AND affects_testing AND (id NOT IN (SELECT id FROM bugs_tags WHERE tag IN ('sarge', 'etch', 'experimental')) OR (id IN (SELECT id FROM bugs_tags WHERE tag = 'sid') AND id IN (SELECT id FROM bugs_tags WHERE tag = 'lenny'))) AND ( package IN (SELECT DISTINCT package FROM packages p WHERE release = 'sid') OR source IN (SELECT DISTINCT package FROM sources WHERE release = 'sid')) AND ( package IN (SELECT DISTINCT package FROM packages p WHERE release = 'lenny') OR source IN (SELECT DISTINCT package FROM sources WHERE release = 'lenny'))
Orphaned packages:
Debian popcon:
Ubuntu popcon:
Linitian: