[ https://issues.jboss.org/browse/TEIID-4566?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4566: ---------------------------------- 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. was: 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. Summary: Ordered limit against preserved view fails (was: Ordered limit against view with window function fails) -- This message was sent by Atlassian JIRA (v7.2.3#72005)