[jira] [Created] (IGNITE-11603) ESCAPE key word in combination with LIKE statement seems to be prohibited

["Emanuel Warga (JIRA)" <ji...@apache.org>]

Emanuel Warga created IGNITE-11603:
--------------------------------------

             Summary: ESCAPE key word in combination with LIKE statement seems to be prohibited
                 Key: IGNITE-11603
                 URL: https://issues.apache.org/jira/browse/IGNITE-11603
             Project: Ignite
          Issue Type: Bug
          Components: odbc
    Affects Versions: 2.7
            Reporter: Emanuel Warga


As described in https://stackoverflow.com/questions/55283492/like-statement-causes-unsupported-query-on-ignite-2-7-with-querydsl Ignite seems to have a problem when I use LIKE with the ESCAPE key word.

Example:

{{    select * from mytable mt where (mt.c1 LIKE 'Abc%' ESCAPE '!');}}

I get an error announcing this is an unsupported query.

The error doesn't show up if I don't use '% inside the search string so the problem doesn't seem to be a general one like "we don't support the ESCAPE key word."



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)