[
https://issues.apache.org/jira/browse/CALCITE-7700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
krooswu reassigned CALCITE-7700:
--------------------------------
Assignee: krooswu
> Error messages involving the STRING type family are confusing
> -------------------------------------------------------------
>
> Key: CALCITE-7700
> URL: https://issues.apache.org/jira/browse/CALCITE-7700
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.42.0
> Reporter: Mihai Budiu
> Assignee: krooswu
> Priority: Minor
>
> The STRING type family includes both STRING and BINARY types.
> This produces confusing errors for functions that may support both types of
> arguments:
> {code:sql}
> SELECT CONCAT('a', x'0a');
> {code}
> produces
> {noformat}
> Cannot apply 'CONCAT' to arguments of type 'CONCAT(<CHAR(1)>, <BINARY(1)>)'.
> Supported form(s): 'CONCAT(<STRING>, <STRING>)'
> {noformat}
> But CONCAT does support BINARY arguments!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
