[
https://issues.apache.org/jira/browse/IGNITE-15584?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17492516#comment-17492516
]
Aleksey Plekhanov commented on IGNITE-15584:
--------------------------------------------
[~zstan], [~ivandasch] it's not in a standard and I think it's strange syntax,
doubt we should support it. Let's just rewrite this test using supported
syntax. If someone will require such a syntax in the future it's better to
create a new ticket (with proper motivation).
> 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
> statement ok
> CREATE TABLE tbl(a TINYINT, b SMALLINT, c INTEGER, d BIGINT, e VARCHAR, f
> DATE, g TIMESTAMP)
> statement ok
> INSERT INTO tbl VALUES (1, 2, 3, 4, '5', DATE '1992-01-01', TIMESTAMP
> '1992-01-01 00:00:00')
> query T
> SELECT EXISTS(SELECT t1.c,t1.d WHERE t1.d<100) FROM tbl t1
> ----
> true
> {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]
> /subquery/scalar/test_complex_nested_correlated_subquery.test[_ignore]
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
