[jira] [Assigned] (CALCITE-7063) Result type inferred for CONCAT_FUNCTION is incorrect for BINARY arguments

["Yu Xu (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-7063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yu Xu reassigned CALCITE-7063:
------------------------------

    Assignee:     (was: Yu Xu)

> 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
>              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)