[teiid-issues] [JBoss JIRA] (TEIID-2044) Column name aliases are not processed for MIN and MAX functions (but are for AVG)

Mon May 14 21:27:17 EDT 2012

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

Steven Hawkins resolved TEIID-2044.
-----------------------------------

    Resolution: Rejected

I believe you are referring to the JDBC getColumnName.  When possible getColumnName, will return the underlying column referenced.  In the case of min and max we have always reported the underlying column in the metadata since it will remain the same in the output value - which is typically not the case with AVG.  If you want to reference the columns by their derived name, then use getColumnLabel.  See also TEIID-1651 and related.

> Column name aliases are not processed for MIN and MAX functions (but are for AVG)
> ---------------------------------------------------------------------------------
>
>                 Key: TEIID-2044
>                 URL: https://issues.jboss.org/browse/TEIID-2044
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.7.1
>         Environment: SOA-P 5.3 ER2
>            Reporter: Paul Nittel
>            Assignee: Steven Hawkins
>
> Found this while validating data sources. If I enter this SQL: SELECT MIN(col) AS AAA, AVG(col) AS BBB, MAX(col) AS CCC FROM table, the columns are named col, BBB, col. They should be AAA, BBB, CCC.
> Found this was the case with the jdbc-simple and oracle translators

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira