[teiid-issues] [JBoss JIRA] (TEIID-2455) Cannot execute SQL query using SQL function in SORT clause via view model

Mon Apr 8 09:14:42 EDT 2013

    [ https://issues.jboss.org/browse/TEIID-2455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12765514#comment-12765514 ] 

Steven Hawkins commented on TEIID-2455:
---------------------------------------

Thanks Eiichi for catching this.  Updated the fix for alpha2 by moving the restoration of the project after the child assignment, which corrects issues when the unrelated columns as not projected.  

> Cannot execute SQL query using SQL function in SORT clause via view model
> -------------------------------------------------------------------------
>
>                 Key: TEIID-2455
>                 URL: https://issues.jboss.org/browse/TEIID-2455
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.7.4
>            Reporter: Van Halbert
>            Assignee: Steven Hawkins
>             Fix For: 8.4
>
>
> If SQL query is contained using SQL function in SORT clause, the query cannot execute via view model.
> ex) SELECT C1 FROM TEST_TABLE_VW order by CAST(C3 AS integer)
> Version-Release number of selected component (if applicable):
> EDS 5.3.1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira