[jira] [Created] (IGNITE-15584) Calcite. Failed to parse query with IN and simple subquery.

[Evgeny Stanilovsky (Jira)]

Evgeny Stanilovsky created IGNITE-15584:
-------------------------------------------

             Summary: Calcite. Failed to parse query with IN and simple 
subquery.
                 Key: IGNITE-15584
                 URL: https://issues.apache.org/jira/browse/IGNITE-15584
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Evgeny Stanilovsky



{noformat}
query I
SELECT 1 AS one WHERE 1 IN (SELECT 1);
----
1
{noformat}


{noformat}
class org.apache.ignite.IgniteException: Error at: (test_simple_not_in.test:9). 
sql: SELECT 1 AS one WHERE 1 IN (SELECT 1);

        at 
org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner$Query.execute(SqlScriptRunner.java:558)
        at 
org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner.run(SqlScriptRunner.java:115)
        at 
org.apache.ignite.internal.processors.query.calcite.logical.ScriptTestRunner$1.run(ScriptTestRunner.java:219)
{noformat}


{noformat}
/any_all/test_simple_not_in.test[_ignore]
{noformat}




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