[jira] [Created] (IGNITE-18363) Calcite engine. Limit with offset can return negative estimated rows count

["Aleksey Plekhanov (Jira)" <ji...@apache.org>]

Aleksey Plekhanov created IGNITE-18363:
------------------------------------------

             Summary: Calcite engine. Limit with offset can return negative estimated rows count
                 Key: IGNITE-18363
                 URL: https://issues.apache.org/jira/browse/IGNITE-18363
             Project: Ignite
          Issue Type: Bug
            Reporter: Aleksey Plekhanov
            Assignee: Aleksey Plekhanov
             Fix For: 2.15


Limit with offset can return negative estimated rows count, this will throw an assertion error if limit is used as input of another relational operator.

For example:
{code:java}
CREATE TABLE t(id INT);
INSERT INTO t VALUES (1), (2), (3);
SELECT (SELECT id FROM t ORDER BY id LIMIT 1 OFFSET 10); {code}
Throws:
{noformat}
java.lang.AssertionError: null
    at org.apache.calcite.rel.metadata.RelMdUtil.isNonNegative(RelMdUtil.java:988) ~[calcite-core-1.32.0.jar:1.32.0]
    at org.apache.calcite.rel.metadata.RelMdUtil.validateResult(RelMdUtil.java:977) ~[calcite-core-1.32.0.jar:1.32.0]
    at org.apache.calcite.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:259) ~[calcite-core-1.32.0.jar:1.32.0]
    at org.apache.calcite.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:73) ~[calcite-core-1.32.0.jar:1.32.0]
    at org.apache.calcite.rel.metadata.janino.GeneratedMetadata_RowCountHandler.getRowCount_$(Unknown Source) ~[?:?]
    at org.apache.calcite.rel.metadata.janino.GeneratedMetadata_RowCountHandler.getRowCount(Unknown Source) ~[?:?]
    at org.apache.calcite.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:258) ~[calcite-core-1.32.0.jar:1.32.0]
    at org.apache.ignite.internal.processors.query.calcite.rel.IgniteAggregate.computeSelfCostHash(IgniteAggregate.java:94) ~[classes/:?]{noformat}
 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)