Can you fill a bug for this? The expression compiler in QGIS should not forward it to ogr/gpkg/sqlite in this case.
Matthias On Wed, Jul 28, 2021 at 10:08 PM C Hamilton <adenacult...@gmail.com> wrote: > Thanks everyone for that explanation. This does complicate the ability to > set an expression filter in a plugin when it depends on the data source > type. I'm not sure what to do about that. > > Regards, > Calvin > > On Wed, Jul 28, 2021 at 8:00 PM Anita Graser <anitagra...@gmx.at> wrote: > >> Hi Calvin, >> >> 28 Jul 2021 21:43:40 C Hamilton <adenacult...@gmail.com>: >> > If I use LIKE instead of ILIKE then it works. It is like ILIKE was not >> implemented for GeoPackage. Can anyone verify this? >> >> Yes, there seems to be no iLike in sqlite: >> >> >> https://stackoverflow.com/questions/15480319/case-sensitive-and-insensitive-like-in-sqlite >> >> And therefore neither in geopackage. >> >> Regards >> Anita >> > _______________________________________________ > QGIS-Developer mailing list > QGIS-Developer@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer >
_______________________________________________ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer