You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Lukas Eder (Jira)" <ji...@apache.org> on 2021/01/23 11:10:00 UTC

[jira] [Created] (IGNITE-14043) LIKE .. ESCAPE implemented inconsistently

Lukas Eder created IGNITE-14043:
-----------------------------------

             Summary: LIKE .. ESCAPE implemented inconsistently
                 Key: IGNITE-14043
                 URL: https://issues.apache.org/jira/browse/IGNITE-14043
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.9.1
            Reporter: Lukas Eder


I'm confused about whether ESCAPE is really supported or not. This works
{code:java}
SELECT 'a%b' LIKE '%!%%' ESCAPE '!';{code}
But this doesn't:
{code:java}
CREATE TABLE t (i int PRIMARY KEY, j varchar(10));
SELECT j LIKE '%!%%' ESCAPE '!' FROM t;{code}
I'm getting:
{quote}SQL Error [1] [50000]: Unsupported query: (J LIKE '%!%%' ESCAPE '!')
{quote}
I dont' see any remarks about it not being supported here: https://ignite.apache.org/docs/latest/sql-reference/sql-conformance, so I guess it's just a bug



--
This message was sent by Atlassian Jira
(v8.3.4#803005)