[teiid-issues] [JBoss JIRA] (TEIID-5864) Teiid Query Join Plan Infinite Loop

[Mark Tawk (Jira)]

Mark Tawk created TEIID-5864:
--------------------------------

             Summary: Teiid Query Join Plan Infinite Loop
                 Key: TEIID-5864
                 URL: https://issues.redhat.com/browse/TEIID-5864
             Project: Teiid
          Issue Type: Bug
            Reporter: Mark Tawk
            Assignee: Steven Hawkins


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

{code:java}
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
{code}

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:


{code:java}
changedAny |= val;
{code}




--
This message was sent by Atlassian Jira
(v7.13.8#713008)