Bug #66911 align the Resultsets returned by JDBC metadata methods to the JDBC docs
Submitted: 21 Sep 2012 15:23 Modified: 14 Dec 2012 22:07
Reporter: the 6campbells Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version:5.1.12, 5.1.22 OS:Any
Assigned to: CPU Architecture:Any

[21 Sep 2012 15:23] the 6campbells 
Description:
The JDBC 3.0/4.0 documentation describes per metadata method what the set of columns are that the method should return. The responses from the MySQL driver do not align re # of columns, column type etc. 

getUDTS returns 6 columns not 7
getTables returns 5 columns not 10
..

How to repeat:
Write a custom JDBC program which calls each JDBC metadata method. Review the result set of each method against the documentation on the ORACLE JDBC API web pages. Review the results in terms of # of columns, types of columns, if the column name aligns (name, case etc) to the docs. 

Suggested fix:
Fix them up and for columns where MySQL has not equivalent object concept in the DB return the applicable value JDBC defines would be valid/appropriate in those cases.
[14 Dec 2012 22:05] Sveta Smirnova 
Thank you for the report.

Verified as described by reading code.
[14 Dec 2012 22:07] Sveta Smirnova 
This is actually duplicate of bug #44451