| Subject: | failure of test rt88006-bit-prepare |
in DBD-mysql-4.031, test t/rt88006-bit-prepare.t fails (i.e. the "id_binary test contents" test parts) if the created table dbd_mysql_rt88006_bit_prep happens to be a MyISAM table. for an InnoDB table the test succeeds.
i do not see what exactly the test should check. is it intentional that, in the create statement, id_binary_test is defined as auto_increment, and later, in the insert statement, id_binary_test is set explicitly, and in kind of wrong order ?
then, in the select statement, MyISAM seems to emit values in insertion order, while InnoDB seems to emit in auto_increment variable order.
tested with mysql 5.5.33 and 5.5.42