[ https://issues.apache.org/jira/browse/IGNITE-15584?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17492462#comment-17492462 ]
Ivan Daschinsky commented on IGNITE-15584: ------------------------------------------ [~zstan] {code} The treatment of language that does not conform to the SQL Formats and Syntax Rules is implementation- dependent. {code} > 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)