Bug #105546 ResultSetMetadata.getColumnTypeName() return string differs from documentation

• Submitted: 12 Nov 2021 12:42
• Modified: 17 Nov 2021 21:18
• Reporter: David Sambucci
• Status: Closed
• Category: Connector / J Documentation
• Severity: S3 (Non-critical)
• Version: 8
• OS: Any
• CPU Architecture: Any
• Tags: getColumnTypeName, longtext

[12 Nov 2021 12:42] David Sambucci

Description:
The page https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-type-conversions.html says that the Return value of GetColumnTypeName for a "LONGTEXT" column is "VARCHAR"

This was true for version 5 of the connector, but seems that version 8 returns "LONGTEXT" instead of "VARCHAR".

Thanks

How to repeat:
call ResultSetMetadata.GetColumnTypeName() on a column of type "LONGTEXT" using the connector version 8 and it will return "LONGTEXT" but the documentation says it returns "VARCHAR"

Suggested fix:
Either make sure the new version of the connector returns the same type returned by the version 5 or update the documentation page 
https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-type-conversions.html
to reflect the change

[12 Nov 2021 13:11] MySQL Verification Team

Hello David,

Thank you for the report and feedback.

regards,
Umesh

[17 Nov 2021 21:18] Daniel So

Posted by developer:
 
Table 6.20 on https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-type-conversions.html has been updated to reflect behavior of Connector/J 8.0.