[jira] [Commented] (HIVE-22408) The fix for CALCITE-2991 creates wrong results on edge case

["Vineet Garg (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-22408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16968065#comment-16968065 ] 

Vineet Garg commented on HIVE-22408:
------------------------------------

*Simple repro*
{code:sql}
select count(*) from part where p_partkey is not null group by true limit 0;
{code}

*Expected Result* : 0 row
*Actual Result*: 1 row

> The fix for CALCITE-2991 creates wrong results on edge case
> -----------------------------------------------------------
>
>                 Key: HIVE-22408
>                 URL: https://issues.apache.org/jira/browse/HIVE-22408
>             Project: Hive
>          Issue Type: Bug
>          Components: CBO
>    Affects Versions: 3.1.2
>            Reporter: Steve Carlin
>            Assignee: Vineet Garg
>            Priority: Major
>
> The Calcite upgrade from 1.19 to 1.21 includes a fix for CALCITE-2991.  This patch causes a failure in subquery_ALL.q
> In order to proceed with the upgrade, the patch was bypassed by creating the HiveRelMdMaxRowCount class which overrides the behavior in Calcite.  
> In order to recreate the regression, remove this file and the references to the class in HiveDefaultRelMetadataProvider.
> This Jira is being created before the HIVE-22274 PR has been pushed, so please wait until that is pushed before working on this.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)