Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.5.0
-
Untriaged
-
Unknown
-
CX Sprint 170, CX Sprint 171
Description
Fix matching a literal backslash in LIKE. As an example,
SELECT "test\\string" LIKE "%\\\\%" |
Also, fix the issue with a dynamic and changing pattern in regexp_*() functions (and functions using regex matcher class). Here is an example, for a dataset with the below tuples
{ "id": 1, "test_str": "hello world", "pattern": "h"} -- result was true which is correct |
{ "id": 2, "test_str": "hello world", "pattern": "H"} -- result was false which is incorrect |
|
FROM ds SELECT regexp_contains(test_str, pattern, "i"); -- "i" flag means case insenstive |
Attachments
Issue Links
- links to