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)

Reply via email to