[HIVE-22107] Correlated subquery producing wrong schema

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Logical Optimizer
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: Vineet Garg
• Reporter: Vineet Garg
• Created: 13/Aug/19 22:31
• Updated: 17/Nov/22 08:51
• Resolved: 21/Aug/19 22:24

Description

Repro

create table test(id int, name string,dept string);
insert into test values(1,'a','it'),(2,'b','eee'),(NULL, 'c', 'cse');
select distinct 'empno' as eid, a.id from test a where NOT EXISTS (select c.id from test c where a.id=c.id);

+-------+--------+
|  eid  |  a.id  |
+-------+--------+
| NULL  | empno  |
+-------+--------+

Issue Links

• links to: GitHub Pull Request #755