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

View removal with lateral join results in error

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.11
    • 8.0
    • Query Engine
    • None

    Description

      Using a lateral join:

      SELECT CAST(g1.col AS string), g0.a FROM (select 'a' as a, ('a',) as c) AS g0, TABLE(select array_get(g0.c, 1) as col) AS g1

      such that the left side is defined by a constant query, the view removal will not fully replace the correlated references and result in an exception for getting the correlated values (g0.c).

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: