Re: [QGIS-Developer] Bug with GeoPackage and Expressions?

2021-07-28 Thread 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 Ham

[QGIS-Developer] Bug with GeoPackage and Expressions?

2021-07-28 Thread 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/