[jira] [Created] (IGNITE-21143) SQL: Backslash cannot be escaped in LIKE ESCAPE operator

[Andrey Khitrin (Jira)]

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)