Debian Codegraph @

mysql-test/suite/ndb_rpl/t/ndb_rpl_empty_epoch.test

raw
1 --source include/have_ndb.inc
2 --source include/have_binlog_format_mixed_or_row.inc
3 --source suite/ndb_rpl/ndb_master-slave.inc
4
5 CREATE TABLE t1 (
6 id INT UNSIGNED NOT NULL AUTO_INCREMENT,
7 c1 VARCHAR(30),
8 PRIMARY KEY (id)
9 ) ENGINE=ndb;
10
11 BEGIN;
12 INSERT INTO t1 (c1) VALUES ('aaa'),('bbb'),('ccc');
13 DELETE FROM t1 WHERE id IN (1,2,3);
14 COMMIT;
15
16 --sleep 2
17
18 SELECT COUNT(epoch) > 0 FROM mysql.ndb_binlog_index;
19
20 CREATE TABLE t2 (
21 id INT UNSIGNED NOT NULL AUTO_INCREMENT,
22 c1 VARCHAR(30),
23 PRIMARY KEY (id)
24 ) ENGINE=ndb;
25
26 set @old_ndb_log_empty_epochs = @@global.ndb_log_empty_epochs;
27 set global ndb_log_empty_epochs = on;
28
29 BEGIN;
30 INSERT INTO t2 (c1) VALUES ('aaa'),('bbb'),('ccc');
31 DELETE FROM t2 WHERE id IN (1,2,3);
32 COMMIT;
33
34 --sleep 2
35
36 SELECT COUNT(epoch) > 0 FROM mysql.ndb_binlog_index;
37
38 set global ndb_log_empty_epochs = @old_ndb_log_empty_epochs;
39
40 --connection master
41 DROP TABLE IF EXISTS t1,t2;
42
43 --source include/rpl_end.inc