[CALCITE-3988] Intersect in RelMdRowCount doesn't take into account 'intersect all'

• Type: Wish
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.24.0
• Assignee: Unassigned
• Reporter: xzh_dz
• Created: 11/May/20 11:35
• Updated: 25/Jul/20 14:59
• Resolved: 24/May/20 20:17

Description

Same as https://issues.apache.org/jira/browse/CALCITE-3287.
Intersect in RelMdRowCount.java doesn't take into account 'intersect all' .

public Double getRowCount(Intersect rel, RelMetadataQuery mq) {
    Double rowCount = null;
    for (RelNode input : rel.getInputs()) {
      Double partialRowCount = mq.getRowCount(input);
      if (rowCount == null
          || partialRowCount != null && partialRowCount < rowCount) {
        rowCount = partialRowCount;
      }
    }
    return rowCount;
  }

Issue Links

• links to: https://github.com/apache/calcite/pull/1972