[QGIS-Developer] Problem with LIKE/ILIKE expressions and line breaks

flatoram felix.vons at gmail.com
Tue Sep 6 05:52:54 PDT 2022


Hi,

I have some problems with the expression editor for styling and other
expressions.
I found a related issue to this problem on github:
https://github.com/qgis/QGIS/issues/47957

A simple LIKE/ILIKE expression with line break values no more works in
3.22.5/3.22.10 LTR and 3.26.2.

In QGIS Version 3.16.5 it worked fine.

'Herbert\nCarl' ILIKE '%carl%' returns 0, not 1.

A temporary workaround for me is using "replace" + LIKE  or "regexp_match"
without LIKE.

Is the issue known?

Kind regards,
Felix
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20220906/4f93728e/attachment.htm>


More information about the QGIS-Developer mailing list