[jira] [Created] (IGNITE-15596) Calcite. java.lang.Integer cannot be cast to java.lang.Long with JOIN and EXISTS.

[Evgeny Stanilovsky (Jira)]

Evgeny Stanilovsky created IGNITE-15596:
-------------------------------------------

             Summary: 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



{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)