Bug #96582 jdbc.MysqlParameterMetadata#isNullable doesnt check whether to be simple

• Submitted: 19 Aug 2019 4:47
• Modified: 23 Aug 2019 13:59
• Reporter: Daren Klamer
• Status: Verified
• Category: Connector / J
• Severity: S3 (Non-critical)
• Version: 8.0.17
• OS: Any
• CPU Architecture: Any

[19 Aug 2019 4:47] Daren Klamer

Description:
It seems as though com.mysql.cj.jdbc.MysqlParameterMetadata#isNullable doesn't check whether to return simple meta data or not, whereas all the other related methods do. 

Perhaps when this is true the driver can return https://docs.oracle.com/javase/7/docs/api/java/sql/ParameterMetaData.html#parameterNullabl... ?

How to repeat:
Invoke com.mysql.cj.jdbc.MysqlParameterMetadata#isNullable even when generateSimpleParameterMetdata is set to true on the connection URL

Suggested fix:
Return https://docs.oracle.com/javase/7/docs/api/java/sql/ParameterMetaData.html#parameterNullabl... when com.mysql.cj.jdbc.MysqlParameterMetadata#returnSimpleMetadata is true

[23 Aug 2019 13:59] Alexander Soklakov

Hi Daren,

Right, it makes sense, thanks! Verified by code review.