ogrinfo: wrong output using sql with GeoPackage
|Reported by:||jguelat||Owned by:||warmerdam|
Unfortunately these queries don't seem to work. See for example the following one (dataset attached to the ticket):
ogrinfo geopackage_test.gpkg -sql "SELECT id, ST_Area(geom) AS area FROM geopackage_test"
I'm getting NULL values for the area. The same happens with other queries using the geometry column (e.g., ST_Buffer produces a NULL geometry).
I'm using GDAL 2.1.0 with Spatialite 4.3.0. Both were installed using the 64 bits version of the OsGeo4W installer. The GeoPackage was produced by QGIS 2.14.3.