[Bugs] #1342 IMME: range queries use lexical comparison, not numerical

[Sugar Labs Bugs]

#1342: range queries use lexical comparison, not numerical
--------------------------------+-------------------------------------------
    Reporter:  sascha_silbe     |          Owner:  sascha_silbe     
        Type:  defect           |         Status:  new              
    Priority:  Immediate        |      Milestone:  0.86             
   Component:  sugar-datastore  |        Version:  Git as of bugdate
    Severity:  Minor            |       Keywords:                   
Distribution:  Unspecified      |   Status_field:  Assigned         
--------------------------------+-------------------------------------------
Changes (by sascha_silbe):

  * keywords:  r? =>


Comment:

 Replying to [comment:10 tomeu]:
 > But if we know that timestamp is a serialized decimal number, why not
 treat it as such in find()?
 That's exactly what I said above:

 > For that to work we need to add type information to _QUERY_VALUE_MAP (or
 special-case timestamp somewhere else in the code) so we know we need to
 convert the string to an integer first.

 We can special-case timestamp in find(), but since the impact for 0.86 is
 minimal I'd rather modify the generic code for 0.88 so it works for other
 properties (that didn't make it into 0.86 but hopefully will for 0.88) as
 well.

-- 
Ticket URL: <http://bugs.sugarlabs.org/ticket/1342#comment:11>
Sugar Labs <http://sugarlabs.org/>
Sugar Labs bug tracking system