333
335
connection master;
334
336
DELETE FROM t2 WHERE a = -2;
335
337
--echo *** slave must stop
336
source include/wait_for_slave_sql_to_stop.inc;
340
let $last_error = query_get_value("SHOW SLAVE STATUS", Last_SQL_Errno, 1);
342
eval SELECT "$last_error" AS Last_SQL_Error;
345
set global slave_exec_mode='IDEMPOTENT';
346
start slave sql_thread;
348
sync_slave_with_master;
350
set global slave_exec_mode='STRICT';
352
UPDATE t1 SET a = 1 WHERE a = -1;
353
UPDATE t2 SET a = 1 WHERE a = -1;
356
UPDATE t1 SET a = 1 WHERE a = -1;
358
--echo *** slave must stop
359
source include/wait_for_slave_sql_to_stop.inc;
363
let $last_error = query_get_value("SHOW SLAVE STATUS", Last_SQL_Errno, 1);
365
eval SELECT "$last_error" AS Last_SQL_Error;
368
set global slave_exec_mode='IDEMPOTENT';
369
start slave sql_thread;
371
sync_slave_with_master;
373
set global slave_exec_mode='STRICT';
377
UPDATE t2 SET a = 1 WHERE a = -1;
379
--echo *** slave must stop
380
source include/wait_for_slave_sql_to_stop.inc;
384
let $last_error = query_get_value("SHOW SLAVE STATUS", Last_SQL_Errno, 1);
386
eval SELECT "$last_error" AS Last_SQL_Error;
389
set global slave_exec_mode='IDEMPOTENT';
390
start slave sql_thread;
392
sync_slave_with_master;
394
set global slave_exec_mode='STRICT';
339
source include/wait_for_slave_sql_to_stop.inc;
341
let $last_error = query_get_value("SHOW SLAVE STATUS", Last_SQL_Errno, 1);
343
eval SELECT "$last_error" AS Last_SQL_Error;
346
set global slave_exec_mode='IDEMPOTENT';
347
start slave sql_thread;
349
sync_slave_with_master;
351
set global slave_exec_mode='STRICT';
353
UPDATE t1 SET a = 1 WHERE a = -1;
354
UPDATE t2 SET a = 1 WHERE a = -1;
357
UPDATE t1 SET a = 1 WHERE a = -1;
359
--echo *** slave must stop
361
source include/wait_for_slave_sql_to_stop.inc;
363
let $last_error = query_get_value("SHOW SLAVE STATUS", Last_SQL_Errno, 1);
365
eval SELECT "$last_error" AS Last_SQL_Error;
368
set global slave_exec_mode='IDEMPOTENT';
369
start slave sql_thread;
371
sync_slave_with_master;
373
set global slave_exec_mode='STRICT';
377
UPDATE t2 SET a = 1 WHERE a = -1;
379
--echo *** slave must stop
381
source include/wait_for_slave_sql_to_stop.inc;
383
let $last_error = query_get_value("SHOW SLAVE STATUS", Last_SQL_Errno, 1);
385
eval SELECT "$last_error" AS Last_SQL_Error;
388
set global slave_exec_mode='IDEMPOTENT';
389
start slave sql_thread;
391
sync_slave_with_master;
393
SET @@global.slave_exec_mode= @old_slave_exec_mode;
397
395
# cleanup for bug#31609 tests