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

Error when limit/sort is pushed above a window function

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.12.1, 8.13
    • 8.12
    • Query Engine
    • None

    Description

      TEIID-3568 introduced a regression by pushing a sort over a project node, but not accounting for aliases. This can be reproduced with a query such as:

      select column_a, column_b from (select sum(column_a) over (partition by key_column) as column_a, key_column from a ) a left outer join ( select sum(column_b) over (partition by key_column) as column_b, key_column from b) b on a.key_column = b.key_column order by column_a desc limit 10

      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: