[teiid-issues] [JBoss JIRA] Updated: (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 updated TEIID-1735:
----------------------------------

        Fix Version/s: 7.6
    Affects Version/s: 7.5


This restriction was made because both SQL Server and Postgres lack support.  We can add support in Teiid with an additional capability check.

The existing logic would need adapted to handle distinct ordered over clauses as performing a full pass sort would be too expensive.

> 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