Linhong Liu created SPARK-60636:
-----------------------------------

             Summary: Use SQL signed-zero equality in constant-map hash lookups
                 Key: SPARK-60636
                 URL: https://issues.apache.org/jira/browse/SPARK-60636
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 5.0.0
            Reporter: Linhong Liu


Hash lookups for foldable FLOAT- and DOUBLE-keyed maps distinguish negative 
zero from positive zero, while the linear lookup uses SQL equality and treats 
both signs as equal. Thus the selected lookup strategy can change a result from 
a stored value to NULL. Normalize zero consistently when building and probing 
the interpreted hash index and generated hash buckets. Preserve first-match 
behavior for physical maps containing duplicate zero keys. Tests should cover 
both types and signs, duplicate order, interpreted and generated evaluation, 
and ordinary, NaN, missing, and NULL controls.




--
This message was sent by Atlassian Jira
(v10.3.26#10030026)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to