[CALCITE-1543] Correlated scalar sub-query with multiple aggregates gives AssertionError

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.12.0
• Assignee: Julian Hyde
• Reporter: Kurt Young
• Created: 16/Dec/16 03:39
• Updated: 24/Mar/17 03:20
• Resolved: 06/Jan/17 20:55

Description

Caused by: java.lang.AssertionError at org.apache.calcite.sql2rel.RelDecorrelator.decorrelateRel(RelDecorrelator.java:456)

The code is:

    final Frame frame = getInvoke(oldInput, rel);
    if (frame == null) {
      // If input has not been rewritten, do not rewrite this rel.
      return null;
    }
    assert !frame.corVarOutputPos.isEmpty();

Seems like it's no need to assert the corVarOutputPos because in some cases, the correlate has been fully rewritten.

Issue Links

• links to: PR 343