Debian Codegraph @

mysql-test/suite/ndb_ddl/metadata_sync.result

raw
1 CREATE LOGFILE GROUP lg1
2 ADD UNDOFILE 'lg1_undofile.dat'
3 INITIAL_SIZE 1M
4 UNDO_BUFFER_SIZE = 1M
5 ENGINE NDB;
6 CREATE TABLESPACE ts1
7 ADD DATAFILE 'ts1_datafile.dat'
8 USE LOGFILE GROUP lg1
9 INITIAL_SIZE 2M
10 ENGINE NDB;
11 USE ndb_ddl_test;
12 CREATE TABLE t10 (
13 a INT PRIMARY KEY,
14 b VARCHAR(255)
15 ) ENGINE NDB
16 TABLESPACE ts1
17 STORAGE DISK;
18 INSERT INTO t10 VALUES(1, 'Poirot');
19 CREATE DATABASE ndb_ddl_test3;
20 USE ndb_ddl_test3;
21 CREATE TABLE t1 (
22 a INT,
23 b INT,
24 PRIMARY KEY(a,b)
25 ) ENGINE NDB;
26 CREATE TABLE t2(
27 a INT PRIMARY KEY,
28 b VARCHAR(255)
29 ) ENGINE NDB;
30 CREATE DATABASE ndb_ddl_test4;
31 USE ndb_ddl_test4;
32 CREATE TABLE t1 (
33 a INT,
34 b INT,
35 PRIMARY KEY(a,b)
36 ) ENGINE NDB;
37 CREATE TABLE t2(
38 a INT PRIMARY KEY,
39 b VARCHAR(255)
40 ) ENGINE NDB;
41 CREATE DATABASE ndb_ddl_test5;
42 USE ndb_ddl_test5;
43 CREATE TABLE t1 (
44 a INT,
45 b INT,
46 PRIMARY KEY(a,b)
47 ) ENGINE NDB;
48 USE ndb_ddl_test;
49 DROP TABLE t6;
50 DROP TABLE t7;
51 DROP TABLE t8;
52 DROP TABLE t9;
53 DROP TABLE t10;
54 ALTER TABLESPACE ts1
55 DROP DATAFILE 'ts1_datafile.dat';
56 DROP TABLESPACE ts1;
57 DROP LOGFILE GROUP lg1
58 ENGINE NDB;
59 USE ndb_ddl_test3;
60 DROP TABLE t1;
61 DROP TABLE t2;
62 SET @old_ndb_metadata_check = @@global.ndb_metadata_check;
63 SET @old_ndb_metadata_check_interval = @@global.ndb_metadata_check_interval;
64 SET SESSION ndb_metadata_check = 1;
65 ERROR HY000: Variable 'ndb_metadata_check' is a GLOBAL variable and should be set with SET GLOBAL
66 SET SESSION ndb_metadata_check_interval = 5;
67 ERROR HY000: Variable 'ndb_metadata_check_interval' is a GLOBAL variable and should be set with SET GLOBAL
68 SET GLOBAL ndb_metadata_check_interval = 0;
69 SET GLOBAL ndb_metadata_check = 1;
70 SET GLOBAL ndb_metadata_check = @old_ndb_metadata_check;
71 SET GLOBAL ndb_metadata_check_interval = @old_ndb_metadata_check_interval;
72 SELECT * FROM ndb_ddl_test.t6;
73 a
74 value1
75 value2
76 value3
77 value4
78 value5
79 SELECT * FROM ndb_ddl_test.t8;
80 a b c d e
81 1 1-t8 2017-10-20 09:13:01 NULL 1
82 2 2-t8 2017-10-20 09:13:02 NULL 2
83 3 3-t8 2017-10-20 09:13:03 NULL 3
84 4 4-t8 2017-10-20 09:13:04 NULL 4
85 5 5-t8 2017-10-20 09:13:05 NULL 5
86 SELECT * FROM ndb_ddl_test.t10;
87 a b
88 1 Poirot
89 ALTER TABLE ndb_ddl_test3.t1
90 ADD COLUMN c VARCHAR(255);
91 Warnings:
92 Warning 1478 Converted FIXED field 'c' to DYNAMIC to enable online ADD COLUMN
93 INSERT INTO ndb_ddl_test3.t1 VALUES(1, 1, 'Use your little grey cells mon ami');
94 SELECT * FROM ndb_ddl_test3.t1;
95 a b c
96 1 1 Use your little grey cells mon ami
97 SHOW CREATE TABLE ndb_ddl_test4.t1;
98 ERROR 42S02: Table 'ndb_ddl_test4.t1' doesn't exist
99 SHOW CREATE TABLE ndb_ddl_test5.t1;
100 ERROR 42S02: Table 'ndb_ddl_test5.t1' doesn't exist
101 CREATE TABLESPACE ts2
102 ADD DATAFILE 'ts2_datafile.dat'
103 USE LOGFILE GROUP lg1
104 INITIAL_SIZE 2M
105 ENGINE NDB;
106 ALTER TABLESPACE ts1
107 ADD DATAFILE 'ts1_datafile2.dat';
108 CREATE TABLE ndb_ddl_test4.t1 (
109 a INT PRIMARY KEY,
110 b INT
111 ) ENGINE NDB;
112 INSERT INTO ndb_ddl_test4.t1 VALUES(1,1);
113 SELECT * FROM ndb_ddl_test4.t1;
114 a b
115 1 1
116 DROP DATABASE ndb_ddl_test3;
117 DROP DATABASE ndb_ddl_test4;
118 DROP DATABASE ndb_ddl_test5;
119 ALTER TABLESPACE ts1
120 DROP DATAFILE 'ts1_datafile.dat';
121 ALTER TABLESPACE ts1
122 DROP DATAFILE 'ts1_datafile2.dat';
123 DROP TABLESPACE ts1;
124 ALTER TABLESPACE ts2
125 DROP DATAFILE 'ts2_datafile.dat';
126 DROP TABLESPACE ts2;
127 DROP LOGFILE GROUP lg1
128 ENGINE NDB;
129 CREATE DATABASE db1;
130 USE db1;
131 CREATE TABLE t1_ndb (
132 a INT PRIMARY KEY,
133 b INT
134 ) ENGINE NDB;
135 CREATE TABLE t2_ndb (
136 a INT PRIMARY KEY,
137 b VARCHAR(255)
138 ) ENGINE NDB;
139 CREATE DATABASE db2;
140 USE db2;
141 CREATE TABLE t1_ndb (
142 a INT PRIMARY KEY,
143 b INT
144 ) ENGINE NDB;
145 CREATE TABLE t2_ndb (
146 a INT PRIMARY KEY,
147 b VARCHAR(255)
148 ) ENGINE NDB;
149 CREATE DATABASE db3;
150 USE db3;
151 CREATE TABLE t1_innodb (
152 a INT PRIMARY KEY,
153 b INT
154 );
155 CREATE TABLE t2_innodb (
156 a INT PRIMARY KEY,
157 b VARCHAR(255)
158 );
159 CREATE DATABASE db4;
160 USE db4;
161 CREATE TABLE t1_ndb (
162 a INT PRIMARY KEY,
163 b INT
164 ) ENGINE NDB;
165 CREATE TABLE t2_ndb (
166 a INT PRIMARY KEY,
167 b VARCHAR(255)
168 ) ENGINE NDB;
169 CREATE TABLE t1_innodb (
170 a INT PRIMARY KEY,
171 b INT
172 );
173 CREATE TABLE t2_innodb (
174 a INT PRIMARY KEY,
175 b VARCHAR(255)
176 );
177 DROP DATABASE db1;
178 DROP DATABASE db4;
179 SHOW DATABASES LIKE 'db%';
180 Database (db%)
181 db1
182 db2
183 db3
184 db4
185 USE db1;
186 SHOW TABLES;
187 Tables_in_db1
188 t1_ndb
189 t2_ndb
190 SHOW CREATE TABLE t1_ndb;
191 Table Create Table
192 t1_ndb CREATE TABLE `t1_ndb` (
193 `a` int NOT NULL,
194 `b` int DEFAULT NULL,
195 PRIMARY KEY (`a`)
196 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
197 SHOW CREATE TABLE t2_ndb;
198 Table Create Table
199 t2_ndb CREATE TABLE `t2_ndb` (
200 `a` int NOT NULL,
201 `b` varchar(255) DEFAULT NULL,
202 PRIMARY KEY (`a`)
203 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
204 USE db2;
205 SHOW TABLES;
206 Tables_in_db2
207 t1_ndb
208 t2_ndb
209 USE db3;
210 SHOW TABLES;
211 Tables_in_db3
212 t1_innodb
213 t2_innodb
214 USE db4;
215 SHOW TABLES;
216 Tables_in_db4
217 t1_ndb
218 t2_ndb
219 SHOW CREATE TABLE t1_ndb;
220 Table Create Table
221 t1_ndb CREATE TABLE `t1_ndb` (
222 `a` int NOT NULL,
223 `b` int DEFAULT NULL,
224 PRIMARY KEY (`a`)
225 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
226 SHOW CREATE TABLE t2_ndb;
227 Table Create Table
228 t2_ndb CREATE TABLE `t2_ndb` (
229 `a` int NOT NULL,
230 `b` varchar(255) DEFAULT NULL,
231 PRIMARY KEY (`a`)
232 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
233 DROP DATABASE db1;
234 DROP DATABASE db2;
235 DROP DATABASE db3;
236 DROP DATABASE db4;
237 CREATE DATABASE DB1;
238 ALTER DATABASE DB1
239 CHARACTER SET latin1;
240 USE DB1;
241 CREATE TABLE t1(
242 id INT PRIMARY KEY
243 ) ENGINE NDB;
244 INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
245 DROP TABLE t1;
246 SHOW TABLES;
247 Tables_in_database
248 t1
249 SELECT * FROM t1;
250 id
251 1
252 2
253 3
254 4
255 5
256 DROP DATABASE DB1;