[JBoss JIRA] Updated: (TEIID-251) Support SQL 2003 order by with expressions
- First Post
- Replies
- Stats
-
Go to
- ----- 2026 -----
- April
- March
- February
- January
- ----- 2025 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- 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://jira.jboss.org/jira/browse/TEIID-251?page=com.atlassian.jira.plug...
]
Steven Hawkins updated TEIID-251:
---------------------------------
Fix Version/s: 6.3.0
(was: 6.2.0)
Even though this was recently requested by a customer, I'm pushing back to 6.3. We
cannot directly support at the connector level since order by items only allow element or
alias references. The workaround (which is what the patch implements in the rewriter) is
to write the query in the for of select ... from (select ..., expr as x, expr as y ) ...
order by ..., x, y
Support SQL 2003 order by with expressions
------------------------------------------
Key: TEIID-251
URL: https://jira.jboss.org/jira/browse/TEIID-251
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Optional
Fix For: 6.3.0
Attachments: sort_expression.patch
Original Estimate: 2 days
Remaining Estimate: 2 days
Defect Tracker #25000: SQL 2003 allows the order by clause to contain expressions instead
of just simple simple symbol names. Since we already support expressions in the group by
clause (which is actually against the SQL spec), it would make since to support
expressions in the order by as well.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6108
days inactive
6108
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)