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
-
Activity
Field | Original Value | New Value |
---|---|---|
Status | Open [ 1 ] | In Progress [ 3 ] |
Fix Version/s | 1.1.9 [ 16400 ] |
Workflow | MariaDB connectors [ 60575 ] | MariaDB v3 [ 70192 ] |
Component/s | Other [ 12201 ] | |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 70192 ] | MariaDB v4 [ 134768 ] |
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.