Description:
binlog_row_mix_innodb_myisam [ fail ]
Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-gluh@mysql.com-20060214095121.info/mysql-5.1.7-beta-standard/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/binlog_row_mix_innodb_myisam.result Tue Feb 14 12:21:53 2006
--- r/binlog_row_mix_innodb_myisam.reject Tue Feb 14 14:10:28 2006
***************
*** 210,216 ****
master-bin.000001 316 Xid 1 # COMMIT /* xid= */
delete from t1;
delete from t2;
! alter table t2 type=MyISAM;
insert into t1 values (1);
begin;
select * from t1 for update;
--- 210,216 ----
master-bin.000001 316 Xid 1 # COMMIT /* xid= */
delete from t1;
delete from t2;
! alter table t2 engine=MyISAM;
insert into t1 values (1);
begin;
select * from t1 for update;
***************
*** 266,283 ****
master-bin.000001 420 Xid 1 # COMMIT /* xid= */
master-bin.000001 447 Query 1 # use `test`; delete from t2
master-bin.000001 524 Xid 1 # COMMIT /* xid= */
! master-bin.000001 551 Query 1 # use `test`; alter table t2 type=MyISAM
! master-bin.000001 640 Table_map 1 # test.t1
! master-bin.000001 679 Write_rows 1 #
! master-bin.000001 713 Xid 1 # COMMIT /* xid= */
! master-bin.000001 740 Table_map 1 # test.t2
! master-bin.000001 779 Write_rows 1 #
! master-bin.000001 813 Query 1 # use `test`; drop table t1,t2
! master-bin.000001 892 Query 1 # use `test`; create table t0 (n int)
! master-bin.000001 978 Table_map 1 # test.t0
! master-bin.000001 1017 Write_rows 1 #
! master-bin.000001 1051 Table_map 1 # test.t0
! master-bin.000001 1090 Write_rows 1 #
! master-bin.000001 1124 Query 1 # use `test`; create table t2 (n int) engine=innodb
do release_lock("lock1");
drop table t0,t2;
--- 266,283 ----
master-bin.000001 420 Xid 1 # COMMIT /* xid= */
master-bin.000001 447 Query 1 # use `test`; delete from t2
master-bin.000001 524 Xid 1 # COMMIT /* xid= */
! master-bin.000001 551 Query 1 # use `test`; alter table t2 engine=MyISAM
! master-bin.000001 642 Table_map 1 # test.t1
! master-bin.000001 681 Write_rows 1 #
! master-bin.000001 715 Xid 1 # COMMIT /* xid= */
! master-bin.000001 742 Table_map 1 # test.t2
! master-bin.000001 781 Write_rows 1 #
! master-bin.000001 815 Query 1 # use `test`; drop table t1,t2
! master-bin.000001 894 Query 1 # use `test`; create table t0 (n int)
! master-bin.000001 980 Table_map 1 # test.t0
! master-bin.000001 1019 Write_rows 1 #
! master-bin.000001 1053 Table_map 1 # test.t0
! master-bin.000001 1092 Write_rows 1 #
! master-bin.000001 1126 Query 1 # use `test`; create table t2 (n int) engine=innodb
do release_lock("lock1");
drop table t0,t2;
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
How to repeat:
see above
Description: binlog_row_mix_innodb_myisam [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-gluh@mysql.com-20060214095121.info/mysql-5.1.7-beta-standard/mysql-test/var/log/mysqltest-time) : mysqltest: Result length mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: ------------------------------------------------------- *** r/binlog_row_mix_innodb_myisam.result Tue Feb 14 12:21:53 2006 --- r/binlog_row_mix_innodb_myisam.reject Tue Feb 14 14:10:28 2006 *************** *** 210,216 **** master-bin.000001 316 Xid 1 # COMMIT /* xid= */ delete from t1; delete from t2; ! alter table t2 type=MyISAM; insert into t1 values (1); begin; select * from t1 for update; --- 210,216 ---- master-bin.000001 316 Xid 1 # COMMIT /* xid= */ delete from t1; delete from t2; ! alter table t2 engine=MyISAM; insert into t1 values (1); begin; select * from t1 for update; *************** *** 266,283 **** master-bin.000001 420 Xid 1 # COMMIT /* xid= */ master-bin.000001 447 Query 1 # use `test`; delete from t2 master-bin.000001 524 Xid 1 # COMMIT /* xid= */ ! master-bin.000001 551 Query 1 # use `test`; alter table t2 type=MyISAM ! master-bin.000001 640 Table_map 1 # test.t1 ! master-bin.000001 679 Write_rows 1 # ! master-bin.000001 713 Xid 1 # COMMIT /* xid= */ ! master-bin.000001 740 Table_map 1 # test.t2 ! master-bin.000001 779 Write_rows 1 # ! master-bin.000001 813 Query 1 # use `test`; drop table t1,t2 ! master-bin.000001 892 Query 1 # use `test`; create table t0 (n int) ! master-bin.000001 978 Table_map 1 # test.t0 ! master-bin.000001 1017 Write_rows 1 # ! master-bin.000001 1051 Table_map 1 # test.t0 ! master-bin.000001 1090 Write_rows 1 # ! master-bin.000001 1124 Query 1 # use `test`; create table t2 (n int) engine=innodb do release_lock("lock1"); drop table t0,t2; --- 266,283 ---- master-bin.000001 420 Xid 1 # COMMIT /* xid= */ master-bin.000001 447 Query 1 # use `test`; delete from t2 master-bin.000001 524 Xid 1 # COMMIT /* xid= */ ! master-bin.000001 551 Query 1 # use `test`; alter table t2 engine=MyISAM ! master-bin.000001 642 Table_map 1 # test.t1 ! master-bin.000001 681 Write_rows 1 # ! master-bin.000001 715 Xid 1 # COMMIT /* xid= */ ! master-bin.000001 742 Table_map 1 # test.t2 ! master-bin.000001 781 Write_rows 1 # ! master-bin.000001 815 Query 1 # use `test`; drop table t1,t2 ! master-bin.000001 894 Query 1 # use `test`; create table t0 (n int) ! master-bin.000001 980 Table_map 1 # test.t0 ! master-bin.000001 1019 Write_rows 1 # ! master-bin.000001 1053 Table_map 1 # test.t0 ! master-bin.000001 1092 Write_rows 1 # ! master-bin.000001 1126 Query 1 # use `test`; create table t2 (n int) engine=innodb do release_lock("lock1"); drop table t0,t2; ------------------------------------------------------- Please follow the instructions outlined at http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. How to repeat: see above