Bug#808540: qa.debian.org: udd: tables bugs & archived_bugs - column done_date always set to 1970-01-01 00:00:00

[Lucas Nussbaum <lucas@debian.org>]

On 20/12/15 at 17:51 +0100, Raphaël Walther wrote:
> Package: qa.debian.org
> User: qa.debian.org@packages.debian.org
> UserTags: udd
> Severity: normal
> 
> Hi,
> 
> I notice that the done_date in tables archived_bugs and bugs in udd is always set to 1970-01-01 00:00:00.
> 
> On a local réplica of udd:
> 
> loading=# select distinct done_date from archived_bugs;
>       done_date      
> ---------------------
>  1970-01-01 00:00:00
> (1 row)
> 
> loading=# select distinct done_date from bugs;
>       done_date      
> ---------------------
>  1970-01-01 00:00:00
> (1 row)
> 
> 
> I was expecting the date when the bug was marked done.
> 
> I don't have direct access to udd but I checked also in the dump and on public-udd-mirror.xvm.mit.edu.

Hi,

It seems that this wasn't properly tested when it was introduced, and
never worked. Unfortunately, we are dependent on the data Debbugs
exports.

So, I've just removed the column.

Lucas