You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Steshin (Jira)" <ji...@apache.org> on 2021/10/29 10:47:00 UTC
[jira] [Comment Edited] (IGNITE-15607) Calcite. RuntimeException
while resolving method 'eq[class java.lang.Object, int]' in class class
org.apache.calcite.runtime.SqlFunctions
[ https://issues.apache.org/jira/browse/IGNITE-15607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17435920#comment-17435920 ]
Vladimir Steshin edited comment on IGNITE-15607 at 10/29/21, 10:46 AM:
-----------------------------------------------------------------------
[~zstan], we refer to unexisting column 'col1' of table 'tbl_ProductSales'. Is the problem in wrog error/expection, NPE ?
was (Author: vladsz83):
[~zstan], is the problem in wrog error/expection, NPE ?
> 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
> Priority: Major
> Labels: calcite, calcite2-required, calcite3-required, ignite-3
>
> {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)