Debian Codegraph @

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

raw
1 Backup restored
2 Restart server 1 to trigger schema synchronization
3 # restart
4 Restart server 2 to trigger schema synchronization
5 # restart
6 SHOW CREATE TABLE t1;
7 Table Create Table
8 t1 CREATE TABLE `t1` (
9 `a` int NOT NULL,
10 `b` varchar(30) DEFAULT NULL,
11 PRIMARY KEY (`a`)
12 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
13 SELECT * FROM t1;
14 a b
15 1 a
16 2 bb
17 3 ccc
18 ALTER TABLE t1 DROP COLUMN b;
19 INSERT INTO t1 values (4),(5);
20 SELECT * FROM t1;
21 a
22 1
23 2
24 3
25 4
26 5
27 DROP TABLE t1;
28 SHOW CREATE TABLE t1;
29 Table Create Table
30 t1 CREATE TABLE `t1` (
31 `a` int NOT NULL,
32 `b` varchar(30) DEFAULT NULL,
33 PRIMARY KEY (`a`)
34 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
35 SELECT * FROM t1;
36 a b
37 1 a
38 2 bb
39 3 ccc
40 ALTER TABLE t1 DROP COLUMN b;
41 INSERT INTO t1 values (4),(5);
42 SELECT * FROM t1;
43 a
44 1
45 2
46 3
47 4
48 5
49 DROP TABLE t1;
50 SET GLOBAL ndb_metadata_sync = true;
51 SELECT * FROM t1;
52 a b
53 1 a
54 2 bb
55 3 ccc
56 ALTER TABLE t1 DROP COLUMN b;
57 INSERT INTO t1 values (4),(5);
58 SELECT * FROM t1;
59 a
60 1
61 2
62 3
63 4
64 5
65 DROP TABLE t1;