[CALCITE-1366] Metadata provider should not pull predicates up through GROUP BY ()

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.9.0
• Fix Version/s: 1.9.0
• Component/s: core
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 30/Aug/16 15:23
• Updated: 27/Feb/24 22:24
• Resolved: 03/Sep/16 00:13

Description

In org.apache.calcite.rel.metadata.RelMdPredicates.java:

...
    for (RexNode r : inputInfo.pulledUpPredicates) {
      ImmutableBitSet rCols = RelOptUtil.InputFinder.bits(r);
      if (groupKeys.contains(rCols)) {
        r = r.accept(new RexPermuteInputsShuttle(m, input));
        aggPullUpPredicates.add(r);
      }
    }
...

The check does not take into account that rCols might be empty, and then r cannot be pulled up e.g. count(*).

Issue Links

• blocks: CALCITE-1356 Release Calcite 1.9.0
• is related to: CALCITE-1368 Infer predicates for aggregate functions