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

Posted to issues@ignite.apache.org by "Evgeny Stanilovsky (Jira)" <ji...@apache.org> on 2021/09/24 06:57:00 UTC

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

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)