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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.7
• Component/s: odbc
• Ignite Flags: Docs Required
• Assignee: Unassigned
• Reporter: Emanuel Warga
• Created: 22/Mar/19 08:35
• Updated: 22/Mar/19 08:35

Description

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."