Description:
binlog_row_insert_select [ fail ]
Errors are (from /export/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_insert_select.result Tue Feb 14 12:21:52 2006
--- r/binlog_row_insert_select.reject Tue Feb 14 13:52:58 2006
***************
*** 4,10 ****
insert into t2 values(1),(2);
reset master;
insert into t1 select * from t2;
! ERROR 23000: Duplicate entry '2' for key 1
show binlog events;
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 4 Format_desc 1 102 Server ver: VERSION, Binlog ver: 4
--- 4,10 ----
insert into t2 values(1),(2);
reset master;
insert into t1 select * from t2;
! ERROR 23000: Duplicate entry '2' for key 'a'
show binlog events;
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 4 Format_desc 1 102 Server ver: VERSION, Binlog ver: 4
***************
*** 19,25 ****
insert into t1 values(1),(1);
reset master;
create table t2(unique(a)) select a from t1;
! ERROR 23000: Duplicate entry '1' for key 1
show binlog events;
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 4 Format_desc 1 102 Server ver: VERSION, Binlog ver: 4
--- 19,25 ----
insert into t1 values(1),(1);
reset master;
create table t2(unique(a)) select a from t1;
! ERROR 23000: Duplicate entry '1' for key 'a'
show binlog events;
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 4 Format_desc 1 102 Server ver: VERSION, Binlog ver: 4
-------------------------------------------------------
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.
rpl_row_basic_2myisam [ fail ]
rpl_row_basic_3innodb [ fail ]
rpl_row_create_table [ fail ]
How to repeat:
see above
