Weird interaction with ~ and underscores in filters #1231
-
|
A bug in my app is caused by what seems to be a special rule for how underscores are treated in How does this syntax work? |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 2 replies
-
|
This is a bug with the escaping of the underscore character. The |
Beta Was this translation helpful? Give feedback.
-
|
@DaniDipp Just to let you know that I've added a fix in |
Beta Was this translation helpful? Give feedback.
-
|
Thanks very much! |
Beta Was this translation helpful? Give feedback.
This is a bug with the escaping of the underscore character. The
~operator converts the expression to a "LIKE" SQL comparison and while we escape the underscore, since it has special meaning for 1 wildcard character, we are missing theESCAPEexpression and the query is trying to match the literalkey\_. I'll fix it sometime later today.