rpl.rpl_row_ignorable_event 'row' [ fail ] Test ended at 2010-11-01 13:11:09 CURRENT_TEST: rpl.rpl_row_ignorable_event --- /export/home/tmp/je159969/mysql/snapshots/wl2540-mysql-5.6.99-m5/mysql-test/suite/rpl/r/rpl_row_ignorable_event.result 2010-10-28 20:28:55.000000000 +0300 +++ /export/home/tmp/je159969/mysql/snapshots/wl2540-mysql-5.6.99-m5/mysql-test/suite/rpl/r/rpl_row_ignorable_event.reject 2010-11-01 15:11:09.000000000 +0300 @@ -147,11 +147,11 @@ /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at # -#server id # end_log_pos # Start: binlog v#, server v #.##.## created # #:#:# at startup +#server id # end_log_pos # CRC32 0xa4559c94 Start: binlog v#, server v #.##.## created # #:#:# at startup # Warning: this binlog is either in use or was not closed properly. ROLLBACK/*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x0e40477b Query thread_id=# exec_time=# error_code=# use test/*!*/; SET TIMESTAMP=t/*!*/; SET @@session.pseudo_thread_id=#/*!*/; @@ -165,17 +165,17 @@ create table t1(a int, b int) engine= myisam /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0xd4e1bc29 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; BEGIN /*!*/; # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0x64fe1714 Rows_query # insert into t1(a,b) values(1,1),(2,1) # at # # at # -#server id # end_log_pos # Table_map: `test`.`t1` mapped to number # -#server id # end_log_pos # Write_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0x8bf9ae82 Table_map: `test`.`t1` mapped to number # +#server id # end_log_pos # CRC32 0x0e3f4e09 Write_rows: table id # flags: STMT_END_F ### INSERT INTO test.t1 ### SET ### @1=1 /* INT meta=0 nullable=1 is_null=0 */ @@ -184,23 +184,27 @@ ### SET ### @1=2 /* INT meta=0 nullable=1 is_null=0 */ ### @2=1 /* INT meta=0 nullable=1 is_null=0 */ +### INSERT INTO test.t1 +### SET +### @1=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### @2=933710 /* INT meta=0 nullable=1 is_null=0 */ # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x01f18d48 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; COMMIT /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0xcf2550eb Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; BEGIN /*!*/; # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0xf62d5f80 Rows_query # update t1 set a = a + 5 where b = 1 LIMIT 1 # at # # at # -#server id # end_log_pos # Table_map: `test`.`t1` mapped to number # -#server id # end_log_pos # Update_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0xe3eb6420 Table_map: `test`.`t1` mapped to number # +#server id # end_log_pos # CRC32 0x645333dd Update_rows: table id # flags: STMT_END_F ### UPDATE test.t1 ### WHERE ### @1=1 /* INT meta=0 nullable=1 is_null=0 */ @@ -208,49 +212,64 @@ ### SET ### @1=6 /* INT meta=0 nullable=1 is_null=0 */ ### @2=1 /* INT meta=0 nullable=1 is_null=0 */ +### UPDATE test.t1 +### WHERE +### @1=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### @2=6574899 /* INT meta=0 nullable=1 is_null=0 */ +### SET +### @1=0 /* INT meta=0 nullable=1 is_null=0 */ +### @2=17 /* INT meta=0 nullable=1 is_null=0 */ # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x642c815f Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; COMMIT /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0xa2225568 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; BEGIN /*!*/; # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0xd729d2f7 Rows_query # delete from t1 where a = 6 # at # # at # -#server id # end_log_pos # Table_map: `test`.`t1` mapped to number # -#server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0xc6d88ccb Table_map: `test`.`t1` mapped to number # +#server id # end_log_pos # CRC32 0xabaa855b Delete_rows: table id # flags: STMT_END_F ### DELETE FROM test.t1 ### WHERE ### @1=6 /* INT meta=0 nullable=1 is_null=0 */ ### @2=1 /* INT meta=0 nullable=1 is_null=0 */ +### DELETE FROM test.t1 +### WHERE +### @1=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### @2=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### DELETE FROM test.t1 +### WHERE +### @1=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### @2=234924970 /* INT meta=0 nullable=1 is_null=0 */ # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0xde8d9568 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; COMMIT /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0xdb157884 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; create table t2(a int, b int) engine=innodb /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x03ea6215 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; BEGIN /*!*/; # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0x76455c57 Rows_query # insert into t2(a,b) values(2,1),(3,1) # at # # at # -#server id # end_log_pos # Table_map: `test`.`t2` mapped to number # -#server id # end_log_pos # Write_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0xddd68559 Table_map: `test`.`t2` mapped to number # +#server id # end_log_pos # CRC32 0xffca4b89 Write_rows: table id # flags: STMT_END_F ### INSERT INTO test.t2 ### SET ### @1=2 /* INT meta=0 nullable=1 is_null=0 */ @@ -259,13 +278,17 @@ ### SET ### @1=3 /* INT meta=0 nullable=1 is_null=0 */ ### @2=1 /* INT meta=0 nullable=1 is_null=0 */ +### INSERT INTO test.t2 +### SET +### @1=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### @2=553634379 /* INT meta=0 nullable=1 is_null=0 */ # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0xa6665e2d Rows_query # update t2 set a = a + 5 where b = 1 # at # # at # -#server id # end_log_pos # Table_map: `test`.`t2` mapped to number # -#server id # end_log_pos # Update_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0x4d10d5a6 Table_map: `test`.`t2` mapped to number # +#server id # end_log_pos # CRC32 0xf1b1bf0a Update_rows: table id # flags: STMT_END_F ### UPDATE test.t2 ### WHERE ### @1=2 /* INT meta=0 nullable=1 is_null=0 */ @@ -280,170 +303,221 @@ ### SET ### @1=8 /* INT meta=0 nullable=1 is_null=0 */ ### @2=1 /* INT meta=0 nullable=1 is_null=0 */ +### UPDATE test.t2 +### WHERE +### @1=821146047 /* INT meta=0 nullable=1 is_null=0 */ +### @2=NULL /* INT meta=0 nullable=1 is_null=1 */ +### SET +### @1=2162688 /* INT meta=0 nullable=1 is_null=0 */ +### @2=1702100992 /* INT meta=0 nullable=1 is_null=0 */ # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0x239ef2fd Rows_query # delete from t2 where a = 7 # at # # at # -#server id # end_log_pos # Table_map: `test`.`t2` mapped to number # -#server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0x38d86c30 Table_map: `test`.`t2` mapped to number # +#server id # end_log_pos # CRC32 0x61e06ddf Delete_rows: table id # flags: STMT_END_F ### DELETE FROM test.t2 ### WHERE ### @1=7 /* INT meta=0 nullable=1 is_null=0 */ ### @2=1 /* INT meta=0 nullable=1 is_null=0 */ +### DELETE FROM test.t2 +### WHERE +### @1=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### @2=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### DELETE FROM test.t2 +### WHERE +### @1=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### @2=16802272 /* INT meta=0 nullable=1 is_null=0 */ # at # -#server id # end_log_pos # Xid = # +#server id # end_log_pos # CRC32 0x80e53e6f Xid = # COMMIT/*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0xa977be14 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; BEGIN /*!*/; # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0xc1d84df5 Rows_query # insert into t1(a,b) values(1,5) # at # # at # -#server id # end_log_pos # Table_map: `test`.`t1` mapped to number # -#server id # end_log_pos # Write_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0x6718a9bc Table_map: `test`.`t1` mapped to number # +#server id # end_log_pos # CRC32 0x7bf5c1cc Write_rows: table id # flags: STMT_END_F ### INSERT INTO test.t1 ### SET ### @1=1 /* INT meta=0 nullable=1 is_null=0 */ ### @2=5 /* INT meta=0 nullable=1 is_null=0 */ +### INSERT INTO test.t1 +### SET +### @1=1316746689 /* INT meta=0 nullable=1 is_null=0 */ +### @2=0 /* INT meta=0 nullable=1 is_null=0 */ # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x0f93fac9 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; COMMIT /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x3b72d820 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; BEGIN /*!*/; # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0xab6e0b4d Rows_query # insert into t1(a,b) values(1,7) # at # # at # -#server id # end_log_pos # Table_map: `test`.`t1` mapped to number # -#server id # end_log_pos # Write_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0xceef909b Table_map: `test`.`t1` mapped to number # +#server id # end_log_pos # CRC32 0x15e5833f Write_rows: table id # flags: STMT_END_F ### INSERT INTO test.t1 ### SET ### @1=1 /* INT meta=0 nullable=1 is_null=0 */ ### @2=7 /* INT meta=0 nullable=1 is_null=0 */ +### INSERT INTO test.t1 +### SET +### @1=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### @2=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### INSERT INTO test.t1 +### SET +### @1=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### @2=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### INSERT INTO test.t1 +### SET +### @1=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### @2=19989 /* INT meta=0 nullable=1 is_null=0 */ # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x2150d37f Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; COMMIT /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x4c843b86 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; BEGIN /*!*/; # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0xead72bb0 Rows_query # insert into t2(a,b) values(2,5) # at # # at # -#server id # end_log_pos # Table_map: `test`.`t2` mapped to number # -#server id # end_log_pos # Write_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0x5eebf3fe Table_map: `test`.`t2` mapped to number # +#server id # end_log_pos # CRC32 0x936d20e8 Write_rows: table id # flags: STMT_END_F ### INSERT INTO test.t2 ### SET ### @1=2 /* INT meta=0 nullable=1 is_null=0 */ ### @2=5 /* INT meta=0 nullable=1 is_null=0 */ +### INSERT INTO test.t2 +### SET +### @1=1318284576 /* INT meta=0 nullable=1 is_null=0 */ +### @2=0 /* INT meta=0 nullable=1 is_null=0 */ # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0x95b1c1fd Rows_query # insert into t2(a,b) values(2,6) # at # # at # -#server id # end_log_pos # Table_map: `test`.`t2` mapped to number # -#server id # end_log_pos # Write_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0xdfa4302c Table_map: `test`.`t2` mapped to number # +#server id # end_log_pos # CRC32 0xbab56573 Write_rows: table id # flags: STMT_END_F ### INSERT INTO test.t2 ### SET ### @1=2 /* INT meta=0 nullable=1 is_null=0 */ ### @2=6 /* INT meta=0 nullable=1 is_null=0 */ +### INSERT INTO test.t2 +### SET +### @1=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### @2=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### INSERT INTO test.t2 +### SET +### @1=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### @2=5159605 /* INT meta=0 nullable=1 is_null=0 */ # at # -#server id # end_log_pos # Xid = # +#server id # end_log_pos # CRC32 0x7dc5c0fc Xid = # COMMIT/*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x1af0b966 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; DROP TABLE `t1`,`t2` /* generated by server */ /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x5cc26bd6 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; create table t3(a int, b int) engine= myisam /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x1bf9d547 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; create table t4(a int, b int) engine= myisam /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x18bbef18 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; create table t5(a int, b int) engine= myisam /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x27c6f29b Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; BEGIN /*!*/; # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0x1906b9c0 Rows_query # insert into t3(a, b) values(1,1) # at # # at # -#server id # end_log_pos # Table_map: `test`.`t3` mapped to number # -#server id # end_log_pos # Write_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0x78cb554a Table_map: `test`.`t3` mapped to number # +#server id # end_log_pos # CRC32 0x0eb9b8ea Write_rows: table id # flags: STMT_END_F ### INSERT INTO test.t3 ### SET ### @1=1 /* INT meta=0 nullable=1 is_null=0 */ ### @2=1 /* INT meta=0 nullable=1 is_null=0 */ +### INSERT INTO test.t3 +### SET +### @1=1309587896 /* INT meta=0 nullable=1 is_null=0 */ +### @2=NULL /* INT meta=0 nullable=1 is_null=1 */ # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x6acac973 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; COMMIT /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x9f309fbb Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; BEGIN /*!*/; # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0x2581c887 Rows_query # insert into t4(a, b) values(2,1) # at # # at # -#server id # end_log_pos # Table_map: `test`.`t4` mapped to number # -#server id # end_log_pos # Write_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0x0a01ae66 Table_map: `test`.`t4` mapped to number # +#server id # end_log_pos # CRC32 0x78dce410 Write_rows: table id # flags: STMT_END_F ### INSERT INTO test.t4 ### SET ### @1=2 /* INT meta=0 nullable=1 is_null=0 */ ### @2=1 /* INT meta=0 nullable=1 is_null=0 */ +### INSERT INTO test.t4 +### SET +### @1=1316543716 /* INT meta=0 nullable=1 is_null=0 */ +### @2=0 /* INT meta=0 nullable=1 is_null=0 */ # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x26b1b29c Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; COMMIT /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x79cfbbc6 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; BEGIN /*!*/; # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0xe604bada Rows_query # update t3,t4 set t3.a=3, t4.a=4 where t3.b=t4.b # at # # at # # at # # at # -#server id # end_log_pos # Table_map: `test`.`t3` mapped to number # -#server id # end_log_pos # Table_map: `test`.`t4` mapped to number # -#server id # end_log_pos # Update_rows: table id # -#server id # end_log_pos # Update_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0xd1431e0c Table_map: `test`.`t3` mapped to number # +#server id # end_log_pos # CRC32 0xadc5bf56 Table_map: `test`.`t4` mapped to number # +#server id # end_log_pos # CRC32 0xdc157644 Update_rows: table id # +#server id # end_log_pos # CRC32 0xafd2acae Update_rows: table id # flags: STMT_END_F ### UPDATE test.t3 ### WHERE ### @1=1 /* INT meta=0 nullable=1 is_null=0 */ @@ -451,6 +525,13 @@ ### SET ### @1=3 /* INT meta=0 nullable=1 is_null=0 */ ### @2=1 /* INT meta=0 nullable=1 is_null=0 */ +### UPDATE test.t3 +### WHERE +### @1=551294326 /* INT meta=0 nullable=1 is_null=0 */ +### @2=727361597 /* INT meta=0 nullable=1 is_null=0 */ +### SET +### @1=17 /* INT meta=0 nullable=1 is_null=0 */ +### @2=NULL /* INT meta=0 nullable=1 is_null=1 */ ### UPDATE test.t4 ### WHERE ### @1=2 /* INT meta=0 nullable=1 is_null=0 */ @@ -458,46 +539,57 @@ ### SET ### @1=4 /* INT meta=0 nullable=1 is_null=0 */ ### @2=1 /* INT meta=0 nullable=1 is_null=0 */ +### UPDATE test.t4 +### WHERE +### @1=548393644 /* INT meta=0 nullable=1 is_null=0 */ +### @2=NULL /* INT meta=0 nullable=1 is_null=1 */ +### SET +### @1=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### @2=170613416 /* INT meta=0 nullable=1 is_null=0 */ # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0xdec9e661 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; COMMIT /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x7b8fb950 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; BEGIN /*!*/; # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0x440621fe Rows_query # insert into t5(a, b) values(3,1) # at # # at # -#server id # end_log_pos # Table_map: `test`.`t5` mapped to number # -#server id # end_log_pos # Write_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0x6062f3d0 Table_map: `test`.`t5` mapped to number # +#server id # end_log_pos # CRC32 0x14710d08 Write_rows: table id # flags: STMT_END_F ### INSERT INTO test.t5 ### SET ### @1=3 /* INT meta=0 nullable=1 is_null=0 */ ### @2=1 /* INT meta=0 nullable=1 is_null=0 */ +### INSERT INTO test.t5 +### SET +### @1=1309962509 /* INT meta=0 nullable=1 is_null=0 */ +### @2=0 /* INT meta=0 nullable=1 is_null=0 */ # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x66209b00 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; COMMIT /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x8f53973a Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; BEGIN /*!*/; # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0x818a6c17 Rows_query # update t4,t5 set t4.a=4, t5.a=5 where t4.b=t5.b # at # # at # # at # -#server id # end_log_pos # Table_map: `test`.`t4` mapped to number # -#server id # end_log_pos # Table_map: `test`.`t5` mapped to number # -#server id # end_log_pos # Update_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0xe4d237c6 Table_map: `test`.`t4` mapped to number # +#server id # end_log_pos # CRC32 0xd422b6d9 Table_map: `test`.`t5` mapped to number # +#server id # end_log_pos # CRC32 0xa4b9c6e0 Update_rows: table id # flags: STMT_END_F ### UPDATE test.t5 ### WHERE ### @1=3 /* INT meta=0 nullable=1 is_null=0 */ @@ -505,23 +597,30 @@ ### SET ### @1=5 /* INT meta=0 nullable=1 is_null=0 */ ### @2=1 /* INT meta=0 nullable=1 is_null=0 */ +### UPDATE test.t5 +### WHERE +### @1=547666374 /* INT meta=0 nullable=1 is_null=0 */ +### @2=727373885 /* INT meta=0 nullable=1 is_null=0 */ +### SET +### @1=17 /* INT meta=0 nullable=1 is_null=0 */ +### @2=NULL /* INT meta=0 nullable=1 is_null=1 */ # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0xdb66f385 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; COMMIT /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x902032ba Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; BEGIN /*!*/; # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0xbecd8bb0 Rows_query # insert delayed into t3(a,b) values(1,5),(1,6),(1,7) # at # # at # -#server id # end_log_pos # Table_map: `test`.`t3` mapped to number # -#server id # end_log_pos # Write_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0xe0bb8f46 Table_map: `test`.`t3` mapped to number # +#server id # end_log_pos # CRC32 0xa279b1bb Write_rows: table id # flags: STMT_END_F ### INSERT INTO test.t3 ### SET ### @1=1 /* INT meta=0 nullable=1 is_null=0 */ @@ -534,30 +633,38 @@ ### SET ### @1=1 /* INT meta=0 nullable=1 is_null=0 */ ### @2=7 /* INT meta=0 nullable=1 is_null=0 */ +### INSERT INTO test.t3 +### SET +### @1=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### @2=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### INSERT INTO test.t3 +### SET +### @1=NULL /* type=3 meta=0 nullable=1 is_null=1 */ +### @2=2728569 /* INT meta=0 nullable=1 is_null=0 */ # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x2ccaa5ea Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; COMMIT /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x642a10b9 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; create table t6(a VARCHAR(60)) engine= myisam /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0xfe14037b Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; BEGIN /*!*/; # at # -#server id # end_log_pos # Rows_query +#server id # end_log_pos # CRC32 0x93b6586d Rows_query # load data infile '../../std_data/words.dat' into table t6 # at # # at # # at # -#server id # end_log_pos # Table_map: `test`.`t6` mapped to number # -#server id # end_log_pos # Write_rows: table id # -#server id # end_log_pos # Write_rows: table id # flags: STMT_END_F +#server id # end_log_pos # CRC32 0xaaba999d Table_map: `test`.`t6` mapped to number # +#server id # end_log_pos # CRC32 0xf009f455 Write_rows: table id # +#server id # end_log_pos # CRC32 0x77de0164 Write_rows: table id # flags: STMT_END_F ### INSERT INTO test.t6 ### SET ### @1='Aarhus' /* VARSTRING(60) meta=60 nullable=1 is_null=0 */ @@ -722,6 +829,12 @@ ### @1='abdominal' /* VARSTRING(60) meta=60 nullable=1 is_null=0 */ ### INSERT INTO test.t6 ### SET +### @1=NULL /* type=15 meta=60 nullable=1 is_null=1 */ +### INSERT INTO test.t6 +### SET +### @1='\x00\x00Q\x00\x00\x00\x00' /* VARSTRING(60) meta=60 nullable=1 is_null=0 */ +### INSERT INTO test.t6 +### SET ### @1='abduct' /* VARSTRING(60) meta=60 nullable=1 is_null=0 */ ### INSERT INTO test.t6 ### SET @@ -768,18 +881,24 @@ ### INSERT INTO test.t6 ### SET ### @1='aberration' /* VARSTRING(60) meta=60 nullable=1 is_null=0 */ +### INSERT INTO test.t6 +### SET +### @1='?' /* VARSTRING(60) meta=60 nullable=1 is_null=0 */ +### INSERT INTO test.t6 +### SET +### @1=NULL /* type=15 meta=60 nullable=1 is_null=1 */ # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x2e99409b Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; COMMIT /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x18e3e5e9 Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; DROP TABLE `t3`,`t6` /* generated by server */ /*!*/; # at # -#server id # end_log_pos # Query thread_id=# exec_time=# error_code=# +#server id # end_log_pos # CRC32 0x0aa1bcbc Query thread_id=# exec_time=# error_code=# SET TIMESTAMP=t/*!*/; DROP TABLE `t4`,`t5` /* generated by server */ /*!*/; mysqltest: Result content mismatch Warnings from just before the error: Note 1051 Unknown table 'test.t1' Note 1051 Unknown table 'test.t2' Note 1051 Unknown table 'test.t3' Note 1051 Unknown table 'test.t4' Note 1051 Unknown table 'test.t5' Note 1051 Unknown table 'test.t6' Note 1051 Unknown table 'test.t7' Note 1051 Unknown table 'test.t8' - saving '/export/home/tmp/je159969/mysql/snapshots/wl2540-mysql-5.6.99-m5/mysql-test/var/log/rpl.rpl_row_ignorable_event-row/' to '/export/home/tmp/je159969/mysql/snapshots/wl2540-mysql-5.6.99-m5/mysql-test/var/log/rpl.rpl_row_ignorable_event-row/' ------------------------------------------------------------ The servers were restarted 0 times Spent 0.000 of 14 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): rpl.rpl_row_ignorable_event The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html mysql-test-run: *** ERROR: there were failing test cases