Debian Codegraph @

mysql-test/suite/ndb_rpl/r/replica_purge.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 (
7 a INT PRIMARY KEY
8 ) engine=ndb;
9 INSERT INTO t1 (a) VALUES (0);
10 ALTER TABLE t1 ADD COLUMN c0 INT COLUMN_FORMAT DYNAMIC;
11 INSERT INTO t1 (a) VALUES (1);
12 ALTER TABLE t1 ADD COLUMN c1 INT COLUMN_FORMAT DYNAMIC;
13 INSERT INTO t1 (a) VALUES (2);
14 ALTER TABLE t1 ADD COLUMN c2 INT COLUMN_FORMAT DYNAMIC;
15 INSERT INTO t1 (a) VALUES (3);
16 ALTER TABLE t1 ADD COLUMN c3 INT COLUMN_FORMAT DYNAMIC;
17 INSERT INTO t1 (a) VALUES (4);
18 ALTER TABLE t1 ADD COLUMN c4 INT COLUMN_FORMAT DYNAMIC;
19 INSERT INTO t1 (a) VALUES (5);
20 ALTER TABLE t1 ADD COLUMN c5 INT COLUMN_FORMAT DYNAMIC;
21 INSERT INTO t1 (a) VALUES (6);
22 ALTER TABLE t1 ADD COLUMN c6 INT COLUMN_FORMAT DYNAMIC;
23 INSERT INTO t1 (a) VALUES (7);
24 ALTER TABLE t1 ADD COLUMN c7 INT COLUMN_FORMAT DYNAMIC;
25 INSERT INTO t1 (a) VALUES (8);
26 ALTER TABLE t1 ADD COLUMN c8 INT COLUMN_FORMAT DYNAMIC;
27 INSERT INTO t1 (a) VALUES (9);
28 ALTER TABLE t1 ADD COLUMN c9 INT COLUMN_FORMAT DYNAMIC;
29 INSERT INTO t1 (a) VALUES (10);
30 ALTER TABLE t1 ADD COLUMN c10 INT COLUMN_FORMAT DYNAMIC;
31 INSERT INTO t1 (a) VALUES (11);
32 ALTER TABLE t1 ADD COLUMN c11 INT COLUMN_FORMAT DYNAMIC;
33 INSERT INTO t1 (a) VALUES (12);
34 ALTER TABLE t1 ADD COLUMN c12 INT COLUMN_FORMAT DYNAMIC;
35 INSERT INTO t1 (a) VALUES (13);
36 ALTER TABLE t1 ADD COLUMN c13 INT COLUMN_FORMAT DYNAMIC;
37 INSERT INTO t1 (a) VALUES (14);
38 ALTER TABLE t1 ADD COLUMN c14 INT COLUMN_FORMAT DYNAMIC;
39 INSERT INTO t1 (a) VALUES (15);
40 ALTER TABLE t1 ADD COLUMN c15 INT COLUMN_FORMAT DYNAMIC;
41 INSERT INTO t1 (a) VALUES (16);
42 ALTER TABLE t1 ADD COLUMN c16 INT COLUMN_FORMAT DYNAMIC;
43 INSERT INTO t1 (a) VALUES (17);
44 ALTER TABLE t1 ADD COLUMN c17 INT COLUMN_FORMAT DYNAMIC;
45 INSERT INTO t1 (a) VALUES (18);
46 ALTER TABLE t1 ADD COLUMN c18 INT COLUMN_FORMAT DYNAMIC;
47 INSERT INTO t1 (a) VALUES (19);
48 ALTER TABLE t1 ADD COLUMN c19 INT COLUMN_FORMAT DYNAMIC;
49 INSERT INTO t1 (a) VALUES (20);
50 ALTER TABLE t1 ADD COLUMN c20 INT COLUMN_FORMAT DYNAMIC;
51 INSERT INTO t1 (a) VALUES (21);
52 ALTER TABLE t1 ADD COLUMN c21 INT COLUMN_FORMAT DYNAMIC;
53 INSERT INTO t1 (a) VALUES (22);
54 ALTER TABLE t1 ADD COLUMN c22 INT COLUMN_FORMAT DYNAMIC;
55 INSERT INTO t1 (a) VALUES (23);
56 ALTER TABLE t1 ADD COLUMN c23 INT COLUMN_FORMAT DYNAMIC;
57 INSERT INTO t1 (a) VALUES (24);
58 ALTER TABLE t1 ADD COLUMN c24 INT COLUMN_FORMAT DYNAMIC;
59 INSERT INTO t1 (a) VALUES (25);
60 ALTER TABLE t1 ADD COLUMN c25 INT COLUMN_FORMAT DYNAMIC;
61 INSERT INTO t1 (a) VALUES (26);
62 ALTER TABLE t1 ADD COLUMN c26 INT COLUMN_FORMAT DYNAMIC;
63 INSERT INTO t1 (a) VALUES (27);
64 ALTER TABLE t1 ADD COLUMN c27 INT COLUMN_FORMAT DYNAMIC;
65 INSERT INTO t1 (a) VALUES (28);
66 ALTER TABLE t1 ADD COLUMN c28 INT COLUMN_FORMAT DYNAMIC;
67 INSERT INTO t1 (a) VALUES (29);
68 ALTER TABLE t1 ADD COLUMN c29 INT COLUMN_FORMAT DYNAMIC;
69 INSERT INTO t1 (a) VALUES (30);
70 ALTER TABLE t1 ADD COLUMN c30 INT COLUMN_FORMAT DYNAMIC;
71 INSERT INTO t1 (a) VALUES (31);
72 ALTER TABLE t1 ADD COLUMN c31 INT COLUMN_FORMAT DYNAMIC;
73 INSERT INTO t1 (a) VALUES (32);
74 ALTER TABLE t1 ADD COLUMN c32 INT COLUMN_FORMAT DYNAMIC;
75 INSERT INTO t1 (a) VALUES (33);
76 ALTER TABLE t1 ADD COLUMN c33 INT COLUMN_FORMAT DYNAMIC;
77 INSERT INTO t1 (a) VALUES (34);
78 ALTER TABLE t1 ADD COLUMN c34 INT COLUMN_FORMAT DYNAMIC;
79 INSERT INTO t1 (a) VALUES (35);
80 ALTER TABLE t1 ADD COLUMN c35 INT COLUMN_FORMAT DYNAMIC;
81 INSERT INTO t1 (a) VALUES (36);
82 ALTER TABLE t1 ADD COLUMN c36 INT COLUMN_FORMAT DYNAMIC;
83 INSERT INTO t1 (a) VALUES (37);
84 ALTER TABLE t1 ADD COLUMN c37 INT COLUMN_FORMAT DYNAMIC;
85 INSERT INTO t1 (a) VALUES (38);
86 ALTER TABLE t1 ADD COLUMN c38 INT COLUMN_FORMAT DYNAMIC;
87 INSERT INTO t1 (a) VALUES (39);
88 ALTER TABLE t1 ADD COLUMN c39 INT COLUMN_FORMAT DYNAMIC;
89 INSERT INTO t1 (a) VALUES (40);
90 ALTER TABLE t1 ADD COLUMN c40 INT COLUMN_FORMAT DYNAMIC;
91 INSERT INTO t1 (a) VALUES (41);
92 ALTER TABLE t1 ADD COLUMN c41 INT COLUMN_FORMAT DYNAMIC;
93 INSERT INTO t1 (a) VALUES (42);
94 ALTER TABLE t1 ADD COLUMN c42 INT COLUMN_FORMAT DYNAMIC;
95 INSERT INTO t1 (a) VALUES (43);
96 ALTER TABLE t1 ADD COLUMN c43 INT COLUMN_FORMAT DYNAMIC;
97 INSERT INTO t1 (a) VALUES (44);
98 ALTER TABLE t1 ADD COLUMN c44 INT COLUMN_FORMAT DYNAMIC;
99 INSERT INTO t1 (a) VALUES (45);
100 ALTER TABLE t1 ADD COLUMN c45 INT COLUMN_FORMAT DYNAMIC;
101 INSERT INTO t1 (a) VALUES (46);
102 ALTER TABLE t1 ADD COLUMN c46 INT COLUMN_FORMAT DYNAMIC;
103 INSERT INTO t1 (a) VALUES (47);
104 ALTER TABLE t1 ADD COLUMN c47 INT COLUMN_FORMAT DYNAMIC;
105 INSERT INTO t1 (a) VALUES (48);
106 ALTER TABLE t1 ADD COLUMN c48 INT COLUMN_FORMAT DYNAMIC;
107 INSERT INTO t1 (a) VALUES (49);
108 ALTER TABLE t1 ADD COLUMN c49 INT COLUMN_FORMAT DYNAMIC;
109 INSERT INTO t1 (a) VALUES (50);
110 ALTER TABLE t1 ADD COLUMN c50 INT COLUMN_FORMAT DYNAMIC;
111 INSERT INTO t1 (a) VALUES (51);
112 ALTER TABLE t1 ADD COLUMN c51 INT COLUMN_FORMAT DYNAMIC;
113 INSERT INTO t1 (a) VALUES (52);
114 ALTER TABLE t1 ADD COLUMN c52 INT COLUMN_FORMAT DYNAMIC;
115 INSERT INTO t1 (a) VALUES (53);
116 ALTER TABLE t1 ADD COLUMN c53 INT COLUMN_FORMAT DYNAMIC;
117 INSERT INTO t1 (a) VALUES (54);
118 ALTER TABLE t1 ADD COLUMN c54 INT COLUMN_FORMAT DYNAMIC;
119 INSERT INTO t1 (a) VALUES (55);
120 ALTER TABLE t1 ADD COLUMN c55 INT COLUMN_FORMAT DYNAMIC;
121 INSERT INTO t1 (a) VALUES (56);
122 ALTER TABLE t1 ADD COLUMN c56 INT COLUMN_FORMAT DYNAMIC;
123 INSERT INTO t1 (a) VALUES (57);
124 ALTER TABLE t1 ADD COLUMN c57 INT COLUMN_FORMAT DYNAMIC;
125 INSERT INTO t1 (a) VALUES (58);
126 ALTER TABLE t1 ADD COLUMN c58 INT COLUMN_FORMAT DYNAMIC;
127 INSERT INTO t1 (a) VALUES (59);
128 ALTER TABLE t1 ADD COLUMN c59 INT COLUMN_FORMAT DYNAMIC;
129 INSERT INTO t1 (a) VALUES (60);
130 ALTER TABLE t1 ADD COLUMN c60 INT COLUMN_FORMAT DYNAMIC;
131 INSERT INTO t1 (a) VALUES (61);
132 ALTER TABLE t1 ADD COLUMN c61 INT COLUMN_FORMAT DYNAMIC;
133 INSERT INTO t1 (a) VALUES (62);
134 ALTER TABLE t1 ADD COLUMN c62 INT COLUMN_FORMAT DYNAMIC;
135 INSERT INTO t1 (a) VALUES (63);
136 ALTER TABLE t1 ADD COLUMN c63 INT COLUMN_FORMAT DYNAMIC;
137 INSERT INTO t1 (a) VALUES (64);
138 ALTER TABLE t1 ADD COLUMN c64 INT COLUMN_FORMAT DYNAMIC;
139 INSERT INTO t1 (a) VALUES (65);
140 ALTER TABLE t1 ADD COLUMN c65 INT COLUMN_FORMAT DYNAMIC;
141 INSERT INTO t1 (a) VALUES (66);
142 ALTER TABLE t1 ADD COLUMN c66 INT COLUMN_FORMAT DYNAMIC;
143 INSERT INTO t1 (a) VALUES (67);
144 ALTER TABLE t1 ADD COLUMN c67 INT COLUMN_FORMAT DYNAMIC;
145 INSERT INTO t1 (a) VALUES (68);
146 ALTER TABLE t1 ADD COLUMN c68 INT COLUMN_FORMAT DYNAMIC;
147 INSERT INTO t1 (a) VALUES (69);
148 ALTER TABLE t1 ADD COLUMN c69 INT COLUMN_FORMAT DYNAMIC;
149 INSERT INTO t1 (a) VALUES (70);
150 ALTER TABLE t1 ADD COLUMN c70 INT COLUMN_FORMAT DYNAMIC;
151 INSERT INTO t1 (a) VALUES (71);
152 ALTER TABLE t1 ADD COLUMN c71 INT COLUMN_FORMAT DYNAMIC;
153 INSERT INTO t1 (a) VALUES (72);
154 ALTER TABLE t1 ADD COLUMN c72 INT COLUMN_FORMAT DYNAMIC;
155 INSERT INTO t1 (a) VALUES (73);
156 ALTER TABLE t1 ADD COLUMN c73 INT COLUMN_FORMAT DYNAMIC;
157 INSERT INTO t1 (a) VALUES (74);
158 ALTER TABLE t1 ADD COLUMN c74 INT COLUMN_FORMAT DYNAMIC;
159 INSERT INTO t1 (a) VALUES (75);
160 ALTER TABLE t1 ADD COLUMN c75 INT COLUMN_FORMAT DYNAMIC;
161 INSERT INTO t1 (a) VALUES (76);
162 ALTER TABLE t1 ADD COLUMN c76 INT COLUMN_FORMAT DYNAMIC;
163 INSERT INTO t1 (a) VALUES (77);
164 ALTER TABLE t1 ADD COLUMN c77 INT COLUMN_FORMAT DYNAMIC;
165 INSERT INTO t1 (a) VALUES (78);
166 ALTER TABLE t1 ADD COLUMN c78 INT COLUMN_FORMAT DYNAMIC;
167 INSERT INTO t1 (a) VALUES (79);
168 ALTER TABLE t1 ADD COLUMN c79 INT COLUMN_FORMAT DYNAMIC;
169 INSERT INTO t1 (a) VALUES (80);
170 ALTER TABLE t1 ADD COLUMN c80 INT COLUMN_FORMAT DYNAMIC;
171 INSERT INTO t1 (a) VALUES (81);
172 ALTER TABLE t1 ADD COLUMN c81 INT COLUMN_FORMAT DYNAMIC;
173 INSERT INTO t1 (a) VALUES (82);
174 ALTER TABLE t1 ADD COLUMN c82 INT COLUMN_FORMAT DYNAMIC;
175 INSERT INTO t1 (a) VALUES (83);
176 ALTER TABLE t1 ADD COLUMN c83 INT COLUMN_FORMAT DYNAMIC;
177 INSERT INTO t1 (a) VALUES (84);
178 ALTER TABLE t1 ADD COLUMN c84 INT COLUMN_FORMAT DYNAMIC;
179 INSERT INTO t1 (a) VALUES (85);
180 ALTER TABLE t1 ADD COLUMN c85 INT COLUMN_FORMAT DYNAMIC;
181 INSERT INTO t1 (a) VALUES (86);
182 ALTER TABLE t1 ADD COLUMN c86 INT COLUMN_FORMAT DYNAMIC;
183 INSERT INTO t1 (a) VALUES (87);
184 ALTER TABLE t1 ADD COLUMN c87 INT COLUMN_FORMAT DYNAMIC;
185 INSERT INTO t1 (a) VALUES (88);
186 ALTER TABLE t1 ADD COLUMN c88 INT COLUMN_FORMAT DYNAMIC;
187 INSERT INTO t1 (a) VALUES (89);
188 ALTER TABLE t1 ADD COLUMN c89 INT COLUMN_FORMAT DYNAMIC;
189 INSERT INTO t1 (a) VALUES (90);
190 ALTER TABLE t1 ADD COLUMN c90 INT COLUMN_FORMAT DYNAMIC;
191 INSERT INTO t1 (a) VALUES (91);
192 ALTER TABLE t1 ADD COLUMN c91 INT COLUMN_FORMAT DYNAMIC;
193 INSERT INTO t1 (a) VALUES (92);
194 ALTER TABLE t1 ADD COLUMN c92 INT COLUMN_FORMAT DYNAMIC;
195 INSERT INTO t1 (a) VALUES (93);
196 ALTER TABLE t1 ADD COLUMN c93 INT COLUMN_FORMAT DYNAMIC;
197 INSERT INTO t1 (a) VALUES (94);
198 ALTER TABLE t1 ADD COLUMN c94 INT COLUMN_FORMAT DYNAMIC;
199 INSERT INTO t1 (a) VALUES (95);
200 ALTER TABLE t1 ADD COLUMN c95 INT COLUMN_FORMAT DYNAMIC;
201 INSERT INTO t1 (a) VALUES (96);
202 ALTER TABLE t1 ADD COLUMN c96 INT COLUMN_FORMAT DYNAMIC;
203 INSERT INTO t1 (a) VALUES (97);
204 ALTER TABLE t1 ADD COLUMN c97 INT COLUMN_FORMAT DYNAMIC;
205 INSERT INTO t1 (a) VALUES (98);
206 ALTER TABLE t1 ADD COLUMN c98 INT COLUMN_FORMAT DYNAMIC;
207 INSERT INTO t1 (a) VALUES (99);
208 ALTER TABLE t1 ADD COLUMN c99 INT COLUMN_FORMAT DYNAMIC;
209 include/sync_slave_sql_with_master.inc
210 # Show replica settings
211 # - small binlog, auto purge on and purge after one second
212 max_binlog_size: 4096
213 auto_purge: ON
214 expire_seconds: 1
215 # Check that there are no rows in ndb_binlog_index without
216 # corresponding binlog, this is in two steps by first building a
217 # table from the output of SHOW BINARY LOGS and then comparing
218 # that table with ndb_binlog_index
219 # 1. Build binlogs table from output of SHOW BINARY LOGS
220 CREATE TEMPORARY TABLE binlogs(
221 num INT PRIMARY KEY AUTO_INCREMENT,
222 name varchar(512) NOT NULL
223 );
224 # 2. Compare binlogs table with ndb_binlog_index to check
225 # that no orphan rows exist, the query should return no rows.
226 [connection master]
227 DROP TABLE t1;
228 include/sync_slave_sql_with_master.inc
229 include/rpl_end.inc