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

Inline scalar with clauses

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 8.11, 8.7.3.6_2
    • None
    • Query Engine
    • None

      A query of the form:

      WITH t(n) AS ( select 1 ) SELECT ...

      should inline the the with rather than evaluating separately.

            [TEIID-3464] Inline scalar with clauses

            RH Bugzilla Integration added a comment -

            Filip Elias <felias@redhat.com> changed the Status of bug 1307067 from VERIFIED to CLOSED

            RH Bugzilla Integration added a comment - Filip Elias <felias@redhat.com> changed the Status of bug 1307067 from VERIFIED to CLOSED

            RH Bugzilla Integration added a comment -

            Andrej Smigala <asmigala@redhat.com> changed the Status of bug 1307067 from ON_QA to VERIFIED

            RH Bugzilla Integration added a comment - Andrej Smigala <asmigala@redhat.com> changed the Status of bug 1307067 from ON_QA to VERIFIED

            RH Bugzilla Integration added a comment -

            Alex Szczuczko <aszczucz@redhat.com> changed the Status of bug 1307067 from MODIFIED to ON_QA

            RH Bugzilla Integration added a comment - Alex Szczuczko <aszczucz@redhat.com> changed the Status of bug 1307067 from MODIFIED to ON_QA

            RH Bugzilla Integration added a comment -

            jolee@redhat.com changed the Status of bug 1307067 from ASSIGNED to MODIFIED

            RH Bugzilla Integration added a comment - jolee@redhat.com changed the Status of bug 1307067 from ASSIGNED to MODIFIED

            RH Bugzilla Integration added a comment -

            jolee@redhat.com changed the Status of bug 1307067 from NEW to ASSIGNED

            RH Bugzilla Integration added a comment - jolee@redhat.com changed the Status of bug 1307067 from NEW to ASSIGNED

            Steven Hawkins added a comment -

            Enhanced the rewriter to inline when the with clause contains only deterministic expressions and no from clauses.

            Steven Hawkins added a comment - Enhanced the rewriter to inline when the with clause contains only deterministic expressions and no from clauses.

              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: