[gdal-dev] Wrongly identified SQLITE_BLOB as geomtry

[Even Rouault]

Le lundi 24 octobre 2016 14:10:34, Christian Urich a écrit :
> Hi,
> 
> will do.
> 
> I run into another problem. The update statement for multiple geometry
> fails.
> 
> ERROR 1: In SetFeature(): sqlite3_prepare(UPDATE 'timeseries' SET "data" =
> ?"GEOMETRY" = ?,"end" = ?,"start" = ?,"station_id" = ?,"timestep" =
> ?,"type" = ?,"s" = ? WHERE "ogc_fid" = 1):
>   near ""GEOMETRY"": syntax error
> 
> Looks like a comma is missing. Looking at the code my guess is
> gdal/gdal/ogr/ogrsf_frmts/sqlite/ogrsqlitetablelayer.cpp line 2640 misses a
> 
> if( bNeedComma )
>             osCommand += ",";
> 

Good catch! Thanks. Fixed per https://trac.osgeo.org/gdal/ticket/6696

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com