[ 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)