Jesse,
No it wasn't. Fix in https://github.com/OSGeo/gdal/pull/8247
Potential workaround: use a in-memory SQLite or GeoPackage with a
/vsimem/ filename
Even
Le 21/08/2023 à 21:30, Meyer, Jesse R. (GSFC-618.0)[SCIENCE SYSTEMS AND
APPLICATIONS INC] via gdal-dev a écrit :
Hi,
This works:
tc_lyr =execute_SQL(tree_canopy_mem_ds,"select * from
trees",/spatialFilter/=c_geo)
However, this:
tc_lyr =execute_SQL(tree_canopy_mem_ds,"select * from
trees",/spatialFilter/=c_geo,/dialect/="SQLITE")
Returns:
In Initialize(): sqlite3_step(SELECT _rowid_, * FROM 'trees' LIMIT 1):
SQL logic error
Where execute_SQL = ogr.DataSource.ExecuteSQL
Which is naturally a surprise given that I’m not explicitly asking for
the rowid, nor to limit the number of returned rows.
The docs claim that the SQLite dialect can be used with any OGR
datasource, so I did expect this to work. The input datasource is
GeoPackage, which is based on SQLite, so I assume my install is built
with SQLite, though I’d welcome advice on how to explicitly
demonstrate this.
My GDAL version install is 3.6.4, on OSX 13.5.
Thanks,
Jesse
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
--
http://www.spatialys.com
My software is free, but my time generally not.
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
