[
https://issues.apache.org/jira/browse/CALCITE-7687?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mihai Budiu resolved CALCITE-7687.
----------------------------------
Fix Version/s: 1.43.0
Resolution: Fixed
Fixed in
[https://github.com/apache/calcite/commit/2b794ff5a9e4874905a91d475a2136ce5107aeb0]
Thank you for the report and fix [~etiennep]
> Aggregate selectivity estimation uses incorrect column references
> -----------------------------------------------------------------
>
> Key: CALCITE-7687
> URL: https://issues.apache.org/jira/browse/CALCITE-7687
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: Etienne Pelissier
> Assignee: Etienne Pelissier
> Priority: Minor
> Labels: in-progress, pull-request-available
> Fix For: 1.43.0
>
>
> Predicate pushability is assessed without taking into account column
> remapping from the aggregate.
> Additionally, predicates are pushed without being rewritten as need be. See
> [FilterAggregateTransposeRule|https://github.com/apache/calcite/blob/3b0444d98ab2708a4de503f63ea70006b7efeb58/core/src/main/java/org/apache/calcite/rel/rules/FilterAggregateTransposeRule.java#L89]
> +
> [pushPastProject|https://github.com/apache/calcite/blob/3b0444d98ab2708a4de503f63ea70006b7efeb58/core/src/main/java/org/apache/calcite/plan/RelOptUtil.java#L3356]
> and
> [pushPastCalc|https://github.com/apache/calcite/blob/3b0444d98ab2708a4de503f63ea70006b7efeb58/core/src/main/java/org/apache/calcite/plan/RelOptUtil.java#L3384].
--
This message was sent by Atlassian Jira
(v8.20.10#820010)