[CALCITE-5091] RelMdRowCount can return more accurate rowCount when fetch is deterministic and offset is dynamic - ASF JIRA

XML

Word

Printable

JSON

select * from emp order by ename limit 1 offset ?

RelMdRowCount#getRowCount will return 14d, because it always return rowCount when offset is dynamic.

    if (rel.offset instanceof RexDynamicParam) {
      return rowCount;
    }

Obviously, rowCount will not exceed 1 because LIMIT 1. We can improve it.

is related to

CALCITE-5048 Query with parameterized LIMIT and correlated sub-query throws AssertionError "not a literal"

links to

GitHub Pull Request #2774

Estimated:

Not Specified

Remaining:

Logged:

50m