Launchpad itself

Specification.information_type does not support efficient queries

Bug #1039188 reported by Aaron Bentley
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Aaron Bentley

Bug Description

Specification.information_type is intended to be used as a filter criterion, and there are many Specifications, but information_type has no index. This was deliberately done to reduce the cost of introducing the duration required to introduce the column, but must now be fixed before the column can be used for its intended purpose.

Related branches

lp:~abentley/launchpad/blueprint-info-type-idx
Stuart Bishop (community): Approve (db)
Robert Collins: Pending (db) requested
Diff: 12 lines (+8/-0)
1 file modified
database/schema/patch-2209-28-2.sql (+8/-0)
Aaron Bentley (abentley)
Changed in launchpad:
status: Triaged → In Progress
Revision history for this message
Launchpad QA Bot (lpqabot) wrote :

Fixed in stable r15850 (http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/15850) by a commit, but not testable.

tags: added: qa-untestable
Changed in launchpad:
status: In Progress → Fix Committed
Steve Kowalik (stevenk)
Changed in launchpad:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

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