[fdo-trac] #642: Sqlite filtering on number with more that 5 decimal fails

FDO trac_fdo at osgeo.org
Wed May 5 08:52:53 EDT 2010


#642: Sqlite filtering on number with more that 5 decimal fails
-------------------------------+--------------------------------------------
   Reporter:  bscott           |       Owner:  traianstanev
       Type:  defect           |      Status:  new         
   Priority:  major            |   Milestone:  3.5.0       
  Component:  SQLite Provider  |     Version:  3.5.0       
   Severity:  3                |    Keywords:              
External_id:                   |  
-------------------------------+--------------------------------------------
 I in a numeric field we have some values with more that 5 decimals the
 filter won't work

 example
 update table set column = 1.00001
 select * from table where column = 1.00001
 This works fine

 but
 update table set column = 1.000001
 select * from table where column = 1.000001
 does not return any records

 Bruno

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/642>
FDO <http://fdo.osgeo.org/>
Feature Data Objects


More information about the fdo-trac mailing list