diff options
author | Alfranio Correia <alfranio.correia@sun.com> | 2009-10-22 01:10:42 +0100 |
---|---|---|
committer | Alfranio Correia <alfranio.correia@sun.com> | 2009-10-22 01:10:42 +0100 |
commit | deea727fced84c96e5f3f2f55d3a1a9fb5e475d0 (patch) | |
tree | 89b8b01574a400b075617b13a5f3700600abcfd2 /mysql-test/extra/rpl_tests/rpl_row_tabledefs.test | |
parent | 495cde347b1dad1cd93b7b4e15c721da9576c496 (diff) | |
download | mariadb-git-deea727fced84c96e5f3f2f55d3a1a9fb5e475d0.tar.gz |
BUG#48091 valgrind errors when slave has double not null and master has double null
Backporting BUG#38173 to mysql-5.1-bugteam
The reason of the bug was incompatibile with the master side behaviour.
INSERT query on the master is allowed to insert into a table without specifying
values of DEFAULT-less fields if sql_mode is not strict.
Fixed with checking sql_mode by the sql thread to decide how to react.
Non-strict sql_mode should allow Write_rows event to complete.
todo: warnings can be shown via show slave status, still this is a
separate rather general issue how to show warnings for the slave threads.
Diffstat (limited to 'mysql-test/extra/rpl_tests/rpl_row_tabledefs.test')
-rw-r--r-- | mysql-test/extra/rpl_tests/rpl_row_tabledefs.test | 15 |
1 files changed, 6 insertions, 9 deletions
diff --git a/mysql-test/extra/rpl_tests/rpl_row_tabledefs.test b/mysql-test/extra/rpl_tests/rpl_row_tabledefs.test index 3b03caee35c..083088f12ff 100644 --- a/mysql-test/extra/rpl_tests/rpl_row_tabledefs.test +++ b/mysql-test/extra/rpl_tests/rpl_row_tabledefs.test @@ -111,21 +111,18 @@ SELECT a,b,x FROM t1_int ORDER BY a; SELECT a,b,HEX(x),HEX(y),HEX(z) FROM t1_bit ORDER BY a; SELECT a,b,x FROM t1_char ORDER BY a; -# Each of these inserts should generate an error and stop the slave - connection master; INSERT INTO t9 VALUES (2); sync_slave_with_master; # Now slave is guaranteed to be running connection master; INSERT INTO t1_nodef VALUES (1,2); -connection slave; ---source include/wait_for_slave_sql_to_stop.inc ---replace_result $MASTER_MYPORT MASTER_PORT ---replace_column 1 # 4 # 7 # 8 # 9 # 20 <Last_Error> 22 # 23 # 33 # 35 <Last_IO_Errno> 36 <Last_IO_Error> 38 <Last_SQL_Error> ---query_vertical SHOW SLAVE STATUS -SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2; -START SLAVE; + +# Last insert on wider slave table succeeds while slave sql sql_mode permits. +# The previous version of the above test expected slave sql to stop. +# bug#38173 relaxed conditions to stop only with the strict mode. +sync_slave_with_master; +select count(*) from t1_nodef; # # Replicating to tables with fewer columns at the end works as of WL#3228 |