Bug#1064913: UDD/upload_history: strange values in the 'distribution' column

[Lucas Nussbaum <lucas@debian.org>]

Package: qa.debian.org
User: qa.debian.org@packages.debian.org
Usertags: udd

The email parsing that is at the core of the upload_history table
generates some erroneous values.

----- Forwarded message from Patrice Duroux <patrice.duroux@gmail.com> -----

From: Patrice Duroux <patrice.duroux@gmail.com>
To: debian-qa <debian-qa@lists.debian.org>
Date: Wed, 14 Feb 2024 19:36:24 +0100
Subject: remark about the UDD upload_history table
Message-ID: <[🔎] CAGKjw9LQN5_6KqgE+k-8Y096qhwDdFF8tJsfTtxAyxOUaCVWpw@mail.gmail.com>
X-Mailing-List: <debian-qa@lists.debian.org> archive/latest/25424
List-Id: <debian-qa.lists.debian.org>

Hi,

I am a bit surprised with the following output:

udd=> select distinct distribution from upload_history;
          distribution
---------------------------------
 experimental
 froxzen unstable
 froze unstable
 frozen
 frozen  unstable
 frozen unstable
 frozen unstable contrib
 frozen woody
 frozen-contrib contrib
 non-free
 rc-buggy
 sid
 sid=20
 stable
 stable frozen unstable
 stable unstable
 stable-security
 testing
 testing unstable
 testing-security
 unstable
 unstable  frozen
 unstable contrib
 unstable frozen
 unstable non-free
 unstable stable
 unstable stable frozen
 unstable testing
 unstable testing stable
 unstable unstable
 unstable=20
 woody-proposed-updates unstable
(32 lignes)


I am then not sure about the consistency of another SQL query based on
this column value.

Regards,
Patrice



----- End forwarded message -----