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

Ordered limit against preserved view fails

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.1.2, 9.2
    • 8.12.7.6_3
    • Query Engine
    • 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.

      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

            rhn-engineering-shawkins Steven Hawkins
            parichar@redhat.com Paul Richardson
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: