[gdal-dev] [EXTERNAL] Re: GPKG geometry column name expectations with sqlite dialect

[Even Rouault]

Le 30/09/2024 à 21:18, Meyer, Jesse R. (GSFC-618.0)[SCIENCE SYSTEMS AND 
APPLICATIONS INC] a écrit :
>
> Thanks Scott and Even,
>
> Maybe it’s an unexpected interaction with Spatialite, but explicitly 
> providing the geometry column’s name results in bogus outputs.  Is the 
> SQL string wrong somehow?
>
> /f/"select count(ST_Area('{lyr_name + '.' + geom_column_name}'))". 
> (same outcome if re-arranged as count(…) from lyr_name instead)
>
ST_Area(some_text) will not work. It expects an identifier (possibly 
double quoted if that's needed), not a single-quoted string literal.


-- 
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/20240930/eec1c8f6/attachment.htm>