I think I found a bug and was wondering if someone could verify this. I am on Windows 10 and tried this with both QGIS 3.16.9 and 3.20.1.
I tried the following filter expression on the Natural Earth data set ne_10m_populated_places ( https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/cultural/ne_10m_populated_places.zip). Once loaded into QGIS right mouse click on the layer and select "Properties...", then click on the "Source" tab, click on "Query Builder" and then use this query "NAME" ILIKE '%Bom%' This works fine. If I export ne_10m_populated_places as a GeoPackage and try the same thing with the GeoPackage version of the layer, I get the error: "An error occurred when executing the query, please check the expression syntax." If I use LIKE instead of ILIKE then it works. It is like ILIKE was not implemented for GeoPackage. Can anyone verify this? I think you can use any vector layer for this test with one that is a shapefile and the other a GeoPackage. Thanks, Calvin
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user