[
https://issues.apache.org/jira/browse/CALCITE-7063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18010030#comment-18010030
]
Yu Xu commented on CALCITE-7063:
--------------------------------
According to the disscussion, need to fix codegen bug, so close the related pr
first.
> Result type inferred for CONCAT_FUNCTION is incorrect for BINARY arguments
> --------------------------------------------------------------------------
>
> Key: CALCITE-7063
> URL: https://issues.apache.org/jira/browse/CALCITE-7063
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.40.0
> Reporter: Mihai Budiu
> Assignee: Yu Xu
> Priority: Minor
> Labels: pull-request-available
>
> Calcite supports the MySQL CONCAT function.
> This function can have either VAR/CHAR or VAR/BINARY arguments. This holds
> true for the Calcite implementation. However, the Calcite implementation
> always infers a VAR/CHAR return type.
> Moreover, there are no tests for BINARY arguments, so I suspect that this has
> not been considered. Either the function should reject such arguments, or it
> should correctly infer the return type.
> Note that OperandTypes.STRING for the operandTypeChecker can be misleading,
> since the STRING type family includes BINARY.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
