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