[teiid-issues] [JBoss JIRA] (TEIID-5475) nth_value is incorrect for
Steven Hawkins (JIRA)
issues at jboss.org
Fri Sep 14 10:33:00 EDT 2018
Steven Hawkins created TEIID-5475:
-------------------------------------
Summary: nth_value is incorrect for
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) from pm1.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)
More information about the teiid-issues
mailing list