[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1735) RF: Add the ability to use DISTINCT in windowed aggregates in EDS

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-1735.
-----------------------------------

    Resolution: Done


The ordered case seems like a moot point as Oracle/SQLServer/Postgresql do not support it, so just added support for distinct non-ordered aggs.

Also added additional pushdown validation (could be applicable to 7.5, but is unlikely to matter except in corner cases) and added warnings from the capabilities converter if base supports are not present.  

> RF: Add the ability to use DISTINCT in windowed aggregates in EDS
> -----------------------------------------------------------------
>
>                 Key: TEIID-1735
>                 URL: https://issues.jboss.org/browse/TEIID-1735
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 7.5
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>             Fix For: 7.6
>
>
> According to the following page: http://docs.jboss.org/teiid/7.5.0.Final/reference/en-US/html_single/#window_functions
> This states that "windowed aggregates may not use DISTINCT". I would like to request that use of DISTINCT in aggregate functions be  supported in a future release.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira