2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
1
include/master-slave.inc
8
4
SET @my_sql_mode= @@global.sql_mode;
9
5
SET GLOBAL SQL_MODE='STRICT_ALL_TABLES';
118
114
SELECT * FROM t2;
121
Checking that both slave threads are running.
117
include/check_slave_is_running.inc
122
118
INSERT INTO t9 VALUES (4);
123
119
INSERT INTO t4 VALUES (4);
124
--source include/wait_for_slave_sql_error_and_skip.inc
125
Last_SQL_Error = Table definition on master and slave does not match: Column 0 type mismatch - received type 3, test.t4 has type 4
126
SET GLOBAL SQL_SLAVE_SKIP_COUNTER= 2;
127
include/start_slave.inc
120
call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column [012] type mismatch.* Error_code: 1535");
121
include/wait_for_slave_sql_error_and_skip.inc [errno=1535]
122
Last_SQL_Error = 'Table definition on master and slave does not match: Column 0 type mismatch - received type 3, test.t4 has type 4'
128
123
INSERT INTO t9 VALUES (5);
129
124
INSERT INTO t5 VALUES (5,10,25);
130
--source include/wait_for_slave_sql_error_and_skip.inc
131
Last_SQL_Error = Table definition on master and slave does not match: Column 1 type mismatch - received type 3, test.t5 has type 4
132
SET GLOBAL SQL_SLAVE_SKIP_COUNTER= 2;
133
include/start_slave.inc
125
include/wait_for_slave_sql_error_and_skip.inc [errno=1535]
126
Last_SQL_Error = 'Table definition on master and slave does not match: Column 1 type mismatch - received type 3, test.t5 has type 4'
134
127
INSERT INTO t9 VALUES (6);
135
128
INSERT INTO t6 VALUES (6,12,36);
136
--source include/wait_for_slave_sql_error_and_skip.inc
137
Last_SQL_Error = Table definition on master and slave does not match: Column 2 type mismatch - received type 3, test.t6 has type 4
138
SET GLOBAL SQL_SLAVE_SKIP_COUNTER= 2;
139
include/start_slave.inc
129
include/wait_for_slave_sql_error_and_skip.inc [errno=1535]
130
Last_SQL_Error = 'Table definition on master and slave does not match: Column 2 type mismatch - received type 3, test.t6 has type 4'
140
131
INSERT INTO t9 VALUES (6);
141
Checking that both slave threads are running.
132
include/check_slave_is_running.inc
142
133
INSERT INTO t7 VALUES (1),(2),(3);
143
134
INSERT INTO t8 VALUES (1),(2),(3);
144
135
SELECT * FROM t7 ORDER BY a;
194
185
DROP TABLE IF EXISTS t1_int,t1_bit,t1_char,t1_nodef;
195
186
DROP TABLE IF EXISTS t2,t3,t4,t5,t6,t7,t8,t9;
196
187
SET @@global.sql_mode= @my_sql_mode;