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

Allow for non-virtual dependent joins to be created over unions

    XMLWordPrintable

Details

    Description

      A simple structure like:

      join
        access 
        union
          access
          access
      

      will reject creating a cost based dependent join over the union if the number of independent values seems too large for a virtual dependent join.

      A related issue is that TEIID-5020 introduced a regression when creating a dependent join that is eventually pushed over a union below an access node:

      dependent select
         access
            set op
              ..
      

      the logic attempts to move nested dependent select back above the access node - so that only a single dependent predicate exists - based upon the node that is created at a child. However if the child projects a literal into the dependent set criteria, then the result is invalid.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: