[CALCITE-6352] The map_contains_key function may return true when the key and mapkeytype types are different.

• Type: Bug
• Status: In Progress
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 1.36.0
• Fix Version/s: 1.38.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Caican Cai
• Reporter: Caican Cai
• Created: 04/Apr/24 14:54
• Updated: 1 week ago 14:55

Description

 

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|
+--------------------------------------+
 

calcite return false

 

Issue Links

• links to: GitHub Pull Request #3786