Debian Codegraph @

mysql-test/suite/rpl/r/rpl_memory_engine_truncate_on_restart.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 create table t (val int) engine=MEMORY;
5 # DELETE trigger should never be activated
6 create trigger tr after delete on t for each row update t2 set val = 1;
7 insert into t values (1),(2);
8 include/save_master_gtid.inc
9 connection slave;
10 include/sync_with_master_gtid.inc
11 # Check pre-restart values
12 include/diff_tables.inc [master:test.t,slave:test.t]
13 # Restarting master should empty master and slave `t`
14 connection master;
15 include/rpl_restart_server.inc [server_number=1]
16 connection master;
17 # Validating MEMORY table on master is empty after restart
18 # MYSQL_BINLOG datadir/binlog_file --result-file=assert_file
19 include/assert_grep.inc [Query to truncate the MEMORY table should be the contents of the new event]
20 # Ensuring slave MEMORY table is empty
21 connection master;
22 include/save_master_gtid.inc
23 connection slave;
24 include/sync_with_master_gtid.inc
25 include/diff_tables.inc [master:test.t,slave:test.t]
26 # Ensure new events replicate correctly
27 connection master;
28 insert into t values (3),(4);
29 include/save_master_gtid.inc
30 connection slave;
31 include/sync_with_master_gtid.inc
32 # Validate values on slave, after master restart, do not include those inserted previously
33 include/diff_tables.inc [master:test.t,slave:test.t]
34 #
35 # Cleanup
36 connection master;
37 drop table t;
38 include/rpl_end.inc
39 # End of rpl_memory_engine_truncate_on_restart.test