[jira] [Created] (HIVE-26936) A predicate that compares 0 with -0 yields an incorrect result

["Dayakar M (Jira)" <ji...@apache.org>]

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)