macroguo-ghy opened a new pull request, #4867: URL: https://github.com/apache/calcite/pull/4867
## Jira Link [CALCITE-7407](https://issues.apache.org/jira/browse/CALCITE-7407) ## Changes Proposed - Change `||` to use `InferTypes.RETURN_TYPE` so dynamic parameters are typed from the string concatenation context instead of being rejected as illegal `ANY` operands. - Add validator regression coverage for concatenation with dynamic parameters, `NULL`, and `CAST(NULL AS ANY)`. - Add a JDBC prepared statement regression covering `? || 'odore'`. ## Reproduction ```sql select * from emp where ename = (? || 'KI') ``` Before this change, Calcite rejected the dynamic parameter in the concatenation expression with `Illegal use of dynamic parameter`. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
