Hi,
I have problems in using the SQLite dialect if layer names contains numbers or
underscores. I am on Windows.
ogrinfo -dialect sqlite 3d.shp -sql "select * from 3d"
INFO: Open of `3d.shp'
using driver `ESRI Shapefile' successful.
ERROR 1: In ExecuteSQL(): sqlite3_prepare(select * from 3d):
unrecognized token: "3d"
Same happens with a proper SQL with double quotes around the identifier
ogrinfo -dialect sqlite 3d.shp -sql "select * from "3d""
However, with single quotes it works
ogrinfo -dialect sqlite 3d.shp -sql "select * from '3d'"
Even this one, yields a correct result
ogrinfo -dialect sqlite 3d.shp -sql "select 'fixed_string' from '3d'"
Layers without numbers or underscores in names behave right
ogrinfo -dialect sqlite test.shp -sql "select * from "test"'"
Is there something that could be fixed in the code, or should I add a line to
two into the documentation http://www.gdal.org/ogr_sql_sqlite.html?
-Jukka Rahkonen-
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
