Dylan He created FLINK-36102:
--------------------------------
Summary: Support ESCAPE in built-in function LIKE formally
Key: FLINK-36102
URL: https://issues.apache.org/jira/browse/FLINK-36102
Project: Flink
Issue Type: Bug
Components: Table SQL / Planner
Reporter: Dylan He
Flink does not formally support ESCAPE in built-in function LIKE, but in some
cases we do need it because '_' and '%' are interpreted as special wildcard
characters, preventing their use in their literal sense.
And currently, if we forcefully use ESCAPE characters, we will get unexpected
results like the cases below.
{code:java}
testSqlApi("'TE_ST' LIKE '%E\\_S%'", "TRUE"); // get FALSE
testSqlApi("'TE_ST' LIKE '%E\\_S%' ESCAPE '\\'", "TRUE"); // get FALSE
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
