Missing unique index on bugtask
Bug #417636 reported by
William Grant
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
High
|
Stuart Bishop |
Bug Description
There's a missing "UNIQUE (bug, productseries) WHERE productseries IS NOT NULL" constraint on the bugtask table; I can currently create multiple bugtasks on a bug for a single productseries. product tasks are constrained correctly, as are all distro-related tasks.
There could well be conflicting tasks in the production database, due to a missing check in IBugNomination.
Changed in malone: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
There are three bugs on production in this state. The UI seems to handle it, although it looks weird.
I'll fix this on production and backport the DB patch to launchpad/db-devel.