Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-15607

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: In Progress
    • Major
    • Resolution: Unresolved
    • None
    • None
    • sql

    Description

      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
      
      /subquery/scalar/test_grouped_correlated_subquery.test[_ignore]
      
      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)
      

      Attachments

        Issue Links

          Activity

            People

              ivandasch Ivan Daschinsky
              zstan Evgeny Stanilovsky
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: