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.
Revision history for this message
| Stuart Bishop (stub) wrote | #1 |
| Changed in malone: | |
| status: | New → Triaged |
| importance: | Undecided → High |
| assignee: | nobody → Stuart Bishop (stub) |
| milestone: | none → 3.0 |
Revision history for this message
| Diogo Matsubara (matsubara) wrote Bug fixed by a commit | #2 |
| Changed in malone: | |
| status: | Triaged → Fix Committed |
| 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.