Andrey Khitrin created IGNITE-21143: ---------------------------------------
Summary: SQL: Backslash cannot be escaped in LIKE ESCAPE operator Key: IGNITE-21143 URL: https://issues.apache.org/jira/browse/IGNITE-21143 Project: Ignite Issue Type: Bug Components: sql Affects Versions: 3.0.0-beta2 Reporter: Andrey Khitrin When using custom escape symbol in LIKE operator, we cannot escape backslash. A error is raised here: {code:sql} sql-cli> select 'Dev_ops' like 'Dev#_ops' escape '#'; -- works as expected ╔═════════╗ ║ EXPR$0 ║ ╠═════════╣ ║ true ║ ╚═════════╝ sql-cli> select 'Dev\ops' like 'Dev#\ops' escape '#'; -- doesn't work SQL query execution error Invalid escape sequence 'Dev#\ops', 3 {code} In AI2 or some other DBMS, the latter query works without error: {code} select 'Dev\ops' like 'Dev#\ops' escape '#' -> true {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)