Bug #105546 ResultSetMetadata.getColumnTypeName() return string differs from documentation
Submitted: 12 Nov 2021 12:42 Modified: 17 Nov 2021 21:18
Reporter: David Sambucci Email Updates:
Status: Closed Impact on me:
Category:Connector / J Documentation Severity:S3 (Non-critical)
Version:8 OS:Any
Assigned to: CPU Architecture:Any
Tags: getColumnTypeName, longtext

[12 Nov 2021 12:42] David Sambucci
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".


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 
to reflect the change
[12 Nov 2021 13:11] MySQL Verification Team
Hello David,

Thank you for the report and feedback.

[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.