Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
ResultSetMetaData.getTableName returns table alias instead of real table name in for example following type of query.
SELECT id FROM t1 AS t1_alias
|
Currently ResultSetMetaData.getTableName would return t1_alias.
ResultSetMetaData.getTableName should return the real table name and this was fixed in the MySQL Connector/J some years back. An URL parameter called useOldAliasMetadataBehavior was introduced if someone wants to continue using the old behaviour.
Attachments
Issue Links
- relates to
-
CONJ-163 make column label name display instead column name when useOldAliasMetadataBehavior option true
-
- Closed
-
Hello~
i think additional fix need about alias thing of column
please read : http://dev.mysql.com/doc/connector-j/en/connector-j-installing-upgrading-5-1.html
ResultSetMetaData.getColumnName() is display real column (mariadb connector/j 1.1.8ver) so
if attach parameter ( useOldAliasMetadataBehavior=true)
then ResultSetMetaData.getColumnName() need display alias column name as getColumnLabel().
(mysql connector done, mariadb connector not yet)
Like table, column alias need old behaviour
Thanks.