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 07:15:00 UTC
[jira] [Updated] (IGNITE-15584) Calcite. Failed to parse query with
IN and simple subquery.
[ https://issues.apache.org/jira/browse/IGNITE-15584?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Evgeny Stanilovsky updated IGNITE-15584:
----------------------------------------
Description:
{noformat}
query I
SELECT 1 AS one WHERE 1 IN (SELECT 1);
----
1
{noformat}
{noformat}
class org.apache.ignite.IgniteException: Error at: (t.test:14). sql: SELECT 1 AS one WHERE 1 IN (SELECT 1);
at org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner$Query.execute(SqlScriptRunner.java:562)
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)
at java.lang.Thread.run(Thread.java:748)
Caused by: class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse query.
at org.apache.ignite.internal.processors.query.calcite.util.Commons.parse(Commons.java:205)
at org.apache.ignite.internal.processors.query.calcite.exec.ExecutionServiceImpl.executeQuery(ExecutionServiceImpl.java:390)
at org.apache.ignite.internal.processors.query.calcite.CalciteQueryProcessor.query(CalciteQueryProcessor.java:276)
{noformat}
{noformat}
/any_all/test_simple_not_in.test[_ignore]
{noformat}
was:
{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}
> 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
> Priority: Major
> Labels: calcite, calcite2-required, calcite3-required, ignite-3
>
> {noformat}
> query I
> SELECT 1 AS one WHERE 1 IN (SELECT 1);
> ----
> 1
> {noformat}
> {noformat}
> class org.apache.ignite.IgniteException: Error at: (t.test:14). sql: SELECT 1 AS one WHERE 1 IN (SELECT 1);
> at org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner$Query.execute(SqlScriptRunner.java:562)
> 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)
> at java.lang.Thread.run(Thread.java:748)
> Caused by: class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse query.
> at org.apache.ignite.internal.processors.query.calcite.util.Commons.parse(Commons.java:205)
> at org.apache.ignite.internal.processors.query.calcite.exec.ExecutionServiceImpl.executeQuery(ExecutionServiceImpl.java:390)
> at org.apache.ignite.internal.processors.query.calcite.CalciteQueryProcessor.query(CalciteQueryProcessor.java:276)
> {noformat}
> {noformat}
> /any_all/test_simple_not_in.test[_ignore]
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)