Description
This issue was already fixed in ai-2 (IGNITE-18363), need to adopt it a bit.
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);
Attachments
Issue Links
- is a child of
-
IGNITE-15658 Merge resolve Calcite tickets to 3.0
-
- Open
-
- links to
