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