[
https://issues.apache.org/jira/browse/HIVE-21898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vineet Garg updated HIVE-21898:
-------------------------------
Description:
{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*
was:
{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
> 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
> Priority: Major
>
> {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)
