| 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.