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)