Debian Codegraph @

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

raw
1 Backup from 7.6 restored
2 Restart server 1 to trigger schema synchronization
3 # restart: --debug=d,ndb_install_tablespace_fail
4 Restart server 2 to trigger schema synchronization
5 # restart: --debug=d,ndb_install_tablespace_fail
6 SHOW TABLES;
7 Tables_in_test
8 t1
9 SHOW CREATE TABLE t1;
10 Table Create Table
11 t1 CREATE TABLE `t1` (
12 `a` int NOT NULL,
13 `b` varchar(255) DEFAULT NULL,
14 PRIMARY KEY (`a`)
15 ) /*!50100 TABLESPACE `ts1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
16 SELECT * FROM t1;
17 a b
18 1 Sad Cypress
19 SHOW TABLES;
20 Tables_in_test
21 t1
22 SHOW CREATE TABLE t1;
23 Table Create Table
24 t1 CREATE TABLE `t1` (
25 `a` int NOT NULL,
26 `b` varchar(255) DEFAULT NULL,
27 PRIMARY KEY (`a`)
28 ) /*!50100 TABLESPACE `ts1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
29 SELECT * FROM t1;
30 a b
31 1 Sad Cypress
32 ALTER TABLE t1 DROP COLUMN b;
33 INSERT INTO t1 VALUES(2);
34 SELECT * FROM t1;
35 a
36 1
37 2
38 DROP TABLE t1;
39 ALTER TABLESPACE ts1
40 DROP DATAFILE 'ts1_datafile.dat';
41 DROP TABLESPACE ts1;
42 DROP LOGFILE GROUP lg1
43 ENGINE NDB;
44 CREATE LOGFILE GROUP lg1
45 ADD UNDOFILE 'lg1_undofile.dat'
46 INITIAL_SIZE 1M
47 UNDO_BUFFER_SIZE = 1M
48 ENGINE NDB;
49 CREATE TABLESPACE ts1
50 ADD DATAFILE 'ts1_datafile.dat'
51 USE LOGFILE GROUP lg1
52 INITIAL_SIZE 2M
53 ENGINE NDB;
54 CREATE TABLE t1 (
55 a INT PRIMARY KEY,
56 b VARCHAR(255)
57 ) ENGINE NDB
58 TABLESPACE ts1
59 STORAGE DISK;
60 INSERT INTO t1 VALUES (1,'And Then There Were None');
61 DROP TABLE t1;
62 ALTER TABLESPACE ts1
63 DROP DATAFILE 'ts1_datafile.dat';
64 DROP TABLESPACE ts1;
65 DROP LOGFILE GROUP lg1
66 ENGINE NDB;
67 Restart server 1 to trigger schema synchronization
68 # restart: --debug=d,ndb_install_tablespace_fail
69 Restart server 2 to trigger schema synchronization
70 # restart: --debug=d,ndb_install_tablespace_fail
71 SHOW TABLES;
72 Tables_in_test
73 t1
74 SHOW CREATE TABLE t1;
75 Table Create Table
76 t1 CREATE TABLE `t1` (
77 `a` int NOT NULL,
78 `b` varchar(255) DEFAULT NULL,
79 PRIMARY KEY (`a`)
80 ) /*!50100 TABLESPACE `ts1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
81 SELECT * FROM t1;
82 a b
83 1 And Then There Were None
84 SHOW TABLES;
85 Tables_in_test
86 t1
87 SHOW CREATE TABLE t1;
88 Table Create Table
89 t1 CREATE TABLE `t1` (
90 `a` int NOT NULL,
91 `b` varchar(255) DEFAULT NULL,
92 PRIMARY KEY (`a`)
93 ) /*!50100 TABLESPACE `ts1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
94 SELECT * FROM t1;
95 a b
96 1 And Then There Were None
97 ALTER TABLE t1 DROP COLUMN b;
98 INSERT INTO t1 VALUES(2);
99 SELECT * FROM t1;
100 a
101 1
102 2
103 DROP TABLE t1;
104 ALTER TABLESPACE ts1
105 DROP DATAFILE 'ts1_datafile.dat';
106 DROP TABLESPACE ts1;
107 DROP LOGFILE GROUP lg1
108 ENGINE NDB;