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

Nesting aliases that match the engine recontext logic can lead to naming conflicts

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.10
    • 7.7
    • Query Engine
    • None

    Description

      A query such as:

      select (select e4 from pm1.g1 X_1), pm1.g1.e2 from pm1.g1, /*+ makeind */ (select e1 from pm2.g1) AS X1, (select distinct e2, e3 from pm3.g1) X2 where pm1.g1.e3 = X1.e1 and pm1.g1.e2 = year(X_2.e3)

      Will fail to process correctly as the X_1 and X2 aliases are already in use, which will cause an AssertionError during processing attempting to reference X_1.e1.

      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: