[jira] [Created] (CALCITE-5091) RelMdRowCount can return more accurate rowCount when fetch is deterministic and offset is dynamic

["Jiajun Xie (Jira)" <ji...@apache.org>]

Jiajun Xie created CALCITE-5091:
-----------------------------------

             Summary: RelMdRowCount can return more accurate rowCount when fetch is deterministic and offset is dynamic
                 Key: CALCITE-5091
                 URL: https://issues.apache.org/jira/browse/CALCITE-5091
             Project: Calcite
          Issue Type: Improvement
          Components: core
    Affects Versions: 1.30.0
            Reporter: Jiajun Xie
            Assignee: Jiajun Xie


The sql from https://issues.apache.org/jira/browse/CALCITE-5048
{code:java}
select * from emp order by ename limit 1 offset ?
{code}

*RelMdRowCount#getRowCount* will return 14d, because it always return rowCount when offset is dynamic.
{code:java}
    if (rel.offset instanceof RexDynamicParam) {
      return rowCount;
    }
{code}

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



--
This message was sent by Atlassian Jira
(v8.20.1#820001)