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

Planning error with unrelated sort columns and view removal

XMLWordPrintable

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

      There is an array index out of bounds in rule merge virtual correct order by when there is an unrelated sort over a query with a grouping:

      select a from (SELECT intkey as a, stringkey as b FROM BQT1.SmallA group by intkey, stringkey union all SELECT intkey as a, stringkey as b FROM BQT1.Smallb group by intkey, stringkey) as v order by b

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

              Created:
              Updated:
              Resolved: