[teiid-issues] [JBoss JIRA] (TEIID-2487) Wrong aliasing when "supportsSelectExpression" is false in translator capabilities
Steven Hawkins (JIRA)
jira-events at lists.jboss.org
Fri Apr 26 09:26:53 EDT 2013
[ https://issues.jboss.org/browse/TEIID-2487?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-2487.
-----------------------------------
Fix Version/s: 8.4
Resolution: Done
Updated the alias generator to account for non-column references when supportsSelectExpression is turned off.
> 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
More information about the teiid-issues
mailing list