[IGNITE-14808] Calcite. RIGHT|FULL Join operations are lost nulls sort ordering.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Labels: calcite

Release Note

• Assignee: Konstantin Orlov
• Reporter: Evgeny Stanilovsky
• Created: 01/Jun/21 12:50
• Updated: 16/Nov/21 15:57
• Resolved: 31/Aug/21 15:51

Description

queries like 

FROM integers FULL OUTER JOIN integers2 ON integers.i=integers2.k ORDER BY i NULLS FIRST

will bring to erroneous results. Also some tests from /sql/join* have no ordering thus results are not equal to pattern.

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #9143