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
|