Re: remark about the UDD upload_history table
Hi,
> Le mer. 14 févr. 2024 à 19:36, Patrice Duroux
> <patrice.duroux@gmail.com> a écrit :
> >
> > Hi,
> >
> > I am a bit surprised with the following output:
> >
> > udd=> select distinct distribution from upload_history;
> > distribution
> > ---------------------------------
I filed a bug about that, but unfortunately the whole upload_history
gatherer code is fragile, because it is based on parsing the mailing
list archives... So I'm not sure this will be fixed at some point.
On 19/02/24 at 11:15 +0100, Patrice Duroux wrote:
> Hi,
>
> May I also suggest renaming this 'upload_history.distribution' column
> to 'upload_history.release' for a better consistency with the other
> tables that have the two columns (distribution and release)?
UDD generally follows the naming from the source data. I agree that
there's some confusion between distribution and release that requires
extra care when writing queries, but I don't think that we should change
that at this point given it would be an API change and there might be
external consumers of the raw (SQL) data.
Lucas
Reply to: