Bug#993805: UDD: duplicate entries for the same release

[Sandro Tosi <morph@debian.org>]

Package: qa.debian.org
Severity: normal
X-Debbugs-Cc: morph@debian.org

Hello,
I noticed how some packages have duplicate entries in UDD.sources for the same
release:


udd=> select source, version, release from sources where source = 'setuptools-scm' and release = 'sid';
     source     | version | release
----------------+---------+---------
 setuptools-scm | 4.1.2-3 | sid
 setuptools-scm | 6.0.1-1 | sid


and AFAICS there's no reason setuptools-scm/4.1.2-3 should be in sid (it was
uploaded between oldstable and stable).

Turns out, there are more than 600 pkgs in this state:


udd=> select count (*) from (select source, release, count(*) from sources where release = 'sid' group by 1, 2  having count(*) > 1) as x;
 count
-------
   602
(1 row)


Is this something do address within UDD import process or the entries are coming
from someplace else? if the latter, please forward this bug to the appropriate
team/package.

Regards,
Sandro