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

Ordered limit against preserved view fails

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 8.12.7.6_3
    • Fix Version/s: 9.1.2, 9.2
    • Component/s: Query Engine
    • Labels:
      None

      Description

      With a view that has a column name that does not match the output name such as:

      create foreign table x (a string, b string, c integer, primary key (a, b)) options (updatable true); create view SvcView (RowId integer PRIMARY KEY, code string, name string) as select c as rowid, a, b from x limit 2;

      A query that orders over the rowid:

      select rowid, code, name from svcview order by rowid limit 1

      Will fail with an assertion error initializing the top level sort node.

        Gliffy Diagrams

          Attachments

          1. Patient-service.zip
            921 kB
          2. patient-vdb.xml
            0.8 kB
          3. USStates-service.zip
            921 kB
          4. usstates-vdb.xml
            1 kB

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                phantomjinx Paul Richardson
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: