[teiid-issues] [JBoss JIRA] (TEIID-4566) Ordered limit against view with window function fails

[ https://issues.jboss.org/browse/TEIID-4566?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4566: ---------------------------------- Component/s: Query Engine (was: OData) Description: 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. was: Have built teiid dv 6.3 distribution from git (d2642e58) and installed into eap. On deployment of vdb, odata url works correctly with most parameters. However, it returns {code:xml} <error> <code>null</code> <message>Assertion failed.</message> </error> {code} for urls containing the $top=x parameter (where x is some number), eg. https://localhost:8443/odata4/usstates.1/USStates/SvcView?$top=10 On the other hand, if I add a filter to the set of parameters, the top 10 is returned correctly, eg. https://localhost:8443/odata4/usstates.1/USStates/SvcView?$top=10&$fi... The stacktrace in the jb log can be found [here|https://gist.github.com/phantomjinx/b8fbc45329762daa9972b0fe77472f08]. Fix Version/s: 9.2 Summary: Ordered limit against view with window function fails (was: Use of $top without $filter in odata url query fails) I modified this to reflect the lower level issue. I'll double check to see how far back the issue goes. -- This message was sent by Atlassian JIRA (v7.2.3#72005)