[gdal-dev] SQLite dialect and ILIKE

Rahkonen Jukka jukka.rahkonen at maanmittauslaitos.fi
Fri Aug 30 15:52:01 PDT 2024


Hi,

Not my catch really, I was reading https://gis.stackexchange.com/questions/485416/is-the-ilike-operator-in-qgis-not-working-correctly

-Jukka-

Lähettäjä: gdal-dev <gdal-dev-bounces at lists.osgeo.org> Puolesta Even Rouault via gdal-dev
Lähetetty: lauantai 31. elokuuta 2024 1.48
Vastaanottaja: gdal-dev at lists.osgeo.org
Aihe: Re: [gdal-dev] SQLite dialect and ILIKE


good catch. Fixed in https://github.com/OSGeo/gdal/commit/9b1ab02e7b8cb5504cb65cacb287bc717ccee3f7
Le 31/08/2024 à 00:37, Rahkonen Jukka via gdal-dev a écrit :
Hi,

The documentation of the SQLite dialect https://gdal.org/en/latest/user/sql_sqlite_dialect.html#like-operator can make user believe that the dialect supports ILIKE operator since GDAL version 3.9 but that is not true. Maybe that is a copy-paste error in https://github.com/OSGeo/gdal/commit/1b886786fddfb49a3c3a000e2d1be5eede5b786e  and SQLite dialect is still supposed to have just LIKE . I considered to edit the documentation but I was not sure if I could just remove the two ILIKEs or if there is something more to edit.

-Jukka Rahkonen-



_______________________________________________

gdal-dev mailing list

gdal-dev at lists.osgeo.org<mailto:gdal-dev at lists.osgeo.org>

https://lists.osgeo.org/mailman/listinfo/gdal-dev

--

http://www.spatialys.com<http://www.spatialys.com/>

My software is free, but my time generally not.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20240830/a32f28f6/attachment-0001.htm>


More information about the gdal-dev mailing list