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)