Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_add_column.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 (c1 INT KEY) ROW_FORMAT=DYNAMIC ENGINE=NDB;
7 INSERT INTO t1 VALUES (1),(2),(3);
8 ALTER TABLE t1 ADD c2 INT;
9 SELECT * FROM t1 ORDER BY c1;
10 c1 c2
11 1 NULL
12 2 NULL
13 3 NULL
14 INSERT INTO t1 VALUES (6,6),(7,7),(8,8);
15 SELECT * FROM t1 ORDER BY c1;
16 c1 c2
17 1 NULL
18 2 NULL
19 3 NULL
20 6 6
21 7 7
22 8 8
23 SELECT * FROM t1 ORDER BY c1;
24 c1 c2
25 1 NULL
26 2 NULL
27 3 NULL
28 6 6
29 7 7
30 8 8
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 ALTER TABLE t1 algorithm=inplace, ADD f DECIMAL(5,2);
36 INSERT INTO t1 VALUES(14, 4,'d', -3.402823466E+38, 456.78);
37 ALTER TABLE t1 algorithm=inplace, ADD g DATETIME;
38 INSERT INTO t1 VALUES(15, 5,'e', -3.402823466E+38, 456.78, '2007-10-26 12:00:00');
39 ALTER TABLE t1 algorithm=inplace, ADD h BINARY(4);
40 INSERT INTO t1 VALUES(16, 6,'f', -3.402823466E+38, 456.78, '2007-10-26 12:00:00',"abcd");
41 **********************
42 "Master data"
43 **********************
44 SELECT * FROM t1 ORDER BY c1;
45 c1 c2 c d f g h
46 1 NULL NULL NULL NULL NULL NULL
47 2 NULL NULL NULL NULL NULL NULL
48 3 NULL NULL NULL NULL NULL NULL
49 6 6 NULL NULL NULL NULL NULL
50 7 7 NULL NULL NULL NULL NULL
51 8 8 NULL NULL NULL NULL NULL
52 11 1 a NULL NULL NULL NULL
53 12 2 b -3.40282e38 NULL NULL NULL
54 14 4 d -3.40282e38 456.78 NULL NULL
55 15 5 e -3.40282e38 456.78 2007-10-26 12:00:00 NULL
56 16 6 f -3.40282e38 456.78 2007-10-26 12:00:00 abcd
57 **********************
58 "Slave data"
59 **********************
60 SELECT * FROM t1 ORDER BY c1;
61 c1 c2 c d f g h
62 1 NULL NULL NULL NULL NULL NULL
63 2 NULL NULL NULL NULL NULL NULL
64 3 NULL NULL NULL NULL NULL NULL
65 6 6 NULL NULL NULL NULL NULL
66 7 7 NULL NULL NULL NULL NULL
67 8 8 NULL NULL NULL NULL NULL
68 11 1 a NULL NULL NULL NULL
69 12 2 b -3.40282e38 NULL NULL NULL
70 14 4 d -3.40282e38 456.78 NULL NULL
71 15 5 e -3.40282e38 456.78 2007-10-26 12:00:00 NULL
72 16 6 f -3.40282e38 456.78 2007-10-26 12:00:00 abcd
73 UPDATE t1 SET c = "abcdef", d = 3.402823466E+38, f = 987.65, g = '2007-10-22 22:22:22', h = "aaaa";
74 ***************************
75 "Master Data After Update"
76 ***************************
77 SELECT * FROM t1 ORDER BY c1;
78 c1 c2 c d f g h
79 1 NULL abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
80 2 NULL abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
81 3 NULL abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
82 6 6 abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
83 7 7 abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
84 8 8 abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
85 11 1 abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
86 12 2 abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
87 14 4 abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
88 15 5 abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
89 16 6 abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
90 *************************
91 "Slave Data After Update"
92 *************************
93 SELECT * FROM t1 ORDER BY c1;
94 c1 c2 c d f g h
95 1 NULL abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
96 2 NULL abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
97 3 NULL abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
98 6 6 abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
99 7 7 abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
100 8 8 abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
101 11 1 abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
102 12 2 abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
103 14 4 abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
104 15 5 abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
105 16 6 abcdef 3.40282e38 987.65 2007-10-22 22:22:22 aaaa
106 DROP TABLE t1;
107 *************************************************
108 * Insert And Update New Added Columns With Commit
109 *************************************************
110 CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=DYNAMIC ENGINE NDB;
111 INSERT INTO t1 VALUES(1,1),(2,2);
112 BEGIN;
113 ALTER TABLE t1 algorithm=inplace, ADD c CHAR(19), ADD d VARCHAR(255), ADD e char(255);
114 INSERT INTO t1 VALUES (3,0,'3','3','3'),(4,0,'4','4','4'),(5,0,null,null,null);
115 UPDATE t1 SET c = 'aaa', d = 'bbb', e = 'ccc' WHERE a = 4;
116 COMMIT;
117 SELECT * FROM t1 ORDER BY a;
118 a b c d e
119 1 1 NULL NULL NULL
120 2 2 NULL NULL NULL
121 3 0 3 3 3
122 4 0 aaa bbb ccc
123 5 0 NULL NULL NULL
124 *************************
125 "Slave Data With Commit
126 *************************
127 SELECT * FROM t1 ORDER BY a;
128 a b c d e
129 1 1 NULL NULL NULL
130 2 2 NULL NULL NULL
131 3 0 3 3 3
132 4 0 aaa bbb ccc
133 5 0 NULL NULL NULL
134 ***************************************************
135 * Insert And Update New Added Columns With Rollback
136 ***************************************************
137 DROP TABLE t1;
138 CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=DYNAMIC ENGINE NDB;
139 INSERT INTO t1 VALUES(1,1),(2,2);
140 ALTER TABLE t1 ADD c CHAR(19), ADD d VARCHAR(255), ADD e char(255);
141 BEGIN;
142 INSERT INTO t1 VALUES (3,0,'3','3','3'),(4,0,'4','4','4'),(5,0,null,null,null);
143 UPDATE t1 SET c = 'aaa', d = 'bbb', e = 'ccc' WHERE a = 4;
144 ROLLBACK;
145 SHOW CREATE TABLE t1;
146 Table Create Table
147 t1 CREATE TABLE `t1` (
148 `a` int unsigned NOT NULL,
149 `b` int unsigned DEFAULT NULL,
150 `c` char(19) DEFAULT NULL,
151 `d` varchar(255) DEFAULT NULL,
152 `e` char(255) DEFAULT NULL,
153 PRIMARY KEY (`a`)
154 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
155 SELECT * FROM t1 ORDER BY a;
156 a b c d e
157 1 1 NULL NULL NULL
158 2 2 NULL NULL NULL
159 *************************
160 "Slave Data With Rollback
161 *************************
162 SHOW CREATE TABLE t1;
163 Table Create Table
164 t1 CREATE TABLE `t1` (
165 `a` int unsigned NOT NULL,
166 `b` int unsigned DEFAULT NULL,
167 `c` char(19) DEFAULT NULL,
168 `d` varchar(255) DEFAULT NULL,
169 `e` char(255) DEFAULT NULL,
170 PRIMARY KEY (`a`)
171 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
172 SELECT * FROM t1 ORDER BY a;
173 a b c d e
174 1 1 NULL NULL NULL
175 2 2 NULL NULL NULL
176 DROP TABLE t1;
177 include/rpl_end.inc