[teiid-issues] [JBoss JIRA] (TEIID-2487) Wrong aliasing when "supportsSelectExpression" is false in translator capabilities

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-2487:
-------------------------------------

Thanks, I understand now. I was thinking "supportsSelectExpression" applies for aggregates too.
                
> Wrong aliasing when "supportsSelectExpression" is false in translator capabilities
> ----------------------------------------------------------------------------------
>
>                 Key: TEIID-2487
>                 URL: https://issues.jboss.org/browse/TEIID-2487
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: Ramesh Reddy
>            Assignee: Steven Hawkins
>             Fix For: 8.4
>
>
> When "supportsSelectExpression" is false, in the translator capabilities and user submits a query like 
> {code}
> select sum (intnum) as "sum" from smalla group by intkey order by "sum"
> {code}
> the pushdown command at the translator is
> {code}
> SELECT SUM(SMALLA.INTNUM) FROM SMALLA GROUP BY SMALLA.INTKEY ORDER BY c_0
> {code}
> The alias in the ORDER BY is wrong. Also do not understand why the query engine pushed the aggregate is being pushed, possibly due to "supportsAggregatesSum" is turned on.

--
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