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

[Pierluigi Guasqui]

Even,

oh I didn't realize about the duplicate column name. Since I have been 
successfully able to query that shapefile with OGR SQL dialect I though 
it was something related to the SQLite dialect.

Thanks for catching this issue!

Pierluigi

Il 10/02/2015 19:19, Even Rouault ha scritto:
> 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
>

-- 
Pierluigi Guasqui
Software Engineer

Applied Coherent Technology Corporation (ACT)
www.actgate.com