Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Duplicate Issue
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Editors
    • Labels:
      None

      Description

      Using Teiid 9.2.2 with postgresql, I issue a query structured like this:

      (a
      UNION ALL
      b
      UNION ALL
      c)
      INTERSECT
      d

      All queries are from a single database.
      This query does not give back the expected result.

      In the plan, I see the query printed with no parenthesis around the unions:
      a UNION ALL b UNION ALL c INTERSECT d

      This gives the same result as the query submitted with no parens in it (the intersect of c and d is unioned with a union b.

      The expepeted result is to preserve the paren so that the intersect is performed against the union of all three tables.

      As a note, using UNION instead of UNION ALL did not preserve the parens, either.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  shawkins Steven Hawkins
                  Reporter:
                  rhn-engineering-vhalbert Van Halbert
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: