Dylan He created FLINK-36103: -------------------------------- Summary: Support ESCAPE in built-in function LIKE formally Key: FLINK-36103 URL: https://issues.apache.org/jira/browse/FLINK-36103 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)