[gdal-dev] GPKG: CREATE TABLE AS not working as expected

[Tobias Wendorff]

Hi there!

I'm trying to do this on latest ogr2ogr build:
ogrinfo -al -dialect sqlite -sql "CREATE TABLE sorted AS SELECT * FROM
mytable ORDER BY ST_GeoHash(ST_Transform(ST_Envelope(geom), 4326), 10)"
test.gpkg

The command runs without a problem, but the final table doesn't contain
any content in geometry column... Even a slimmed down example with
"CREATE TABLE test AS SELECT * FROM mytable;" doesn't work as expected.

Can someone give me a tip on how to get CREATE TABLE AS up and running?

Best regards,
Tobias