|Subject:||Error Testing with MySQL 5.1|
In the latest beta version of MySQL 5 (5.0.4) there is an error with t/mysql.t. The create table statement specifies the default value for the "val" column as being 'A', but "val" is a SMALLINT field. It looks like MySQL 5.x is stricter than 4.x and does not allow characters as the default value for numeric fields. To fix this I changed line 33 of t/mysql.t from: val SMALLINT UNSIGNED NOT NULL DEFAULT 'A', To: val SMALLINT UNSIGNED NOT NULL, And the test case now passes.