[teiid-issues] [JBoss JIRA] Assigned: (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 getColumnLabel of the ResultSetMetadata, Teiid must provide backwards support

Due to a change in the JDBC spec on how the use of "AS" in the select statement will now be returned in the getColumnLabel of the ResultSetMetadata, Teiid must provide backwards support ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Key: TEIID-1651 URL: https://issues.jboss.org/browse/TEIID-1651 Project: Teiid Issue Type: Bug Components: JDBC Driver Affects Versions: 7.4.1 Reporter: Van Halbert Assignee: Steven Hawkins Priority: Blocker Teiid has already applied a fix to support the JDBC spec change for when an alias is used in the select clause. The spec change says the "AS" name will now be returned when getColumnLabel() is called, instead of getColumnName(). Unfortunately, this breaks backwards compatibility in 5.2 and any vendor/client that is using EDS and depending on metadata. To resolve the issue, the JDBC driver, to provide support for backwards compatibility, can allow the user to specify the useJDBC4ColumnNameAndLabelSemantics=true (default is false) property on the url (this is the recommended spec property). Therefore, for 5.2, the default for this property should be set to "TRUE", so that the user doesn't have to make any changes in order to expect the same behavior. I would recommend in a future major release (i.e., 6.0) this default be changed to the industry standard of "TRUE".