Zoltan Haindrich created HIVE-25823: ---------------------------------------
Summary: Incorrect false positive results for outer join using non-satisfiable residual filters Key: HIVE-25823 URL: https://issues.apache.org/jira/browse/HIVE-25823 Project: Hive Issue Type: Bug Reporter: Zoltan Haindrich similar to HIVE-25822 {code} create table t_y (id integer,s string); create table t_xy (id integer,s string); insert into t_y values(0,'a'),(1,'y'),(1,'x'); insert into t_xy values(1,'x'),(1,'y'); select * from t_xy l full outer join t_y r on (l.id=r.id and l.s='y' and l.id+2*r.id=1); {code} the rows with full of NULLs are incorrect {code} +-------+-------+-------+-------+ | l.id | l.s | r.id | r.s | +-------+-------+-------+-------+ | NULL | NULL | 0 | a | | NULL | NULL | NULL | NULL | | 1 | y | NULL | NULL | | NULL | NULL | NULL | NULL | | NULL | NULL | 1 | y | | NULL | NULL | 1 | x | +-------+-------+-------+-------+ {code} -- This message was sent by Atlassian Jira (v8.20.1#820001)