Details
Description
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:
CREATE TABLE t(id INT); INSERT INTO t VALUES (1), (2), (3); SELECT (SELECT id FROM t ORDER BY id LIMIT 1 OFFSET 10);
Throws:
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/:?]
Attachments
Issue Links
- is part of
-
IGNITE-12248 Apache Calcite based query execution engine
-
- Open
-
- links to
