bugs.submitter_email problems Was: Re: Triplification of bugs in UDD

[Olivier Berger <olivier.berger@it-sudparis.eu>]

Hi.

FYI, there are a few bugs whose submitters don't have a valid email
address :
SELECT id, submitter, submitter_email FROM bugs WHERE submitter_email NOT LIKE '%@%'

Some come from the parsing done at injection, and others from bad bug
reports, I suppose.

Maybe you'd like to check these ?

Best regards,

Le vendredi 24 juillet 2009 à 18:43 +0200, Lucas Nussbaum a écrit :
> On 24/07/09 at 18:05 +0200, Olivier Berger wrote:
> > The hard part is the change in the database schema to split the
> > submitters email into name and email, to easily be able to match
> > carnivore entries with bug submitters (for some outdated explanations of
> > the views I used for doing so, see [1]).
> 
> This is now implemented in UDD (also for bug owners, and for the 'done'
> field -- bug closers). The columns should populate during the next run
> of the importers.
> -- 
> | Lucas Nussbaum
> | lucas@lucas-nussbaum.net   http://www.lucas-nussbaum.net/ |
> | jabber: lucas@nussbaum.fr             GPG: 1024D/023B3F4F |
> 
> 
-- 
Olivier BERGER <olivier.berger@it-sudparis.eu>
http://www-public.it-sudparis.eu/~berger_o/ - OpenPGP-Id: 1024D/6B829EEC
Ingénieur Recherche - Dept INF
Institut TELECOM, SudParis (http://www.it-sudparis.eu/), Evry (France)