Balazs Hevele created IMPALA-14731:
--------------------------------------
Summary: LIKE starting with % and ending with escaped % does not
work correctly
Key: IMPALA-14731
URL: https://issues.apache.org/jira/browse/IMPALA-14731
Project: IMPALA
Issue Type: Bug
Reporter: Balazs Hevele
Assignee: Balazs Hevele
As an example, LIKE "%abc\%" matches for any string containing "abc\", instead
of "abc%" with any prefix.
A very similar bug was fixed in
https://issues.apache.org/jira/browse/IMPALA-2422 which fixes similar cases
without the % at the start, e.g. "abc\%".
Example queries:
1.
+----------------------+
| 'abc%' like '%abc\%' |
+----------------------+
| false | (should be true)
+----------------------+
2.
+-----------------------+
| 'abc\\' like '%abc\%' |
+-----------------------+
| true | (should be false)
+-----------------------+
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
