[gdal-dev] Unwanted geometry dump in ogrinfo sql

[Even Rouault]

Hi,

Le 04/12/2025 à 13:35, Jan Heckman via gdal-dev a écrit :
> Dear list,
> The following command also outputs geometry:
> /ogrinfo -sql "select bu_code from buurt_minimaal limit 1" 
> buurt_minimaal.dbf/
> Obviously, there is a buurt_minimaal.shp as well, see this link 
> <https://www.dropbox.com/scl/fi/0ui1n5bzwigcd80m8nnhk/buurt_minimaal.zip?rlkey=ojhd5qqtf028sgmjduk0v3ldf&dl=0>.
> The gdal version used is a bit old: GDAL 3.5.3.
> - should I do different to avoid geo dumps?

Either delete the .shp :-)  (more seriously, opening explicitly the .dbf 
or the .shp results in the same behavior in the shapefile driver. both 
are used when present),  or add "-dialect SQLite" since the SQLite 
dialect doesn't implicitly  select geometries, contrary to the default 
OGRSQL dialect

> - (if not,) will updating gdal help me avoid this behavior?

No, the working of the OGRSQL dialect is unchanged

-- 
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/20251204/f7e04c6d/attachment.htm>