Debian Codegraph @

mysql-test/suite/ndb_big/ndb_big_lcp_drop.test

raw
1 -- source include/have_ndb.inc
2 -- source include/have_ndb_debug.inc
3
4 -- disable_warnings
5 drop table if exists t1,t2,t3;
6 -- enable_warnings
7
8 create table t1 (
9 a int not null primary key,
10 b int not null,
11 c char(255)
12 ) engine ndb;
13
14 create table t2 (
15 a int not null primary key,
16 b int not null) engine ndb;
17
18 create table t3 (
19 a int not null primary key,
20 b int not null) engine ndb;
21
22 insert into t1 values (1,1,'1'),(2,2,'2'),(3,3,'3'),(4,4,'4');
23 insert into t1 select a+4,b,c from t1;
24 insert into t1 select a+8,b,c from t1;
25 insert into t1 select a+16,b,c from t1;
26 insert into t1 select a+32,b,c from t1;
27 insert into t1 select a+64,b,c from t1;
28 insert into t1 select a+128,b,c from t1;
29 insert into t1 select a+256,b,c from t1;
30 insert into t1 select a+512,b,c from t1;
31 insert into t1 select a+1024,b,c from t1;
32 insert into t1 select a+2048,b,c from t1;
33 insert into t1 select a+4096,b,c from t1;
34 insert into t1 select a+8192,b,c from t1;
35 insert into t1 select a+16384,b,c from t1;
36 insert into t1 select a+32768,b,c from t1;
37 insert into t2 values (1,1),(2,2),(3,3),(4,4);
38 insert into t3 values (1,1),(2,2),(3,3),(4,4);
39
40 --exec $NDB_MGM -e "1 ERROR 7248" >> $NDB_TOOLS_OUTPUT
41 --exec $NDB_MGM -e "1 ERROR 6223" >> $NDB_TOOLS_OUTPUT
42 --exec $NDB_DROP_TABLE --database test t2 >> $NDB_TOOLS_OUTPUT
43 # Start cluster node again
44 # Wait for all nodes to enter "started"
45 --exec $NDB_WAITER --wait-nodes=1 >> $NDB_TOOLS_OUTPUT
46
47
48 --exec $NDB_MGM -e "3 ERROR 7248" >> $NDB_TOOLS_OUTPUT
49 --exec $NDB_MGM -e "3 ERROR 6223" >> $NDB_TOOLS_OUTPUT
50 --exec $NDB_DROP_TABLE --database test t3 >> $NDB_TOOLS_OUTPUT
51 # Start cluster node again
52 # Wait for all nodes to enter "started"
53 --exec $NDB_WAITER --wait-nodes=3 >> $NDB_TOOLS_OUTPUT
54
55 -- disable_warnings
56 drop table t1, t2, t3;
57 -- enable_warnings
58 --remove_file $NDB_TOOLS_OUTPUT