[QGIS-Developer] Bug with GeoPackage and Expressions?

[Even Rouault]

SQLite, which is the underneath database engine for GeoPackage, doesn't 
support ILIKE. The SQLite LIKE operator is actually case insensitive for 
ASCII characters. See paragraph 5 "The LIKE, GLOB, REGEXP, and MATCH 
operators" of https://www.sqlite.org/lang_expr.html

Le 28/07/2021 à 21:43, C Hamilton a écrit :
> 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 
> <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-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

-- 
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/qgis-developer/attachments/20210728/b296dc4c/attachment.html>