[JBoss JIRA] Resolved: (TEIID-1735) RF: Add the ability to use DISTINCT in windowed aggregates in EDS
- First Post
- Replies
- Stats
-
Go to
- ----- 2024 -----
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-1735?page=com.atlassian.jira.plugin...
]
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/#wind...
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
4689
days inactive
4689
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)