Debian Codegraph @

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

raw
1 # Stop MySQL server 1
2 # Stop MySQL server 2
3 # Restore 7.6 backup into NDB
4 # Setup the 7.6 data directory
5 # Copy zip files to tmp
6 # Check that the file exists in the working folder
7 # Unzip the contents
8 # Rename the extracted root directory for server2
9 # Unzip again for server1
10 # Test upgrade on 7.6 data directory on MySQL server 1
11 Pattern "\[ERROR\]" not found
12 # Test upgrade on 7.6 data directory on MySQL server 2
13 Pattern "\[ERROR\]" not found
14 SHOW TABLES;
15 Tables_in_test
16 t1
17 SELECT engine from information_schema.tables
18 WHERE table_schema='mysql' and table_name='user';
19 ENGINE
20 InnoDB
21 SHOW TABLES IN db1;
22 Tables_in_db1
23 t1
24 SHOW CREATE TABLE t1;
25 Table Create Table
26 t1 CREATE TABLE `t1` (
27 `a` int NOT NULL,
28 `b` varchar(255) DEFAULT NULL,
29 PRIMARY KEY (`a`)
30 ) /*!50100 TABLESPACE `ts1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
31 SHOW CREATE TABLE db1.t1;
32 Table Create Table
33 t1 CREATE TABLE `t1` (
34 `a` int NOT NULL,
35 `b` varchar(255) DEFAULT NULL,
36 PRIMARY KEY (`a`)
37 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
38 SELECT * FROM t1;
39 a b
40 1 Solskjaer has won it
41 SELECT * FROM db1.t1;
42 a b
43 1 Manchester United have
44 2 Reached the promised land
45 ALTER TABLE t1 DROP COLUMN b;
46 SHOW TABLES;
47 Tables_in_test
48 t1
49 SELECT engine from information_schema.tables
50 WHERE table_schema='mysql' and table_name='user';
51 ENGINE
52 InnoDB
53 SHOW TABLES IN db1;
54 Tables_in_db1
55 t1
56 SHOW CREATE TABLE t1;
57 Table Create Table
58 t1 CREATE TABLE `t1` (
59 `a` int NOT NULL,
60 PRIMARY KEY (`a`)
61 ) /*!50100 TABLESPACE `ts1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
62 SHOW CREATE TABLE db1.t1;
63 Table Create Table
64 t1 CREATE TABLE `t1` (
65 `a` int NOT NULL,
66 `b` varchar(255) DEFAULT NULL,
67 PRIMARY KEY (`a`)
68 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
69 SELECT * FROM t1;
70 a
71 1
72 SELECT * FROM db1.t1;
73 a b
74 1 Manchester United have
75 2 Reached the promised land
76 DROP TABLE t1;
77 DROP TABLE db1.t1;
78 ALTER TABLESPACE ts1
79 DROP DATAFILE 'ts1_datafile.dat';
80 DROP TABLESPACE ts1;
81 DROP LOGFILE GROUP lg1
82 ENGINE NDB;