You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Evgeny Stanilovsky (Jira)" <ji...@apache.org> on 2022/12/21 07:30:00 UTC

[jira] [Created] (IGNITE-18437) Sql. Fix row count estimate by limit with offset

Evgeny Stanilovsky created IGNITE-18437:
-------------------------------------------

             Summary: Sql. Fix row count estimate by limit with offset
                 Key: IGNITE-18437
                 URL: https://issues.apache.org/jira/browse/IGNITE-18437
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 3.0.0-beta1
            Reporter: Evgeny Stanilovsky
            Assignee: Evgeny Stanilovsky


This issue was already fixed in ai-2 ([IGNITE-18363|https://github.com/apache/ignite/pull/10428/files#top]), 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:
{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}



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