[Trac-tickets] Re: [The Trac Project] #3490: "priority" management is riddled with bugs

[The Trac Project]

#3490: "priority" management is riddled with bugs
-------------------------------+--------------------------------------------
 Reporter:  jrf at metacarta.com  |        Owner:  mgood
     Type:  defect             |       Status:  new  
 Priority:  normal             |    Milestone:  0.10 
Component:  general            |      Version:  0.9.6
 Severity:  normal             |   Resolution:       
 Keywords:                     |  
-------------------------------+--------------------------------------------
Changes (by mgood):

  * owner:  jonas => mgood
  * milestone:  => 0.10

Comment:

 Can you give some more explanation of your statement that deleted
 priorities are "orphaning" tickets?  Please give an example of the effect
 you're seeing on the tickets that are associated with a deleted priority.

 The problem with the priority example above seems to be an issue with
 SQLite's "typeless" columns.  It's calculating the max textually, so "9"
 is greater than "10", thus after the value "9" is reached all subsequent
 values are assigned "10".  So, "a9" and "a10" both got "10" for their
 value, thus they both get deleted together.  I can fix this one.

-- 
Ticket URL: <http://trac.edgewall.org/ticket/3490#comment:2>
The Trac Project <http://trac.edgewall.com/>