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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4566?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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&$filter=startswith(code,%27A%27)

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.

> 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.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)