[gdal-dev] Is SQLITE dialect supported on Memory OGR datasets?

[Even Rouault]

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 at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
http://www.spatialys.com
My software is free, but my time generally not.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20230822/bee799cd/attachment.htm>