Hi Jie, By debugging your example, I reproduced this problem. It seems we did not set the right parameterRowType[1] while handling Query with only RelNode.
This is clearly a bug, can you help to log a Jira issue? [1] https://github.com/apache/calcite/blob/273d33dd61e0f1ec6b58e3b6381d6531608ee5e7/core/src/main/java/org/apache/calcite/prepare/CalcitePrepareImpl.java#L1019 Jie Ning <[email protected]> 于2022年12月17日周六 11:22写道： > Hello everyone~ > I need some help with handling SQL parameters using calcite Planner. > It works fine without SQL parameters, but there are some queries with SQL > parameters. While using SQL parameter and setting the > parameter(preparedStatement.setXXX), I got some error message. > Please refer to this link for a detailed description of the problem： > https://stackoverflow.com/q/74798301/20764847 > Looking forward to your reply~ > -- Best, Benchao Li
