[
https://issues.apache.org/jira/browse/CALCITE-6409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17845720#comment-17845720
]
Caican Cai edited comment on CALCITE-6409 at 5/12/24 2:47 PM:
--------------------------------------------------------------
[~mbudiu] Hello, is there any corresponding standard in this regard? I did not
find that the character type and the Boolean type are comparable on the Oracle
official website,
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/NVL.html#GUID-3AB61E54-9201-4D6A-B48A-79F4C4A034B2
was (Author: JIRAUSER302115):
[~mbudiu] Hello, is there any corresponding standard in this regard? I did not
find that the character type and the Boolean type are comparable on the Oracle
official website,
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf
/NVL.html#GUID-3AB61E54-9201-4D6A-B48A-79F4C4A034B2
> Char types and Boolean types are comparable
> -------------------------------------------
>
> Key: CALCITE-6409
> URL: https://issues.apache.org/jira/browse/CALCITE-6409
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.37.0
> Reporter: Caican Cai
> Priority: Critical
> Fix For: 1.38.0
>
>
> In the SameOperandTypeChecker method, the char type and the boolean type are
> comparable because of the call to the isComparable method.
> Comparability of char types and boolean types returns true in the
> isComparable method.
> However, char types and Boolean types in Spark are incomparable. Does Calcite
> have fixed standards here?
--
This message was sent by Atlassian Jira
(v8.20.10#820010)