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)

Reply via email to