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

[Ramesh Reddy (JIRA)]

Ramesh Reddy created TEIID-2487:
-----------------------------------

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


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