Debian Codegraph @

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

raw
1 --source include/have_ndb.inc
2 --source suite/ndb_rpl/ndb_master-slave.inc
3
4 #
5 # Test add column
6 #
7 --connection master
8 CREATE TABLE t1 (c1 INT KEY) ROW_FORMAT=DYNAMIC ENGINE=NDB;
9
10 INSERT INTO t1 VALUES (1),(2),(3);
11
12 ALTER TABLE t1 ADD c2 INT;
13
14 --sync_slave_with_master
15 connection slave;
16 SELECT * FROM t1 ORDER BY c1;
17
18 connection master;
19
20 INSERT INTO t1 VALUES (6,6),(7,7),(8,8);
21 SELECT * FROM t1 ORDER BY c1;
22
23 --sync_slave_with_master
24 connection slave;
25 SELECT * FROM t1 ORDER BY c1;
26
27 #
28 # Test online alter table for various types
29 #
30 connection master;
31 ALTER TABLE t1 algorithm=inplace, ADD c CHAR(19);
32 INSERT INTO t1 values (11,1,"a");
33 ALTER TABLE t1 algorithm=inplace, ADD d FLOAT;
34 INSERT INTO t1 VALUES(12, 2,'b', -3.402823466E+38);
35 #FOR BUG#32095 SO COMMNET THE DOUBLE TYPE DATA.
36 # ALTER TABLE t1 algorithm=inplace, ADD e DOUBLE UNSIGNED;
37 # INSERT INTO t1 VALUES(13, 3,'c', -3.402823466E+38, 1.7976931348623157E+308);
38 ALTER TABLE t1 algorithm=inplace, ADD f DECIMAL(5,2);
39 INSERT INTO t1 VALUES(14, 4,'d', -3.402823466E+38, 456.78);
40 ALTER TABLE t1 algorithm=inplace, ADD g DATETIME;
41 INSERT INTO t1 VALUES(15, 5,'e', -3.402823466E+38, 456.78, '2007-10-26 12:00:00');
42 ALTER TABLE t1 algorithm=inplace, ADD h BINARY(4);
43 INSERT INTO t1 VALUES(16, 6,'f', -3.402823466E+38, 456.78, '2007-10-26 12:00:00',"abcd");
44 --echo **********************
45 --echo "Master data"
46 --echo **********************
47 SELECT * FROM t1 ORDER BY c1;
48 --sync_slave_with_master
49 connection slave;
50 --echo **********************
51 --echo "Slave data"
52 --echo **********************
53 SELECT * FROM t1 ORDER BY c1;
54
55 #
56 # Update the new added column
57 #
58 connection master;
59 UPDATE t1 SET c = "abcdef", d = 3.402823466E+38, f = 987.65, g = '2007-10-22 22:22:22', h = "aaaa";
60 --echo ***************************
61 --echo "Master Data After Update"
62 --echo ***************************
63 SELECT * FROM t1 ORDER BY c1;
64 --sync_slave_with_master
65 connection slave;
66 --echo *************************
67 --echo "Slave Data After Update"
68 --echo *************************
69 SELECT * FROM t1 ORDER BY c1;
70
71 connection master;
72 DROP TABLE t1;
73
74 --echo *************************************************
75 --echo * Insert And Update New Added Columns With Commit
76 --echo *************************************************
77 connection master;
78 CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=DYNAMIC ENGINE NDB;
79 INSERT INTO t1 VALUES(1,1),(2,2);
80 BEGIN;
81 ALTER TABLE t1 algorithm=inplace, ADD c CHAR(19), ADD d VARCHAR(255), ADD e char(255);
82 INSERT INTO t1 VALUES (3,0,'3','3','3'),(4,0,'4','4','4'),(5,0,null,null,null);
83 UPDATE t1 SET c = 'aaa', d = 'bbb', e = 'ccc' WHERE a = 4;
84 COMMIT;
85 SELECT * FROM t1 ORDER BY a;
86 --sync_slave_with_master
87 connection slave;
88 --echo *************************
89 --echo "Slave Data With Commit
90 --echo *************************
91 SELECT * FROM t1 ORDER BY a;
92
93 --echo ***************************************************
94 --echo * Insert And Update New Added Columns With Rollback
95 --echo ***************************************************
96 connection master;
97 DROP TABLE t1;
98 CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=DYNAMIC ENGINE NDB;
99 INSERT INTO t1 VALUES(1,1),(2,2);
100 ALTER TABLE t1 ADD c CHAR(19), ADD d VARCHAR(255), ADD e char(255);
101 BEGIN;
102 INSERT INTO t1 VALUES (3,0,'3','3','3'),(4,0,'4','4','4'),(5,0,null,null,null);
103 UPDATE t1 SET c = 'aaa', d = 'bbb', e = 'ccc' WHERE a = 4;
104 ROLLBACK;
105 --disable_warnings
106 SHOW CREATE TABLE t1;
107 --enable_warnings
108 SELECT * FROM t1 ORDER BY a;
109 --sync_slave_with_master
110 connection slave;
111 --echo *************************
112 --echo "Slave Data With Rollback
113 --echo *************************
114 --disable_warnings
115 SHOW CREATE TABLE t1;
116 --enable_warnings
117 SELECT * FROM t1 ORDER BY a;
118
119 # cleanup
120 --connection master
121 DROP TABLE t1;
122 -- source include/rpl_end.inc