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

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

     [ https://issues.apache.org/jira/browse/HIVE-25823?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zoltan Haindrich resolved HIVE-25823.
-------------------------------------
    Resolution: Duplicate

this is the same issue as HIVE-25822; I most likely made some mistake with checking the results on a different branch

> 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
>            Assignee: Zoltan Haindrich
>            Priority: Major
>
> 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)