Re: [gdal-dev] sqlite dialect: OpenFileGDB and FID Column selection

2023-09-02 Thread andy
Thank you very much Even. And thank you for this related PR https://github.com/OSGeo/gdal/pull/8301 ___ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] sqlite dialect: OpenFileGDB and FID Column selection

2023-09-01 Thread Even Rouault
haves with different SQL dialects is a rather small detail to be documented separately. -Jukka Rahkonen- *Lähettäjä:* andy *Lähetetty:* perjantai 1. syyskuuta 2023 9.54 *Vastaanottaja:* Rahkonen Jukka *Kopio:* gdal dev *Aihe:* Re: [gdal-dev] sqlite dialect: OpenFileGDB and FID Column selection

Re: [gdal-dev] sqlite dialect: OpenFileGDB and FID Column selection

2023-09-01 Thread Rahkonen Jukka
1. syyskuuta 2023 9.54 Vastaanottaja: Rahkonen Jukka Kopio: gdal dev Aihe: Re: [gdal-dev] sqlite dialect: OpenFileGDB and FID Column selection Hi Jukka, On Fri, 1 Sept 2023 at 07:42, Rahkonen Jukka mailto:jukka.rahko...@maanmittauslaitos.fi>> wrote: When the SQLite dialect is u

Re: [gdal-dev] sqlite dialect: OpenFileGDB and FID Column selection

2023-09-01 Thread andy
Hi Jukka, On Fri, 1 Sept 2023 at 07:42, Rahkonen Jukka < jukka.rahko...@maanmittauslaitos.fi> wrote: > When the SQLite dialect is used, a temporary SQLite database is created. > OBJECTID is a feature identifier (FID) and I guess that the FID gets > converted into a primary key with the SQLite def

Re: [gdal-dev] sqlite dialect: OpenFileGDB and FID Column selection

2023-08-31 Thread Rahkonen Jukka
kuuta 2023 0.36 Vastaanottaja: gdal dev Aihe: [gdal-dev] sqlite dialect: OpenFileGDB and FID Column selection Hi, if I run ogr2ogr -f CSV /vsistdout/ data.gdb -sql " SELECT OBJECTID from table_EDF_IS limit 1" I have OBJECTID, "1" Instead, if I run ogr2ogr -f CSV /vsistd

[gdal-dev] sqlite dialect: OpenFileGDB and FID Column selection

2023-08-31 Thread andy
Hi, if I run ogr2ogr -f CSV /vsistdout/ data.gdb -sql " SELECT OBJECTID from table_EDF_IS limit 1" I have OBJECTID, "1" Instead, if I run ogr2ogr -f CSV /vsistdout/ data.gdb -dialect sqlite -sql " SELECT OBJECTID from table_EDF_IS limit 1" I have this error ERROR 1: In ExecuteSQL(): sq