Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-14808

Calcite. RIGHT|FULL Join operations are lost nulls sort ordering.

    XMLWordPrintableJSON

    Details

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                zstan Stanilovsky Evgeny
                Reporter:
                zstan Stanilovsky Evgeny
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h
                  1h