Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_set_null.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 CREATE TABLE t1_innodb (b1 BIT, b2 BIT);
7 CREATE TABLE t1_ndb (c1 BIT, c2 BIT) ENGINE = NDB;
8 CREATE TABLE t2 (d1 BIT(2), d2 BIT, d3 BIT) ENGINE = NDB;
9 CREATE TABLE t3 (a INT PRIMARY KEY, e1 BIT, e2 BIT) ENGINE = NDB;
10 CREATE TABLE t4 (f1 BIT, f2 BIT NOT NULL, f3 BIT NOT NULL, f4 BIT NOT NULL, f5 BIT) ENGINE = NDB;
11 CREATE TABLE t5 (a INT PRIMARY KEY, g1 BIT(6)) ENGINE = NDB;
12 INSERT INTO t1_innodb VALUES (1, 1);
13 INSERT INTO t1_ndb VALUES (1, 1);
14 INSERT INTO t2 VALUES (3, 1, 1);
15 INSERT INTO t3 VALUES (1, 1, 1);
16 INSERT INTO t4 VALUES (1, 1, 1, 1, 1);
17 INSERT INTO t5 VALUES (1, 63);
18 include/sync_slave_sql_with_master.inc
19 [connection master]
20 UPDATE t1_innodb SET b1 = NULL WHERE b2 = 1;
21 UPDATE t1_ndb SET c1 = NULL WHERE c2 = 1;
22 UPDATE t2 SET d1 = NULL WHERE d3 = 1;
23 UPDATE t3 SET e1 = NULL WHERE a = 1;
24 UPDATE t4 SET f1 = NULL, f5 = NULL WHERE f2 = 1;
25 UPDATE t5 SET g1 = NULL WHERE a = 1;
26 include/sync_slave_sql_with_master.inc
27 SELECT * FROM t1_ndb;
28 c1 c2
29 NULL 
30 SELECT * FROM t1_innodb;
31 b1 b2
32 NULL 
33 SELECT * FROM t2;
34 d1 d2 d3
35 NULL  
36 SELECT * FROM t3;
37 a e1 e2
38 1 NULL 
39 SELECT * FROM t4;
40 f1 f2 f3 f4 f5
41 NULL    NULL
42 SELECT * FROM t5;
43 a g1
44 1 NULL
45 [connection master]
46 DELETE FROM t1_innodb WHERE b2 = 1 LIMIT 1;
47 include/sync_slave_sql_with_master.inc
48 SELECT * FROM t1_innodb;
49 b1 b2
50 [connection master]
51 DELETE FROM t1_ndb WHERE c2 = 1 LIMIT 1;
52 include/sync_slave_sql_with_master.inc
53 SELECT * FROM t1_ndb;
54 c1 c2
55 [connection master]
56 DELETE FROM t2 WHERE d2 = 1 LIMIT 1;
57 include/sync_slave_sql_with_master.inc
58 SELECT * FROM t2;
59 d1 d2 d3
60 [connection master]
61 DELETE FROM t3 WHERE a = 1 LIMIT 1;
62 include/sync_slave_sql_with_master.inc
63 SELECT * FROM t3;
64 a e1 e2
65 [connection master]
66 DELETE FROM t4 WHERE f2 = 1 LIMIT 1;
67 include/sync_slave_sql_with_master.inc
68 SELECT * FROM t4;
69 f1 f2 f3 f4 f5
70 [connection master]
71 DELETE FROM t5 WHERE a = 1 LIMIT 1;
72 include/sync_slave_sql_with_master.inc
73 SELECT * FROM t5;
74 a g1
75 [connection master]
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 Cleanup
83 include/rpl_end.inc