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