Bug #109931 getTypeInfo's result should be ordered by DATA_TYPE

• Submitted: 4 Feb 2023 6:47
• Modified: 6 Feb 2023 19:48
• Reporter: Jin Kwon
• Status: Duplicate
• Category: Connector / J
• Severity: S3 (Non-critical)
• Version: 8.0.32
• OS: Any
• CPU Architecture: Any
• Tags: jdbc, metadata

[4 Feb 2023 6:47] Jin Kwon

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

And I see following order.

TypeInfo(
    typeName=BINARY,
    dataType=-2,
    ...
)

TypeInfo(
    typeName=BIT,
    dataType=-7,
    ...
)

How to repeat:
N/A

Suggested fix:
Should ordered by DATA_TYPE as documented.

[6 Feb 2023 5:58] MySQL Verification Team

Hello Jin Kwon,

Thank you for the report and feedback.

regards,
Umesh

[6 Feb 2023 19:48] Filipe Silva

Duplicate of Bug#109807.