I have been able to reproduce the problem using The MySqlConnector/J versions 5.1.6 and 3.0.17. The driver reports the SQL type "Types.BIT" for a "TINYINT(1) UNSIGNED" column. This is why the DatabaseTableMetaData has the wrong DataType set for the column which is the dbunit DataType.BIT.
I added the exceptional type "TINYINT UNSIGNED" as type name to the MySqlDataTypeFactory (SVN rev. 829/trunk). Should work in the next release (probably 2.4)
Thanks and regards,
mat
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have been able to reproduce the problem using The MySqlConnector/J versions 5.1.6 and 3.0.17. The driver reports the SQL type "Types.BIT" for a "TINYINT(1) UNSIGNED" column. This is why the DatabaseTableMetaData has the wrong DataType set for the column which is the dbunit DataType.BIT.
I added the exceptional type "TINYINT UNSIGNED" as type name to the MySqlDataTypeFactory (SVN rev. 829/trunk). Should work in the next release (probably 2.4)
Thanks and regards,
mat