Debian Codegraph @

mysql-test/suite/ndb/r/ndb_share.result

raw
1 show variables like 'log_bin';
2 Variable_name Value
3 log_bin ON
4 show variables like 'log_bin';
5 Variable_name Value
6 log_bin ON
7 show variables like 'log_bin';
8 Variable_name Value
9 log_bin OFF
10 show variables like 'log_bin';
11 Variable_name Value
12 log_bin OFF
13 create table t1 (a int) engine=ndbcluster;
14 drop table t1;
15 set global ndb_dbg_check_shares=1;
16 set global ndb_dbg_check_shares=1;
17 set global ndb_dbg_check_shares=1;
18 set global ndb_dbg_check_shares=1;
19 create table t1 (a int) engine=ndbcluster;
20 drop table t1;
21 set global ndb_dbg_check_shares=1;
22 set global ndb_dbg_check_shares=1;
23 set global ndb_dbg_check_shares=1;
24 set global ndb_dbg_check_shares=1;
25 create table t1 (a int) engine=ndbcluster;
26 rename table t1 to t2;
27 drop table t2;
28 set global ndb_dbg_check_shares=1;
29 set global ndb_dbg_check_shares=1;
30 set global ndb_dbg_check_shares=1;
31 set global ndb_dbg_check_shares=1;
32 create table t1 (a int) engine=ndbcluster;
33 rename table t1 to t2;
34 drop table t2;
35 set global ndb_dbg_check_shares=1;
36 set global ndb_dbg_check_shares=1;
37 set global ndb_dbg_check_shares=1;
38 set global ndb_dbg_check_shares=1;
39 create table t1 (a int) engine=ndbcluster;
40 alter table t1 algorithm=copy, add column b int default 77;
41 drop table t1;
42 set global ndb_dbg_check_shares=1;
43 set global ndb_dbg_check_shares=1;
44 set global ndb_dbg_check_shares=1;
45 set global ndb_dbg_check_shares=1;
46 create table t1 (a int) engine=ndbcluster;
47 alter table t1 algorithm=copy, add column b int default 77;
48 drop table t1;
49 set global ndb_dbg_check_shares=1;
50 set global ndb_dbg_check_shares=1;
51 set global ndb_dbg_check_shares=1;
52 set global ndb_dbg_check_shares=1;
53 create table t1 (a int primary key) engine=ndbcluster
54 partition by list(a) (partition p0 values in (0));
55 alter table t1 algorithm=copy, add partition (partition p1 values in (1));
56 drop table t1;
57 set global ndb_dbg_check_shares=1;
58 set global ndb_dbg_check_shares=1;
59 set global ndb_dbg_check_shares=1;
60 set global ndb_dbg_check_shares=1;
61 create table t1 (a int primary key) engine=ndbcluster
62 partition by list(a) (partition p0 values in (0));
63 alter table t1 algorithm=copy, add partition (partition p1 values in (1));
64 drop table t1;
65 set global ndb_dbg_check_shares=1;
66 set global ndb_dbg_check_shares=1;
67 set global ndb_dbg_check_shares=1;
68 set global ndb_dbg_check_shares=1;
69 create table t1 (a int primary key) engine=ndbcluster;
70 alter table t1 algorithm=inplace, add column b int column_format dynamic;
71 drop table t1;
72 set global ndb_dbg_check_shares=1;
73 set global ndb_dbg_check_shares=1;
74 set global ndb_dbg_check_shares=1;
75 set global ndb_dbg_check_shares=1;
76 create table t1 (a int primary key) engine=ndbcluster;
77 alter table t1 algorithm=copy, add column b int column_format dynamic;
78 drop table t1;
79 set global ndb_dbg_check_shares=1;
80 set global ndb_dbg_check_shares=1;
81 set global ndb_dbg_check_shares=1;
82 set global ndb_dbg_check_shares=1;
83 create table t1 (a int) engine=ndbcluster;
84 create table t2 (a int) engine=ndbcluster;
85 rename table t1 to tmp, t2 to t1, tmp to t2;
86 drop table t1, t2;
87 set global ndb_dbg_check_shares=1;
88 set global ndb_dbg_check_shares=1;
89 set global ndb_dbg_check_shares=1;
90 set global ndb_dbg_check_shares=1;
91 create table t1 (a int) engine=ndbcluster;
92 create table t2 (a int) engine=ndbcluster;
93 rename table t1 to tmp, t2 to t1, tmp to t2;
94 drop table t1, t2;
95 set global ndb_dbg_check_shares=1;
96 set global ndb_dbg_check_shares=1;
97 set global ndb_dbg_check_shares=1;
98 set global ndb_dbg_check_shares=1;
99 create table t1 (a int) engine=innodb;
100 create table t1 (a int) engine=innodb;
101 create table t1 (a int) engine = ndb;
102 Warnings:
103 Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
104 Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
105 drop table t1;
106 Warnings:
107 Warning 1296 Node <nodeid> 'Distribution of DROP TABLE 't1' failed'
108 Warning 1296 Node <nodeid> 'Distribution of DROP TABLE 't1' failed'
109 set global ndb_dbg_check_shares=1;
110 set global ndb_dbg_check_shares=1;
111 set global ndb_dbg_check_shares=1;
112 set global ndb_dbg_check_shares=1;
113 create table t1 (a int) engine = ndb;
114 Warnings:
115 Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
116 Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
117 drop table t1;
118 Warnings:
119 Warning 1296 Node <nodeid> 'Distribution of DROP TABLE 't1' failed'
120 Warning 1296 Node <nodeid> 'Distribution of DROP TABLE 't1' failed'
121 set global ndb_dbg_check_shares=1;
122 set global ndb_dbg_check_shares=1;
123 set global ndb_dbg_check_shares=1;
124 set global ndb_dbg_check_shares=1;
125 create table t1 (a int) engine = ndb;
126 Warnings:
127 Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
128 Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
129 drop table t1;
130 select * from t1 /* force discovery */;
131 a
132 drop table t1;
133 select * from t1 /* force discovery */;
134 a
135 drop table t1;
136 set global ndb_dbg_check_shares=1;
137 set global ndb_dbg_check_shares=1;
138 set global ndb_dbg_check_shares=1;
139 set global ndb_dbg_check_shares=1;
140 create table t1 (a int) engine=innodb;
141 create table t1 (a int) engine=innodb;
142 create table t1 (a int) engine = ndb;
143 Warnings:
144 Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
145 Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
146 alter table t1 algorithm=copy, add column b int column_format dynamic;
147 Warnings:
148 Warning 1296 Node <nodeid> 'Distribution of ALTER TABLE 't1' failed'
149 Warning 1296 Node <nodeid> 'Distribution of ALTER TABLE 't1' failed'
150 drop table t1;
151 select * from t1 /* force discovery */;
152 a b
153 drop table t1;
154 select * from t1 /* force discovery */;
155 a b
156 drop table t1;
157 set global ndb_dbg_check_shares=1;
158 set global ndb_dbg_check_shares=1;
159 set global ndb_dbg_check_shares=1;
160 set global ndb_dbg_check_shares=1;
161 create table t1 (a int) engine=innodb;
162 create table t1 (a int) engine=innodb;
163 create table t1 (a int primary key) engine = ndb;
164 Warnings:
165 Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
166 Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
167 alter table t1 algorithm=inplace, add column b int column_format dynamic;
168 Warnings:
169 Warning 1296 Node <nodeid> 'Distribution of ALTER TABLE 't1' failed'
170 Warning 1296 Node <nodeid> 'Distribution of ALTER TABLE 't1' failed'
171 drop table t1;
172 select * from t1 /* force discovery */;
173 a b
174 drop table t1;
175 select * from t1 /* force discovery */;
176 a b
177 drop table t1;
178 set global ndb_dbg_check_shares=1;
179 set global ndb_dbg_check_shares=1;
180 set global ndb_dbg_check_shares=1;
181 set global ndb_dbg_check_shares=1;
182 create table t1 (a int) engine=innodb;
183 create table t1 (a int) engine=innodb;
184 create table t1 (a int) engine = ndb;
185 Warnings:
186 Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
187 Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
188 rename table t1 to t2;
189 select * from t2 /* force discovery */;
190 a
191 select * from t2 /* force discovery */;
192 a
193 drop table t2;
194 set global ndb_dbg_check_shares=1;
195 set global ndb_dbg_check_shares=1;
196 set global ndb_dbg_check_shares=1;
197 set global ndb_dbg_check_shares=1;
198 drop table t1;
199 drop table t1;
200 set global ndb_dbg_check_shares=1;
201 set global ndb_dbg_check_shares=1;
202 set global ndb_dbg_check_shares=1;
203 set global ndb_dbg_check_shares=1;
204 create table if not exists t1 (a int) engine=ndbcluster;
205 create table if not exists t1 (a int) engine=ndbcluster;
206 create table if not exists t1 (a int) engine=ndbcluster;
207 create table if not exists t1 (a int) engine=ndbcluster;
208 drop table t1;
209 set global ndb_dbg_check_shares=1;
210 set global ndb_dbg_check_shares=1;
211 set global ndb_dbg_check_shares=1;
212 set global ndb_dbg_check_shares=1;
213 create table if not exists t1 (a int) engine=ndbcluster;
214 create table if not exists t1 (a int) engine=ndbcluster;
215 create table if not exists t1 (a int) engine=ndbcluster;
216 create table if not exists t1 (a int) engine=ndbcluster;
217 drop table t1;
218 set global ndb_dbg_check_shares=1;
219 set global ndb_dbg_check_shares=1;
220 set global ndb_dbg_check_shares=1;
221 set global ndb_dbg_check_shares=1;
222 create table if not exists t1 (a int) engine=ndbcluster;
223 create table if not exists t1 (a int) engine=ndbcluster;
224 create table if not exists t1 (a int) engine=ndbcluster;
225 create table if not exists t1 (a int) engine=ndbcluster;
226 drop table t1;
227 set global ndb_dbg_check_shares=1;
228 set global ndb_dbg_check_shares=1;
229 set global ndb_dbg_check_shares=1;
230 set global ndb_dbg_check_shares=1;
231 create table if not exists t1 (a int) engine=ndbcluster;
232 create table if not exists t1 (a int) engine=ndbcluster;
233 create table if not exists t1 (a int) engine=ndbcluster;
234 create table if not exists t1 (a int) engine=ndbcluster;
235 drop table t1;
236 set global ndb_dbg_check_shares=1;
237 set global ndb_dbg_check_shares=1;
238 set global ndb_dbg_check_shares=1;
239 set global ndb_dbg_check_shares=1;
240 create table if not exists t1 (a int) engine=ndbcluster;
241 create table if not exists t1 (a int) engine=ndbcluster;
242 create table if not exists t1 (a int) engine=ndbcluster;
243 create table if not exists t1 (a int) engine=ndbcluster;
244 drop table t1;
245 set global ndb_dbg_check_shares=1;
246 set global ndb_dbg_check_shares=1;
247 set global ndb_dbg_check_shares=1;
248 set global ndb_dbg_check_shares=1;
249 create table t1 (a int) engine=ndbcluster;
250 drop table if exists t1;
251 drop table if exists t1;
252 drop table if exists t1;
253 drop table if exists t1;
254 set global ndb_dbg_check_shares=1;
255 set global ndb_dbg_check_shares=1;
256 set global ndb_dbg_check_shares=1;
257 set global ndb_dbg_check_shares=1;
258 create table t1 (a int) engine=ndbcluster;
259 drop table if exists t1;
260 drop table if exists t1;
261 drop table if exists t1;
262 drop table if exists t1;
263 set global ndb_dbg_check_shares=1;
264 set global ndb_dbg_check_shares=1;
265 set global ndb_dbg_check_shares=1;
266 set global ndb_dbg_check_shares=1;
267 create table t1 (a int) engine=ndbcluster;
268 drop table if exists t1;
269 drop table if exists t1;
270 drop table if exists t1;
271 drop table if exists t1;
272 set global ndb_dbg_check_shares=1;
273 set global ndb_dbg_check_shares=1;
274 set global ndb_dbg_check_shares=1;
275 set global ndb_dbg_check_shares=1;
276 create table t1 (a int) engine=ndbcluster;
277 drop table if exists t1;
278 drop table if exists t1;
279 drop table if exists t1;
280 drop table if exists t1;
281 set global ndb_dbg_check_shares=1;
282 set global ndb_dbg_check_shares=1;
283 set global ndb_dbg_check_shares=1;
284 set global ndb_dbg_check_shares=1;
285 create table t1 (a int) engine=ndbcluster;
286 drop table if exists t1;
287 drop table if exists t1;
288 drop table if exists t1;
289 drop table if exists t1;
290 set global ndb_dbg_check_shares=1;
291 set global ndb_dbg_check_shares=1;
292 set global ndb_dbg_check_shares=1;
293 set global ndb_dbg_check_shares=1;
294 create table t1 (a int) engine=ndbcluster;
295 create table t2 (a int) engine=ndbcluster;
296 Node 1: NOT_STARTED
297 Node 2: NOT_STARTED
298 Node 1: STARTED
299 Node 2: STARTED
300 select * from t1 /* force discovery */;
301 a
302 select * from t2 /* force discovery */;
303 a
304 select * from t1 /* force discovery */;
305 a
306 select * from t2 /* force discovery */;
307 a
308 select * from t1 /* force discovery */;
309 a
310 select * from t2 /* force discovery */;
311 a
312 select * from t1 /* force discovery */;
313 a
314 select * from t2 /* force discovery */;
315 a
316 drop table t1, t2;
317 set global ndb_dbg_check_shares=1;
318 set global ndb_dbg_check_shares=1;
319 set global ndb_dbg_check_shares=1;
320 set global ndb_dbg_check_shares=1;
321 create table t1 (a int) engine=ndbcluster;
322 create table t2 (a int) engine=ndbcluster;
323 Node 1: NOT_STARTED
324 Node 2: NOT_STARTED
325 Node 1: STARTED
326 Node 2: STARTED
327 select * from t1 /* force discovery */;
328 ERROR 42S02: Table 'test.t1' doesn't exist
329 select * from t2 /* force discovery */;
330 ERROR 42S02: Table 'test.t2' doesn't exist
331 select * from t1 /* force discovery */;
332 ERROR 42S02: Table 'test.t1' doesn't exist
333 select * from t2 /* force discovery */;
334 ERROR 42S02: Table 'test.t2' doesn't exist
335 select * from t1 /* force discovery */;
336 ERROR 42S02: Table 'test.t1' doesn't exist
337 select * from t2 /* force discovery */;
338 ERROR 42S02: Table 'test.t2' doesn't exist
339 select * from t1 /* force discovery */;
340 ERROR 42S02: Table 'test.t1' doesn't exist
341 select * from t2 /* force discovery */;
342 ERROR 42S02: Table 'test.t2' doesn't exist
343 set global ndb_dbg_check_shares=1;
344 set global ndb_dbg_check_shares=1;
345 set global ndb_dbg_check_shares=1;
346 set global ndb_dbg_check_shares=1;