[gdal-dev] ogr2ogr: new layer called "SELECT" after SQLITE query

[Jakob Miksch]

Dear list,

I found a unexpected behavior of the SQLITE dialect. See this example 
where I access ten features of a remote GeoJSON:

ogr2ogr \
   -dialect SQLITE \
   -sql "SELECT * FROM chapters LIMIT 10" \
   -f GPKG output.gpkg \
https://raw.githubusercontent.com/maptime/maptime.github.io/master/_data/chapters.json

The resulting layername with SQLITE dialect is "SELECT". In contrast, 
with OGRSQL dialect, the resulting layername is "chapters" - which is 
more logical to me.

Any ideas why this behavior is different between SQLITE and OGRSQL dialect?

Thanks in advance and best wishes,
Jakob

-- 
Jakob Miksch
www.jakobmiksch.eu