Change in behavior of ResultSetMetadata.getColumName() between teiid 7.3 and 7.6?

[sanjeev.gour]

When the following query is against teiid 7.3 and teiid 7.6, I see some change in behavior of the method ResultSetMetadata.getColumnName()-

select  n as END_TIME  from (select now() as n) a

This sample gives two different results against 7.3 and 7.6-

ResultSet rs = st.executeQuery("select  n as END_TIME  from (select now() as n)

ResultSetMetaData m = rs.getMetaData();

System.out.println("Column Label "+m.getColumnLabel(1));

System.out.println("Column Name "+m.getColumnName(1));

on 7.3-

Column Label END_TIME

Column Name END_TIME

and on 7.6-

Column Label END_TIME

Column Name n

The Javadoc says this-

getColumnLabel(int column) 

           Gets the designated column's suggested title for use in printouts and displays.

getColumnName(int column) 

           Get the designated column's name.

It looks like the behavior in 7.6 is correct, was this a bug in 7.3 and got fixed in 7.6?

[shawkins]

Sanjeev,

Yes, the 7.3 behavior was a typical pre-JDBC 4.0 implementation in which most vendors simply returned the same value for both label and name.  7.4 was updated to be correct as per JDBC 4.0 and https://issues.jboss.org/browse/TEIID-1651 added a URL property to switch the behavior back to old way if needed.  This is listed in the release notes under the compatibility issues section - http://docs.jboss.org/teiid/7.6.0.Final/teiid-releasenotes.html#Configuration.  You'll want to check to see if there is anything else that may affect you.

Steve