[gdal-dev] Wrongly identified SQLITE_BLOB as geomtry

[Christian Urich]

Hi Even and Jukka,

Thanks for the quick fixes!

Just tested the code from the master and it works for my use case.

Cheers

Christian




On 24 October 2016 at 11:33:17 pm, Even Rouault (even.rouault at spatialys.com)
wrote:

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20161024/b903989f/attachment.html>