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]