[jira] [Created] (CALCITE-5229) JdbcTest#testDynamicParameterInLimitOffset throws IllegalArgumentException

["Benchao Li (Jira)" <ji...@apache.org>]

Benchao Li created CALCITE-5229:
-----------------------------------

             Summary: JdbcTest#testDynamicParameterInLimitOffset throws IllegalArgumentException
                 Key: CALCITE-5229
                 URL: https://issues.apache.org/jira/browse/CALCITE-5229
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.31.0
            Reporter: Benchao Li
            Assignee: Benchao Li


After CALCITE-5201, this test will fail because we can transform more cases to semi join, and the physical type for some {{EnumerableRel}}s is wrong, we should fix them.

See https://github.com/apache/calcite/pull/2848/files#r913566595

{code:java}
java.lang.IllegalArgumentException: Can not set int field Baz$Record5_1.empid to null value
java.sql.SQLException: java.lang.IllegalArgumentException: Can not set int field Baz$Record5_1.empid to null value
	at org.apache.calcite.avatica.util.PositionedCursor$FieldGetter.getObject(PositionedCursor.java:132)
	at org.apache.calcite.avatica.util.AbstractCursor$AccessorImpl.getObject(AbstractCursor.java:357)
	at org.apache.calcite.avatica.util.AbstractCursor$AccessorImpl.getString(AbstractCursor.java:300)
	at org.apache.calcite.avatica.AvaticaResultSet.getString(AvaticaResultSet.java:241)
	at org.apache.calcite.test.CalciteAssert$ResultSetFormatter.rowToString(CalciteAssert.java:1986)
	at org.apache.calcite.test.CalciteAssert$ResultSetFormatter.resultSet(CalciteAssert.java:1972)
	at org.apache.calcite.test.CalciteAssert.lambda$checkResult$2(CalciteAssert.java:310)
	at org.apache.calcite.test.CalciteAssert.assertPrepare(CalciteAssert.java:631)
	at org.apache.calcite.test.CalciteAssert.access$700(CalciteAssert.java:149)
	at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$returns$1(CalciteAssert.java:1448)
	at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1384)
	at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1443)
	at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1433)
	at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1396)
	at org.apache.calcite.test.JdbcTest.testDynamicParameterInLimitOffset(JdbcTest.java:5448){code}




--
This message was sent by Atlassian Jira
(v8.20.10#820010)