[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