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

Multi-way join predicate inappropriately removed

XMLWordPrintable

      In a situation where copy criteria can work against a multi-way join predicate, such that the predicate is not pushed:

      t1.a = coalesce(t2.b, t3.c, t4.d) ... t1.a = t4.d

      The multi-way predicate can be marked as optional and removed.

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: