Ordered limit against view with window function 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 Attachments: Patient-service.zip, patient-vdb.xml, USStates-service.zip, usstates-vdb.xml With a view 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 row_number() over (order by a) as rowid, a, b from x; A query that orders over the window function: select rowid, code, name from svcview order by rowid limit 1 Will fail with an assertion error initializing the top level sort node.