[teiid-issues] [JBoss JIRA] (TEIID-5475) nth_value is incorrect for some initial values

[Steven Hawkins (JIRA)]

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

Work on TEIID-5475 started by Steven Hawkins.
---------------------------------------------
> nth_value is incorrect for some initial values
> ----------------------------------------------
>
>                 Key: TEIID-5475
>                 URL: https://issues.jboss.org/browse/TEIID-5475
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Blocker
>             Fix For: 11.2, 11.1.1
>
>
> Nth_value is returning null when not expected.  For example:
> select e1, nth_value(e1, 2) over (order by e1 nulls last) from g1
> with our default data set should return 'a' for each nth_value, but instead returns null for one of the 'a' rows.  The issue is that we should be considering the indexing to be relative from the start of the peer group in the frame rather than from the current index of the row.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)