Modify ↓
      
Opened 19 years ago
Closed 19 years ago
#3382 closed defect (duplicate)
enumeration values should be numeric
| Reported by: | Owned by: | Jonas Borgström | |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | ticket system | Version: | devel | 
| Severity: | normal | Keywords: | postgresql | 
| Cc: | elmar.fasel@… | Branch: | |
| Release Notes: | |||
| API Changes: | |||
| Internal Changes: | |||
Description
If one specifies more than 9 items for a AbstractEnum subclass, it becomes apparent that the order used is lexicographic instead of numeric. Which is of course undesirable.
The quick fix (at least for postgres) was to add a
CAST (value AS NUMERIC)
at the respective locations( model.py and query.py)
The better solution would be to use a numeric type as value the first hand.
Attachments (0)
Change History (3)
comment:1 by , 19 years ago
| Cc: | added | 
|---|
comment:2 by , 19 years ago
comment:3 by , 19 years ago
| Keywords: | postgresql added | 
|---|---|
| Resolution: | → duplicate | 
| Status: | new → closed | 
  Note:
 See   TracTickets
 for help on using tickets.
    


  
See also #3544.