Mihai Budiu created CALCITE-7063:
------------------------------------
Summary: 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
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)