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

add regression test for nested selects using UNION ALL and multiple aliases of the same column.

    XMLWordPrintable

Details

    • Task
    • Resolution: Done
    • Optional
    • 7.7
    • 7.7
    • Query Engine
    • None

    Description

      Pre 7.x code would throw a NPE with a query similar to [1]. Adding JUnit to prevent regression

      [1]
      SELECT enterprise_id FROM (
      SELECT * FROM (
      SELECT id, id AS display_id, 103 AS enterprise_id FROM (
      SELECT 'x' as id) AS nexted103) as table103Source
      UNION ALL
      SELECT 'x', 'x' AS display_id, 101 AS enterprise_id FROM (
      SELECT 'x') AS nested101
      UNION ALL
      SELECT 'x', 'x' AS display_id, 100 AS enterprise_id FROM (
      SELECT 'x') AS nested100) as tableFrom1stSelect
      WHERE enterprise_id = 100

      Attachments

        Activity

          People

            rhn-support-jolee Johnathon Lee
            rhn-support-jolee Johnathon Lee
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: