[teiid-issues] [JBoss JIRA] (TEIID-5472) Clean up window function project node implementation

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13633710#comment-13633710 ] 

Steven Hawkins commented on TEIID-5472:
---------------------------------------

Another potential clean up is to allow nth_value to use the frame clause.  That seems to be commonly supported and is allowed by the spec.  For some reason postgresql allows the frame clause on ntile,lead/lag, but it's effectively ignored - it should raise an exception.

> Clean up window function project node implementation
> ----------------------------------------------------
>
>                 Key: TEIID-5472
>                 URL: https://issues.jboss.org/browse/TEIID-5472
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 11.2
>
>
> The initial implementation of window functions did not allow for a frame clause and specifically separated the logic of creating row and range values.  Now that the logic is more complete we should remove some of the initial design aspects.



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