Debian Codegraph @

mysql-test/suite/ndb_rpl/t/ndb_rpl_set_null.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 # InnoDB
6 CREATE TABLE t1_innodb (b1 BIT, b2 BIT);
7 # 1 high bit per column
8 CREATE TABLE t1_ndb (c1 BIT, c2 BIT) ENGINE = NDB;
9 # d1 = 2 high bits, d2 = 1 high bit, d3 = 1 high bit
10 CREATE TABLE t2 (d1 BIT(2), d2 BIT, d3 BIT) ENGINE = NDB;
11 # PK and 1 high bit per column
12 CREATE TABLE t3 (a INT PRIMARY KEY, e1 BIT, e2 BIT) ENGINE = NDB;
13 # Only 1 high bit per NOT NULL, null bit and high bit for the rest
14 CREATE TABLE t4 (f1 BIT, f2 BIT NOT NULL, f3 BIT NOT NULL, f4 BIT NOT NULL, f5 BIT) ENGINE = NDB;
15 # PK, 1 null and 6 high bits (full null flag byte)
16 CREATE TABLE t5 (a INT PRIMARY KEY, g1 BIT(6)) ENGINE = NDB;
17
18 # Insert data
19 INSERT INTO t1_innodb VALUES (1, 1);
20 INSERT INTO t1_ndb VALUES (1, 1);
21 INSERT INTO t2 VALUES (3, 1, 1);
22 INSERT INTO t3 VALUES (1, 1, 1);
23 INSERT INTO t4 VALUES (1, 1, 1, 1, 1);
24 INSERT INTO t5 VALUES (1, 63);
25
26 --source include/sync_slave_sql_with_master.inc
27
28 --source include/rpl_connection_master.inc
29 UPDATE t1_innodb SET b1 = NULL WHERE b2 = 1;
30 UPDATE t1_ndb SET c1 = NULL WHERE c2 = 1;
31 UPDATE t2 SET d1 = NULL WHERE d3 = 1;
32 UPDATE t3 SET e1 = NULL WHERE a = 1;
33 UPDATE t4 SET f1 = NULL, f5 = NULL WHERE f2 = 1;
34 UPDATE t5 SET g1 = NULL WHERE a = 1;
35
36 --source include/sync_slave_sql_with_master.inc
37
38 SELECT * FROM t1_ndb;
39 SELECT * FROM t1_innodb;
40 SELECT * FROM t2;
41 SELECT * FROM t3;
42 SELECT * FROM t4;
43 SELECT * FROM t5;
44
45 --source include/rpl_connection_master.inc
46 DELETE FROM t1_innodb WHERE b2 = 1 LIMIT 1;
47 --source include/sync_slave_sql_with_master.inc
48 SELECT * FROM t1_innodb;
49
50 --source include/rpl_connection_master.inc
51 DELETE FROM t1_ndb WHERE c2 = 1 LIMIT 1;
52 --source include/sync_slave_sql_with_master.inc
53 SELECT * FROM t1_ndb;
54
55 --source include/rpl_connection_master.inc
56 DELETE FROM t2 WHERE d2 = 1 LIMIT 1;
57 --source include/sync_slave_sql_with_master.inc
58 SELECT * FROM t2;
59
60 --source include/rpl_connection_master.inc
61 DELETE FROM t3 WHERE a = 1 LIMIT 1;
62 --source include/sync_slave_sql_with_master.inc
63 SELECT * FROM t3;
64
65 --source include/rpl_connection_master.inc
66 DELETE FROM t4 WHERE f2 = 1 LIMIT 1;
67 --source include/sync_slave_sql_with_master.inc
68 SELECT * FROM t4;
69
70 --source include/rpl_connection_master.inc
71 DELETE FROM t5 WHERE a = 1 LIMIT 1;
72 --source include/sync_slave_sql_with_master.inc
73 SELECT * FROM t5;
74
75 --source include/rpl_connection_master.inc
76 DROP TABLE t1_innodb;
77 DROP TABLE t1_ndb;
78 DROP TABLE t2;
79 DROP TABLE t3;
80 DROP TABLE t4;
81 DROP TABLE t5;
82
83 --echo Cleanup
84 --source include/rpl_end.inc