On Thu, 29 Jul 2021 at 15:31, Matthias Kuhn <matth...@opengis.ch> wrote: > > Can you fill a bug for this? The expression compiler in QGIS should not > forward it to ogr/gpkg/sqlite in this case.
My interpretation is that Calvin is setting a layer filter, so QGIS expressions aren't involved (i.e. no bug). Nyall > > 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 _______________________________________________ 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