dbUnit / Bugs / #105 tinyint being ignored

#105 tinyint being ignored

Milestone: v2.1

Status: closed-fixed

Owner: matthias g

Labels: None

Fixed Release:

Priority: 5

Updated: 2008-10-07

Created: 2005-11-01

Creator: Ian J Joyce

Private: No

MySQL: 4.1.12-max
DBUnit: 2.1

Any columns I have defined like:

column_name tinyint(1) UNSIGNED NOT NULL default 0,

are being ignored when running a CLEAN_INSERT.

Discussion

matthias g - 2008-10-07

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:

matthias g - 2008-10-07

assigned_to: rlogiacco --> gommma

status: open --> closed-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.