[gdal-dev] SQLite dialect in OGRDataSource::ExecuteSQL

[Even Rouault]

Le mardi 10 février 2015 19:05:58, Pierluigi Guasqui a écrit :
> Even,
> 
> here is the complete output:
> 
>     Shape: DBF Codepage = LDID/87 for
>    

That was useful. Pasting the SQL into SQLite3 console shows :
Error: duplicate column name: MET

Indeed there's a "met" and "MET" columns in the shapefile. OGR drivers and core 
rarely handle that properly, and it seems that SQLite3 doesn't like it too. So 
you should rename one of the column, or use for example create a VRT with 
http://svn.osgeo.org/gdal/branches/1.11/gdal/swig/python/samples/ogr2vrt.py 
and hand-edit to do the renaming.

Even

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