Bug #106758 DatabaseMetaData.getTypeInfo returns AUTO_INCREMENT = false for all datatypes
Submitted: 17 Mar 2022 12:02 Modified: 5 Jul 2022 20:14
Reporter: Ulf Weiland Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version:8.0.28 OS:Any
Assigned to: CPU Architecture:Any

[17 Mar 2022 12:02] Ulf Weiland 
Description:
Calling DatabaseMetaData.getTypeInfo, using the 8.0.28 version of the driver, will return false for all types in the AUTO_INCREMENT column.

When using Connector/J 5.0.49 this is not the case. I.e for a type such as BIGINT it will return true as expected.

Note that the 5.0.49 driver does mostly behave correct but returns true for NUMERIC and DECIMAL as well which i believe incorrect.  

How to repeat:
Call DatabaseMetaData.getTypeInfo

Suggested fix:
Return correct data.
[17 Mar 2022 14:35] MySQL Verification Team 
Hello Ulf Weiland,

Thank you for the report and feedback.

regards,
Umesh
[5 Jul 2022 20:14] Daniel So 
Posted by developer:
 
Added the following entry to the Connector/J 8.0.30 changelog: 

"DatabaseMetaData.getTypeInfo always returned false for AUTO_INCREMENT for all data types. With this fix, Connector/J returns the correct value for each data type. Also, the missing types DOUBLE UNSIGNED and DOUBLE PRECISION UNSIGNED have been added to the ResultSet."