Teams can have impossible email addresses

Bug #742524 reported by Curtis Hovey
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
Critical
Unassigned

Bug Description

A test in my branch revealed that mailing list addresses are not deleted when the mailing list is purged. This does not cause an immediate problem, but it is then possible to rename or merge the team, which will create a mismatch between the teams name and the list address. This can cause issues if another team wants the name that is free. Teams cannot see there is an issue since they can have only one email address; the views will not show the phantom address.

I have a branch that fixes this code issue. The bad email addresses can be deleted from the db when the fix is released.
    select t.name, e.email
    from person t join emailaddress e on e.person = t.id
    where t.teamowner is not null
    and e.email like '%launchpad.net'
    and e.email not like t.name || '@%'
    ;

Related branches

Curtis Hovey (sinzui)
Changed in launchpad:
status: In Progress → Fix Committed
tags: added: qa-ok
William Grant (wgrant)
Changed in launchpad:
status: Fix Committed → Fix Released
Curtis Hovey (sinzui)
Changed in launchpad:
assignee: Curtis Hovey (sinzui) → nobody
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.