[ https://issues.apache.org/jira/browse/CALCITE-6235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17812415#comment-17812415 ]
Julian Hyde commented on CALCITE-6235: -------------------------------------- That expression doesn't have a valid type. You can't use a DOUBLE key to search within a map whose key is INTEGER. Also, can you fix the summary? Right now it says that we are consistent with Spark. > MAP_CONTAINS_KEY function results correspond to Spark results > ------------------------------------------------------------- > > Key: CALCITE-6235 > URL: https://issues.apache.org/jira/browse/CALCITE-6235 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.36.0 > Reporter: Caican Cai > Priority: Minor > > map_contains_key(map(1, 2), cast(1 as double) returns false but spark returns > true. > This may involve some node type conversion bug > But I personally tend to think that this is a bug of Spark itself. Calcite > does not necessarily need to return true. > > https://github.com/apache/calcite/pull/3655 -- This message was sent by Atlassian Jira (v8.20.10#820010)