[Fdo-trac] [fdo-trac] #870: Oracle ODBC: read double values from NUMBER & FLOAT columns, map to wrong RDBI type

[FDO]

#870: Oracle ODBC: read double values from NUMBER & FLOAT columns, map to wrong
RDBI type
-----------------------------+----------------------------------------------
   Reporter:  kwi            |       Owner:  gregboone  
       Type:  defect         |      Status:  new        
   Priority:  minor          |   Milestone:  3.8.0      
  Component:  ODBC Provider  |     Version:  3.8.0      
   Severity:  2              |    Keywords:  ODBC Oracle
External_id:                 |  
-----------------------------+----------------------------------------------
 When reading double values like 123.456789123456 from an Oracle "NUMBER" &
 "FLOAT" column, the ODBC mapping in
 providers\GenericRDBMS\src\ODBCDriver\desc_slct.c will map the value to a
 RDBI_FLOAT instead of RDBI_DOUBLE. The reason is that the threshold value
 for RDBI_DOUBLE is set to an "odbc_precision >= 53". But Oracle's NUMBER
 and FLOAT can store double precision values.Their odbc_precision begins
 with 19.

 With this we loose precision of the value after reading it.

 See unit test OdbcBaseFdoUpdateTest::updateNonDblGeom():[[BR]]
 Validate the column "Z" value from "Table6" will not pass the test.[[BR]]
 Validate the column "Y" value from "Table8" will not pass the test.

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