Re: First working prototype - Was: Re: Triplification of bugs in UDD

2009-09-03 Thread Olivier Berger
Le jeudi 03 septembre 2009 à 17:45 +0200, Lucas Nussbaum a écrit : > > > > > > > > So if there's a table that directly maps those SHA1 of the mailto:email > > > > of the current carnivore_email and of the current bugs:submitter, that > > > > will be really straightforward to make the query and for

Re: First working prototype - Was: Re: Triplification of bugs in UDD

2009-09-03 Thread Lucas Nussbaum
On 03/09/09 at 17:15 +0200, Olivier Berger wrote: > Le jeudi 03 septembre 2009 à 16:33 +0200, Lucas Nussbaum a écrit : > > On 03/09/09 at 15:25 +0200, Olivier Berger wrote: > > > Le jeudi 03 septembre 2009 à 14:29 +0200, Lucas Nussbaum a écrit : > > > > On 28/07/09 at 20:13 +0200, Olivier Berger wr

Re: First working prototype - Was: Re: Triplification of bugs in UDD

2009-09-03 Thread Olivier Berger
Le jeudi 03 septembre 2009 à 16:33 +0200, Lucas Nussbaum a écrit : > On 03/09/09 at 15:25 +0200, Olivier Berger wrote: > > Le jeudi 03 septembre 2009 à 14:29 +0200, Lucas Nussbaum a écrit : > > > On 28/07/09 at 20:13 +0200, Olivier Berger wrote: > > > > Only small minor additions to the postgres DB

Bug#538440: qa.debian.org: non-ascii characters in uploader name are displayed incorrectly

2009-09-03 Thread Stéphane Glondu
Євгеній Мещеряков a écrit : > 0.9.6.5-2 > > It looks like UTF-8 is handled like latin1 again. There was a similar bug > before (#479536). Indeed. I've started to investigate. It looks like data are already double-UTF8-encoded in input database: glo...@merkel:/org/qa.debian.org/data/ddpo/results

Re: First working prototype - Was: Re: Triplification of bugs in UDD

2009-09-03 Thread Lucas Nussbaum
On 03/09/09 at 15:25 +0200, Olivier Berger wrote: > Le jeudi 03 septembre 2009 à 14:29 +0200, Lucas Nussbaum a écrit : > > On 28/07/09 at 20:13 +0200, Olivier Berger wrote: > > > Only small minor additions to the postgres DB are necessary to make > > > triplify work : a sha1 function and a table to

Re: First working prototype - Was: Re: Triplification of bugs in UDD

2009-09-03 Thread Olivier Berger
Le jeudi 03 septembre 2009 à 14:29 +0200, Lucas Nussbaum a écrit : > On 28/07/09 at 20:13 +0200, Olivier Berger wrote: > > Only small minor additions to the postgres DB are necessary to make > > triplify work : a sha1 function and a table to match emails to their > > sha1 mailto: hashes. > > I'm n

Re: First working prototype - Was: Re: Triplification of bugs in UDD

2009-09-03 Thread Lucas Nussbaum
On 28/07/09 at 20:13 +0200, Olivier Berger wrote: > Only small minor additions to the postgres DB are necessary to make > triplify work : a sha1 function and a table to match emails to their > sha1 mailto: hashes. I'm not sure I understand how you plan to use this. If we have a table with all the