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

Posted to dev@calcite.apache.org by "Sylvain Crozon (Jira)" <ji...@apache.org> on 2021/05/21 18:39:00 UTC

[jira] [Created] (CALCITE-4617) Wrong offset when SortJoinTransposeRule pushes a sort node with an offset

Sylvain Crozon created CALCITE-4617:
---------------------------------------

             Summary: Wrong offset when SortJoinTransposeRule pushes a sort node with an offset
                 Key: CALCITE-4617
                 URL: https://issues.apache.org/jira/browse/CALCITE-4617
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.26.0
            Reporter: Sylvain Crozon


{{The SortJoinTransposeRule will push a sort node past a join, and then duplicate the sort node on top of the join. }}

When the sort node has an offset, we should only apply it once, otherwise we end up skipping twice as many rows as we should. The sort node added on top of the join should have a null offset.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)