[
https://issues.apache.org/jira/browse/HIVE-21898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16868126#comment-16868126
]
Vineet Garg commented on HIVE-21898:
------------------------------------
Hive currently throw a runtime error for queries which are correlated,
produces empty result set and contain COUNT aggregate in subquery. Above query
should follow the same.
> 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)
