Package: qa.debian.org User: qa.debian....@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.dur...@gmail.com> ----- From: Patrice Duroux <patrice.dur...@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-8y096qhwddff8tjsfttxayxouacv...@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 -----