Bug #36830 DatabaseMetaData.getColumns() returns incorrect COLUMN_SIZE value for SET column
Submitted: 20 May 2008 21:08 Modified: 7 Jul 2008 12:42
Reporter: Matthew Lord Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version:5.1.6 OS:Any
Assigned to: Mark Matthews CPU Architecture:Any

[20 May 2008 21:08] Matthew Lord
Description:
CREATE TABLE testtable (I INT, S SET('1','2','3','4','1585','ONE','TWO','Y','N','THREE'))

COLUMN_SIZE of S is 24

How to repeat:
javac Repro.java

java Repro

# Repro.java attached
[20 May 2008 21:10] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/46895
[7 Jul 2008 12:42] Tony Bedford
An entry has been added to the 5.1.6 Changelog:

DatabaseMetaData.getColumns() returns incorrect COLUMN_SIZE value for SET column.
[30 Jul 2008 14:53] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/50724