[gdal-dev] SQLite dialect with GeoPackage

[Stefan Ziegler]

Hi

When trying to use SQLite dialect with GeoPackage I get some errors, like:

stefan at hatschepsut:~/Downloads$ ogrinfo -al -sql 'SELECT
ST_X(ST_SnapToGrid(geom,1)) FROM bodenbedeckung__bbtext LIMIT 1'
2601.gpkgINFO: Open of `2601.gpkg'
      using driver `GPKG' successful.
ERROR 1: In ExecuteSQL(): sqlite3_prepare(SELECT
ST_X(ST_SnapToGrid(geom,1)) FROM bodenbedeckung__bbtext LIMIT 1):
  no such function: ST_SnapToGrid


The same query works with Shapefiles. I thought the SQLite dialect can be
used with any OGR datasource?

I'm using gdal dev.

regards
Stefan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20141006/282dc92d/attachment.html>