Vineet Garg created HIVE-21898:
----------------------------------
Summary: Wrong result with IN correlated subquery with aggregate
in SELECT
Key: HIVE-21898
URL: https://issues.apache.org/jira/browse/HIVE-21898
Project: Hive
Issue Type: Bug
Affects Versions: 3.0.0, 4.0.0
Reporter: Vineet Garg
Assignee: Vineet Garg
{code:sql}
select
p_size in
(select min(p_size)
from (select p_mfgr, p_size from part) a
where a.p_mfgr = b.p_name
) from part b limit 1
{code}
Expected result: null
Actual result: false
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
