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

criteria duplicated when criteria includes the same columns as dependent join criteria

    XMLWordPrintable

Details

    Description

      Submitting a query that uses the same column for the join condition and criteria results in the criteria being duplicated on the dependent side of the join.

      For example:
      SELECT * FROM A, B
      WHERE B.id = A.id AND A.id IN ('1','2','3') OPTION MAKEDEP B;

      Results in the dependent side query looking like:
      SELECT ... FROM B WHERE B.id IN ('1','2','3') AND B.id IN ('1','2','3');

      This looks to have already been resolved in later versions, but I was not able to find the original JIRA that would have addressed this issue.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-support-mshirley Marc Shirley (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: