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/27 08:54:00 UTC

[jira] [Created] (IGNITE-15607) Calcite. RuntimeException while resolving method 'eq[class java.lang.Object, int]' in class class org.apache.calcite.runtime.SqlFunctions

Evgeny Stanilovsky created IGNITE-15607:
-------------------------------------------

             Summary: Calcite. RuntimeException while resolving method 'eq[class java.lang.Object, int]' in class class org.apache.calcite.runtime.SqlFunctions
                 Key: IGNITE-15607
                 URL: https://issues.apache.org/jira/browse/IGNITE-15607
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Evgeny Stanilovsky



{noformat}
statement ok
CREATE TABLE tbl_ProductSales (ColID int, Product_Category  varchar(64), Product_Name  varchar(64), TotalSales int);

statement ok
CREATE TABLE another_T (col1 INT, col2 INT, col3 INT, col4 INT, col5 INT, col6 INT, col7 INT, col8 INT);

statement ok
INSERT INTO tbl_ProductSales VALUES (1,'Game','Mobo Game',200),(2,'Game','PKO Game',400),(3,'Fashion','Shirt',500),(4,'Fashion','Shorts',100);

statement ok
INSERT INTO another_T VALUES (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888);

query T
SELECT col1 IN (SELECT ColID + col1 FROM tbl_ProductSales) FROM another_T GROUP BY col1;
----
false
false
false
false
{noformat}


{noformat}
/subquery/scalar/test_grouped_correlated_subquery.test[_ignore]
{noformat}


{noformat}
java.lang.RuntimeException: while resolving method 'eq[class java.lang.Object, int]' in class class org.apache.calcite.runtime.SqlFunctions

	at org.apache.calcite.linq4j.tree.Types.lookupMethod(Types.java:318)
	at org.apache.calcite.linq4j.tree.Expressions.call(Expressions.java:448)
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexImpTable$BinaryImplementor.implementSafe(RexImpTable.java:1218)
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexImpTable$AbstractRexCallImplementor.genValueStatement(RexImpTable.java:1979)
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexImpTable$AbstractRexCallImplementor.implement(RexImpTable.java:1942)
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.visitCall(RexToLixTranslator.java:991)
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.visitCall(RexToLixTranslator.java:79)
	at org.apache.calcite.rex.RexCall.accept(RexCall.java:189)
{noformat}





--
This message was sent by Atlassian Jira
(v8.3.4#803005)