Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5864

Teiid Query Join Plan Infinite Loop

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 13.0, 12.2.2, 12.3.2
    • None
    • Query Engine
    • None
    • DV Sprint 56
    • 1

      We are getting an infinite loop when executing the below SQL:

      SELECT c._COMPTE,
             u.CalculatedField,
             cl.CHAMPSFCP__VALEUR,
             ch_41.CH41__VALEUR,
             ch_5.CH5__VALEUR
        FROM OmgModel_Z1rP.OMG.dbo.CPARTFCP c
        LEFT JOIN BInv6BusinessModel.FREPACCOUNTUNION u
          ON u.FREP_AFAINB = c._USERNAME
         AND u.CalculatedField6 = 'B'
        LEFT JOIN BInv6BusinessModel.ClientTypeCode cl
          ON c._COMPTE = cl.CHAMPSFCP__COMPTE
        LEFT JOIN (SELECT ch._COMPTE AS CH41__COMPTE,
                          ch._VALEUR AS CH41__VALEUR
                     FROM OmgModel_Z1rP.OMG.dbo.CHAMPSFCP ch
                    WHERE ch._NUMCHAMPS = 41) ch_41
          ON c._COMPTE = ch_41.CH41__COMPTE
        LEFT JOIN (SELECT ch._COMPTE AS CH5__COMPTE,
                          ch._VALEUR AS CH5__VALEUR
                     FROM OmgModel_Z1rP.OMG.dbo.CHAMPSFCP ch
                    WHERE ch._NUMCHAMPS = 5) ch_5
          ON c._COMPTE = ch_5.CH5__COMPTE LIMIT 0, 10
      

      After debugging, find out that the issue is coming from the class RulePlanOuterJoins method planLeftOuterJoinAssociativityBeforePlanning.

      the issue is coming from the below code line, if removed the issue is not reproduced:

      changedAny |= val;
      

            rhn-engineering-shawkins Steven Hawkins
            mtawk Mark Tawk (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 4 hours Original Estimate - 4 hours
                4h
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 5 hours
                5h