Caican Cai created CALCITE-6352: ----------------------------------- Summary: 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 Fix For: 1.37.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)