[jira] [Created] (HIVE-25823) Incorrect false positive results for outer join using non-satisfiable residual filters

["Zoltan Haindrich (Jira)" <ji...@apache.org>]

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)