[
https://issues.apache.org/jira/browse/CALCITE-6352?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882679#comment-17882679
]
Caican Cai commented on CALCITE-6352:
-------------------------------------
[~rubenql]This problem is actually easy to solve, and it is similar to the jira
case type https://issues.apache.org/jira/browse/CALCITE-6300. Can you help me
take a look at the current problem
https://issues.apache.org/jira/browse/CALCITE-6300? I am not sure how to
improve it yet. Maybe I should send an email tonight to discuss it.
> The map_contains_key function may return true when the key and mapkeytype
> types are different.
> ----------------------------------------------------------------------------------------------
>
> Key: CALCITE-6352
> URL: https://issues.apache.org/jira/browse/CALCITE-6352
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.36.0
> Reporter: Caican Cai
> Assignee: Caican Cai
> Priority: Critical
> Labels: pull-request-available
> Fix For: 1.38.0
>
>
>
> {code:java}
> scala> val df = spark.sql("select map_contains_key(map(1, 'a', 2, 'b'),
> 2.0)")
> val df: org.apache.spark.sql.DataFrame = [map_contains_key(map(1, a, 2, b),
> 2.0): boolean]
> scala> df.show()
> +--------------------------------------+
> |map_contains_key(map(1, a, 2, b), 2.0)|
> +--------------------------------------+
> | true|
> +--------------------------------------+
> {code}
> calcite return false
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
