Bug #109807 DatabaseMetaData#getTypeInfo should ordered by DATA_TYPE

• Submitted: 27 Jan 2023 5:05
• Modified: 23 Mar 2023 18:15
• Reporter: Jin Kwon
• Status: Closed
• Category: Connector / J
• Severity: S3 (Non-critical)
• Version: 8.0.32
• OS: Any
• CPU Architecture: Any
• Tags: DatabaseMetaData

[27 Jan 2023 5:05] Jin Kwon

Description:
DatabaseMetaData#getTypeInfo's result should be ordered by DATA_TYPE.

I see the following order.

dataType=-2
dataType=-7
dataType=-5

How to repeat:
Invoke and see.

[27 Jan 2023 8:07] MySQL Verification Team

Hello Jin Kwon,

Thank you for the report and feedback.

regards,
Umesh

[23 Mar 2023 18:15] Daniel So

Posted by developer:
 
Added the following entry to the C/J 8.0.33 changelog: 

"Results returned by the getTypeInfo() method of the DatabaseMetadata interface were not sorted by DATA_TYPE as required by the JDBC specification."