[ https://issues.apache.org/jira/browse/CALCITE-6409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17845720#comment-17845720 ]
Caican Cai commented on CALCITE-6409: ------------------------------------- [~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)