Ordered limit against preserved view fails ------------------------------------------ Key: TEIID-4566 URL: https://issues.jboss.org/browse/TEIID-4566 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.12.7.6_3 Reporter: Paul Richardson Assignee: Steven Hawkins Fix For: 9.2, 9.1.2 Attachments: Patient-service.zip, patient-vdb.xml, USStates-service.zip, usstates-vdb.xml 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.