[CALCITE-5229] JdbcTest#testDynamicParameterInLimitOffset throws IllegalArgumentException

• Type: Bug
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.31.0
• Component/s: core
• Assignee: Zhengqiang Duan
• Reporter: Benchao Li
• Created: 07/Aug/22 03:10
• Updated: 14/Aug/22 10:02

Description

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

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)

Issue Links

• is related to: CALCITE-5201 Improve SemiJoinRule to match Join's right input which is unique for Join keys