[teiid-issues] [JBoss JIRA] (TEIID-2044) Column name aliases are not processed for MIN and MAX functions (but are for AVG)
[
https://issues.jboss.org/browse/TEIID-2044?page=com.atlassian.jira.plugin...
]
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