[fdo-trac] #643: Sqlite precision no handled on string data type

FDO trac_fdo at osgeo.org
Thu May 6 03:04:18 EDT 2010


#643: Sqlite precision no handled on string data type
-----------------------------+----------------------------------------------
 Reporter:  bscott           |         Owner:  traianstanev
     Type:  enhancement      |        Status:  assigned    
 Priority:  major            |     Milestone:  3.5.0       
Component:  SQLite Provider  |       Version:  3.5.0       
 Severity:  3                |    Resolution:              
 Keywords:                   |   External_id:              
-----------------------------+----------------------------------------------
Comment (by bscott):

 I've made a test with UseFdoMetadata=TRUE
 Recreating all my dataset from scratch.
 Now in the fdo_columns table i have this
   fdo_data_type = 4
   fdo_data_length = 20
   fdo_data_precision = 20
   fdo_data_scale = 8
 So seems allright

 But still got problem filtering on that field.
 The data itself are ok, i can insert or update any double values
 it's only the filtering that's get truncated

 This is very blocking as we oftenly save Lat and Lon values in databases
 and filtering with only 5 digit end ups with a big big error

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/643#comment:6>
FDO <http://fdo.osgeo.org/>
Feature Data Objects


More information about the fdo-trac mailing list