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