[gdal-dev] OCI loses decimal result

[SIMON Nicolas]

Dear GDAL developer,

        I run this command (GDAL 2.0.2, released 2016/01/26)

ogr2ogr -f "ESRI Shapefile" Test2.shp OCI:user/pwd at instance -sql "SELECT RID, ROUND(sdo_geom.sdo_area (s.geom, 0.01) / 10000,4) SURF_HA, s.GEOM FROM SIG_SOCS s WHERE RID IN (7778067,8644604)"

        And I get

Warning 1: Value '.0192' of field SELECT RID, ROUND(sdo_geom.sdo_area (s.geom, 0.01) / 10000,4) SURF_HA, s.GEOM FROM SIG_SOCS s WHERE RID IN (7778067,8644604).SURF_HA parsed incompletely to integer 0.
Warning 1: Value '10.1964' of field SELECT RID, ROUND(sdo_geom.sdo_area (s.geom, 0.01) / 10000,4) SURF_HA, s.GEOM FROM SIG_SOCS s WHERE RID IN (7778067,8644604).SURF_HA parsed incompletely to integer 10.

        SURF_HA seems interpreted as integer instead of real value.
        Is there a way to force SURF_HA to interpreted as real with 4 decimal ?

        Thanks for your hint

Nicolas Simon

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20160302/61a9f555/attachment.html>