[
https://issues.apache.org/jira/browse/CALCITE-7063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17984953#comment-17984953
]
Yu Xu commented on CALCITE-7063:
--------------------------------
I noticed no body take this issue，I would continue the work about the issue and
assigned it to myself first, if someone had started please let me know.
> 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
> Priority: Minor
>
> 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)
