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)
