Dayakar M created HIVE-26936:
--------------------------------
Summary: A predicate that compares 0 with -0 yields an incorrect
result
Key: HIVE-26936
URL: https://issues.apache.org/jira/browse/HIVE-26936
Project: Hive
Issue Type: Bug
Reporter: Dayakar M
Assignee: Dayakar M
Steps to reproduce:
CREATE TABLE t0(c0 INT);CREATE TABLE t1(c0 DOUBLE);INSERT INTO t0
VALUES(0);INSERT INTO t1 VALUES('-0');
SELECT * FROM t0, t1 WHERE t0.c0 = t1.c0; -- expected: \{0.0, -0.0}, actual:
{}+--------+--------+
| t0.c0 | t1.c0 |
+--------+--------+
+--------+--------+
That the predicate should evaluate to TRUE can be verified with the following
statement:
SELECT t0.c0 = t1.c0 FROM t0, t1; -- 1+-------+
| _c0 |
+-------+
| true |
+-------+
Similar issue fixed earlier as a part of [link
HIVE-11174|https://issues.apache.org/jira/browse/HIVE-11174] for where clause
condition, now join condition is having issue.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
