[Qgis-user] Bug with GeoPackage and Expressions?

[C Hamilton]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210728/335b83d6/attachment.html>