[teiid-issues] [JBoss JIRA] Updated: (TEIID-251) Support SQL 2003 order by with expressions

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-251:
---------------------------------

    Fix Version/s: 6.2.0
                       (was: 6.3.0)


Given the work on TEIID-514, it would be easier to implement this feature through inline view creation (with the same logic as group by rewriting) with unrelated columns.  The designer would still need to have its display node logic updated before this would work there. 

> 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
>            Priority: Optional
>             Fix For: 6.2.0
>
>   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