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

Sql. Logic test without ordering compares with ordered results

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.0.0-beta1
    • 3.0.0-beta2
    • sql

    Description

      Test from test_not_distinct_from.test compare results without calling some kind of ordering. Can be reproduced by rejecting some join implementations:
      select /*+ DISABLE_RULE('MergeJoinConverter', 'CorrelatedNestedLoopJoin') */ a,tbl_2.b from tbl_1 inner join tbl_2 on (a IS NOT DISTINCT FROM tbl_2.b)

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

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