[gdal-dev] Spatialite functions missing when reading GeoPackage

[Rahkonen Jukka (MML)]

Hi,

This works with GDAL from OSGeo4W, GDAL 3.0.2, released 2019/10/28

ogrinfo any.gpkg -dialect sqlite -sql "select spatialite_version()"
INFO: Open of `any.gpkg'
      using driver `GPKG' successful.

Layer name: SELECT
Geometry: None
Feature Count: 1
Layer SRS WKT:
(unknown)
spatialite_version(): String (0.0)
OGRFeature(SELECT):0
  spatialite_version() (String) = 4.3.0

With GDAL-del from gisinternals, GDAL 3.1.0dev, released 2019/99/99, Spatialite is not found if I make a query to GeoPackage database. The error is
ERROR 1: In ExecuteSQL(): sqlite3_prepare_v2(select spatialite_version()):
  no such function: spatialite_version

However, when datasource is not gpkg then Spatialite is found
ogrinfo any.shp -dialect sqlite -sql "select spatialite_version()"
INFO: Open of `any.shp'
      using driver `ESRI Shapefile' successful.

Layer name: SELECT
Geometry: None
Feature Count: 1
Layer SRS WKT:
(unknown)
spatialite_version(): String (0.0)
OGRFeature(SELECT):0
  spatialite_version() (String) = 4.3.0-RC1

Obviously mod_spatialite is not loaded in the gpkg case but I wonder if the issue is in GDAL-dev or in the gisinternals build.

-Jukka Rahkonen-


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20191201/24f6abb4/attachment.html>