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

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

    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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                mshirley Marc Shirley
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: