Alias column name is not available in the resultset for MIN and MAX functions

[rakeshsagar]

Hi all,

I have a SQL of the form select MAX(AGE) AS "MINAGE", MIN(AGE) AS "MINAGE" FROM EMPLOYEE.

When I try to execute the sqql in Squirrel, the column names in the result always display the alias name as the column name instead of the Alias Name given in the SQL.

Do we have a solution to get the Alias Column or is this a bug?

Thanks

Rakesh

[shawkins]

> Do we have a solution to get the Alias Column or is this a bug?

There are two names available from the metadata - getColumnName and getColumnLabel.  The column label will always be the alias.  See [TEIID-1651] Due to a change in the JDBC spec on how the use of "AS" in the select statement will now be returned in the… for a property to control the behavior of getColumnName.