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:
None 
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
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.