[ https://issues.apache.org/jira/browse/IGNITE-14808?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17397943#comment-17397943 ]
Konstantin Orlov commented on IGNITE-14808: ------------------------------------------- [~tledkov-gridgain], [~alexpl], folks, could you please do a review? I've reworked the patch a bit. > Calcite. RIGHT|FULL Join operations are lost nulls sort ordering. > ----------------------------------------------------------------- > > Key: IGNITE-14808 > URL: https://issues.apache.org/jira/browse/IGNITE-14808 > Project: Ignite > Issue Type: Bug > Components: sql > Reporter: Evgeny Stanilovsky > Assignee: Evgeny Stanilovsky > Priority: Major > Labels: calcite, calcite2-required, calcite3-required > Time Spent: 1.5h > Remaining Estimate: 0h > > queries likeĀ > {noformat} > FROM integers FULL OUTER JOIN integers2 ON integers.i=integers2.k ORDER BY i > NULLS FIRST > {noformat} will bring to erroneous results. Also some tests from /sql/join* > have no ordering thus results are not equal to pattern. -- This message was sent by Atlassian Jira (v8.3.4#803005)