[
https://issues.apache.org/jira/browse/IGNITE-15596?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Steshin reassigned IGNITE-15596:
-----------------------------------------
Assignee: Vladimir Steshin
> Calcite. java.lang.Integer cannot be cast to java.lang.Long with JOIN and
> EXISTS.
> ---------------------------------------------------------------------------------
>
> Key: IGNITE-15596
> URL: https://issues.apache.org/jira/browse/IGNITE-15596
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Evgeny Stanilovsky
> Assignee: Vladimir Steshin
> Priority: Major
> Labels: calcite, calcite2-required, calcite3-required, ignite-3
>
> {noformat}
> 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 I
> SELECT 1 FROM tbl t1 JOIN tbl t2 ON (t1.d=t2.d) WHERE EXISTS(SELECT t1.c FROM
> tbl t3 WHERE t1.d+t3.c<100 AND EXISTS(SELECT t2.f < DATE '2000-01-01'))
> ----
> 1
> {noformat}
> {noformat}
> ../exists/test_complex_nested_correlated_subquery.test[_ignore]
> {noformat}
> {noformat}
> Caused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to
> java.lang.Long
> at SC.execute(Unknown Source)
> at
> org.apache.ignite.internal.processors.query.calcite.exec.exp.ExpressionFactoryImpl$BiPredicateImpl.test(ExpressionFactoryImpl.java:448)
> at
> org.apache.ignite.internal.processors.query.calcite.exec.rel.NestedLoopJoinNode$InnerJoin.join(NestedLoopJoinNode.java:283)
> at
> org.apache.ignite.internal.processors.query.calcite.exec.rel.NestedLoopJoinNode.endRight(NestedLoopJoinNode.java:194)
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
