Debian Codegraph @

mysql-test/suite/innodb/t/sdi.test

raw
1 #
2 # Skip this test when MySQL has been built with other storage engines
3 # than InnoDB, it is because dumping SDI from mysql.ibd
4 # causes extra output when for example the ndbcluster storage engine is
5 # included and additional system tables are added to the MySQL data dictionary
6 # It is hard to separate this output
7 # from mysql.json
8 --source include/have_only_innodb.inc
9
10 #########################
11 # how to record this test JSON result content mismatch
12 # If required fix regex patterns in mysql-test/include/ibd2sdi.pl
13 # and mysql-test/suite/innodb/include/ibd2sdi_replace_pattern.inc,
14 # then run the test with --record option.
15 #########################
16
17 --let $SRC_DIR=$MYSQL_TEST_DIR/std_data/dd/sdi/innodb_sdi
18
19 # Create a directory to store json generated
20 --let $DEST_DIR=$MYSQL_TMP_DIR/sdi_dest/
21 --error 0,1
22 --force-rmdir $DEST_DIR
23 --mkdir $DEST_DIR
24
25 let $MYSQLD_BASEDIR= `select @@basedir`;
26 let $START_PAGE_SIZE= `select @@innodb_page_size`;
27 let $LOG_CAPACITY= `select @@innodb_redo_log_capacity`;
28
29 # Set path for --datadir
30 let $MYSQLD_DATADIR = $MYSQL_TMP_DIR/datadir;
31 --mkdir $MYSQLD_DATADIR
32
33 let BOOTSTRAP_SQL=$MYSQL_TMP_DIR/boot.sql;
34
35 --echo # create bootstrap file
36 write_file $BOOTSTRAP_SQL;
37 CREATE DATABASE test;
38 EOF
39
40 # Set the bootstrap parameters with undo log encryption enabled
41 let NEW_CMD = $MYSQLD --no-defaults --innodb_dedicated_server=OFF --initialize-insecure --secure-file-priv="" --innodb_redo_log_capacity=$LOG_CAPACITY --innodb_page_size=$START_PAGE_SIZE --datadir=$MYSQLD_DATADIR --init-file=$BOOTSTRAP_SQL </dev/null>>$MYSQLTEST_VARDIR/tmp/bootstrap.log 2>&1;
42
43 --echo # Stop the MTR default DB server
44 --source include/shutdown_mysqld.inc
45
46 --echo # Run the bootstrap command
47 --exec $NEW_CMD
48
49 --let $restart_parameters="restart: --datadir=$MYSQLD_DATADIR --innodb_redo_log_capacity=$LOG_CAPACITY"
50 --replace_result $MYSQLD_DATADIR MYSQLD_DATADIR $LOG_CAPACITY LOG_CAPACITY
51 --source include/start_mysqld.inc
52
53 CREATE TABLE t1 (a INT);
54 CREATE TABLE t2 (a INT PRIMARY KEY, b BLOB);
55 CREATE TABLE t3 (a INT PRIMARY KEY, b SMALLINT, c TEXT, d JSON, UNIQUE KEY k1(b), KEY k2(b, c(20)));
56 CREATE TABLE t4 (a INT PRIMARY KEY, b TINYINT, c MEDIUMINT, d BIGINT);
57 CREATE TABLE t5 (a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a,b), c DECIMAL(5,2), d FLOAT(7,4), e DOUBLE);
58 create table `t6` (
59 `c0291` char(140) not null,
60 `c0292` int(10) unsigned zerofill not null,
61 `c0293` time(3) default null,
62 `c0294` int(11) not null,
63 `c0295` binary(1) not null,
64 `c0296` datetime(6) not null,
65 `c0297` date default null,
66 `c0298` mediumtext not null,
67 `c0299` int(10) unsigned zerofill not null,
68 `c0300` decimal(54,6) not null,
69 primary key (`c0296`,`c0298`(186)),
70 unique key `i0002` (`c0294`),
71 unique key `i0005` (`c0298`(102)),
72 unique key `i0007` (`c0299`,`c0292`,`c0297`),
73 unique key `i0008` (`c0296`,`c0293`),
74 unique key `i0001` (`c0297`,`c0298`(240),`c0296`,`c0293`,`c0294`),
75 unique key `i0004` (`c0296`,`c0295`,`c0293`,`c0291`(95),`c0298`(215)),
76 key `i0003` (`c0296`,`c0291`(26)),
77 key `i0006` (`c0297`,`c0296`,`c0293`,`c0294`),
78 key `i0009` (`c0299`,`c0292`,`c0300`) using btree
79 ) engine=innodb default charset=latin1 row_format=compact;
80
81 CREATE TABLE t7(
82 a TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
83 b INT NOT NULL DEFAULT '123',
84 c TIMESTAMP NOT NULL DEFAULT '2000-01-01 00:00:00'
85 ) ROW_FORMAT=REDUNDANT ENGINE=InnoDB;
86
87 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
88 CREATE TABLE t8(fld1 INT NOT NULL PRIMARY KEY) TABLESPACE=ts1 ENGINE=InnoDB;
89 CREATE TABLE t9(fld1 INT NOT NULL, fld2 INT AS (fld1) VIRTUAL, KEY(fld2),
90 FOREIGN KEY(fld1) REFERENCES t8(fld1) ON UPDATE CASCADE) TABLESPACE=ts1 ENGINE=InnoDB;
91
92 CREATE TABLE t10(a INT PRIMARY KEY, b JSON, c BLOB, d LONGBLOB, e MEDIUMBLOB, f TINYBLOB);
93
94 CREATE TABLE t11 (a INT, b INT, c INT GENERATED ALWAYS AS(a+b), h VARCHAR(10),
95 j INT, m INT GENERATED ALWAYS AS(b + x), n VARCHAR(10),
96 p VARCHAR(20) GENERATED ALWAYS AS(CONCAT(n, y)),
97 x INT, y CHAR(20), z INT, INDEX idx1(c), INDEX idx2 (m), INDEX idx3(p)) ENGINE=InnoDB;
98
99 CREATE TABLE t12 (
100 id INT NOT NULL,
101 store_id INT NOT NULL,
102 x INT GENERATED ALWAYS AS (id + store_id)
103 ) ENGINE=InnoDB
104 PARTITION BY RANGE (store_id) (
105 PARTITION p0 VALUES LESS THAN (6),
106 PARTITION p1 VALUES LESS THAN (11),
107 PARTITION p2 VALUES LESS THAN (16),
108 PARTITION p3 VALUES LESS THAN (21)
109 );
110
111 CREATE TABLE t13 (
112 FTS_DOC_ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
113 id int(10) not null ,
114 first_name varchar(50) NOT NULL,
115 last_name varchar(50) NOT NULL,
116 PRIMARY KEY (FTS_DOC_ID),
117 UNIQUE KEY idx_1 (first_name, last_name),
118 FULLTEXT KEY `idx_2` (first_name)
119 ) ENGINE=InnoDB;
120
121 CREATE TABLE t14 (
122 i int(10) unsigned not null auto_increment primary key,
123 a varchar(255) not null,
124 FULLTEXT KEY (a)
125 ) ENGINE = INNODB;
126
127 create table t15 (c1 int, c2 geometry not null SRID 0, spatial index (c2)) engine=innodb;
128
129 CREATE TABLE t16 (
130 a INT,
131 b INT,
132 c INT,
133 d INT,
134 e INT,
135 f INT,
136 PRIMARY KEY (a),
137 INDEX i1 (b),
138 INDEX i2 (c),
139 INDEX i3 (d),
140 INDEX i4 (e)
141 ) ENGINE=INNODB TABLESPACE=`innodb_system`;
142
143 SET GLOBAL innodb_file_per_table=OFF;
144
145 CREATE TABLE t17(
146 c1 iNT AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB;
147
148 SET GLOBAL innodb_file_per_table=default;
149
150 SET NAMES UTF8;
151 CREATE TABLE t18(హి INT, శరెెనిక BLOB);
152
153
154 --echo #
155 --echo # Bug#29020745: INNODB TABLESPACES WITH SUBPARTITIONS DO NOT
156 --echo # CONTAIN TABLE SDI OBJECT
157 --echo #
158 --echo # Bug#30326020: SUBPARTITIONING NOT REFLECTED IN SDI
159 --echo #
160
161 CREATE TABLE t18_ (a INT NOT NULL, b INT)
162 PARTITION BY RANGE (a) PARTITIONS 3 SUBPARTITION BY KEY (b) (
163 PARTITION p1 VALUES LESS THAN (200) (
164 SUBPARTITION p11,
165 SUBPARTITION p12,
166 SUBPARTITION p13),
167 PARTITION p2 VALUES LESS THAN (600) (
168 SUBPARTITION p21,
169 SUBPARTITION p22,
170 SUBPARTITION p23),
171 PARTITION p3 VALUES LESS THAN (1800) (
172 SUBPARTITION p31,
173 SUBPARTITION p32,
174 SUBPARTITION p33));
175
176
177 #--let $table_id=`select HEX(se_private_id) from mysql.tables where name = 't14'`
178 #--echo "table_id is $table_id"
179 #--let $count = `select count(*) from mysql.tablespace_files where file_name like './test/fts_%$table_id%'`
180 #--echo "count is $count"
181 #--let $val = 1
182 #--expr $count = $count - $val
183 #--echo "count is $count"
184 #while ($count >= 0)
185 #{
186 #--let $file_name$count = `select file_name from mysql.tablespace_files where file_name like './test/fts_%$table_id%' LIMIT $count,1`
187 #--echo "file_name is $file_name$count"
188 #dec $count;
189 #}
190
191 --source include/shutdown_mysqld.inc
192
193 --echo # Check SDI from mysql.ibd
194 --let JSON_FILE_PATH = $DEST_DIR/mysql.json
195 --exec $IBD2SDI $MYSQLD_DATADIR/mysql.ibd -d $JSON_FILE_PATH 2>&1
196 --source ../include/ibd2sdi_replace_mysql.inc
197 if ($MTR_RECORD == 0) {
198 --diff_files $SRC_DIR/mysql.json $JSON_FILE_PATH
199 }
200
201 --echo # Check SDI from t1.ibd
202 --let JSON_FILE_PATH = $DEST_DIR/t1.json
203 --exec $IBD2SDI $MYSQLD_DATADIR/test/t1.ibd -d $JSON_FILE_PATH 2>&1
204 --source ../include/ibd2sdi_replace.inc
205 if ($MTR_RECORD == 0) {
206 --diff_files $SRC_DIR/t1.json $JSON_FILE_PATH
207 }
208
209 --echo # Check SDI from t2.ibd
210 --let JSON_FILE_PATH = $DEST_DIR/t2.json
211 --exec $IBD2SDI $MYSQLD_DATADIR/test/t2.ibd -d $JSON_FILE_PATH 2>&1
212 --source ../include/ibd2sdi_replace.inc
213 if ($MTR_RECORD == 0) {
214 --diff_files $SRC_DIR/t2.json $JSON_FILE_PATH
215 }
216
217 --echo # Check SDI from t3.ibd
218 --let JSON_FILE_PATH = $DEST_DIR/t3.json
219 --exec $IBD2SDI $MYSQLD_DATADIR/test/t3.ibd -d $JSON_FILE_PATH 2>&1
220 --source ../include/ibd2sdi_replace.inc
221 if ($MTR_RECORD == 0) {
222 --diff_files $SRC_DIR/t3.json $JSON_FILE_PATH
223 }
224
225 --echo # Check SDI from t4.ibd
226 --let JSON_FILE_PATH = $DEST_DIR/t4.json
227 --exec $IBD2SDI $MYSQLD_DATADIR/test/t4.ibd -d $JSON_FILE_PATH 2>&1
228 --source ../include/ibd2sdi_replace.inc
229 if ($MTR_RECORD == 0) {
230 --diff_files $SRC_DIR/t4.json $JSON_FILE_PATH
231 }
232
233 --echo # Check SDI from t5.ibd
234 --let JSON_FILE_PATH = $DEST_DIR/t5.json
235 --exec $IBD2SDI $MYSQLD_DATADIR/test/t5.ibd -d $JSON_FILE_PATH 2>&1
236 --source ../include/ibd2sdi_replace.inc
237 if ($MTR_RECORD == 0) {
238 --diff_files $SRC_DIR/t5.json $JSON_FILE_PATH
239 }
240
241 --echo # Check SDI from t6.ibd
242 --let JSON_FILE_PATH = $DEST_DIR/t6.json
243 --exec $IBD2SDI $MYSQLD_DATADIR/test/t6.ibd -d $JSON_FILE_PATH 2>&1
244 --source ../include/ibd2sdi_replace.inc
245 if ($MTR_RECORD == 0) {
246 --diff_files $SRC_DIR/t6.json $JSON_FILE_PATH
247 }
248
249 --echo # Check SDI from t7.ibd
250 --let JSON_FILE_PATH = $DEST_DIR/t7.json
251 --exec $IBD2SDI $MYSQLD_DATADIR/test/t7.ibd -d $JSON_FILE_PATH 2>&1
252 --source ../include/ibd2sdi_replace.inc
253 if ($MTR_RECORD == 0) {
254 --diff_files $SRC_DIR/t7.json $JSON_FILE_PATH
255 }
256
257 --echo # Check SDI from ts1.ibd(holds t8 & t9)
258 --let JSON_FILE_PATH = $DEST_DIR/ts1.json
259 --exec $IBD2SDI $MYSQLD_DATADIR/ts1.ibd -d $JSON_FILE_PATH 2>&1
260 --source ../include/ibd2sdi_replace.inc
261 if ($MTR_RECORD == 0) {
262 --diff_files $SRC_DIR/ts1.json $JSON_FILE_PATH
263 }
264
265 --echo # Check SDI from t10.ibd
266 --let JSON_FILE_PATH = $DEST_DIR/t10.json
267 --exec $IBD2SDI $MYSQLD_DATADIR/test/t10.ibd -d $JSON_FILE_PATH 2>&1
268 --source ../include/ibd2sdi_replace.inc
269 if ($MTR_RECORD == 0) {
270 --diff_files $SRC_DIR/t10.json $JSON_FILE_PATH
271 }
272
273 --echo # Check SDI from t11.ibd
274 --let JSON_FILE_PATH = $DEST_DIR/t11.json
275 --exec $IBD2SDI $MYSQLD_DATADIR/test/t11.ibd -d $JSON_FILE_PATH 2>&1
276 --source ../include/ibd2sdi_replace.inc
277 if ($MTR_RECORD == 0) {
278 --diff_files $SRC_DIR/t11.json $JSON_FILE_PATH
279 }
280
281 --echo # Check SDI from partition tables t12.ibd
282 --let JSON_FILE_PATH = $DEST_DIR/t12#p#p0.json
283 --exec $IBD2SDI $MYSQLD_DATADIR/test/t12#p#p0.ibd -d $JSON_FILE_PATH 2>&1
284 --source ../include/ibd2sdi_replace.inc
285 if ($MTR_RECORD == 0) {
286 --diff_files $SRC_DIR/t12#p#p0.json $JSON_FILE_PATH
287 }
288
289 --let JSON_FILE_PATH = $DEST_DIR/t12#p#p1.json
290 --exec $IBD2SDI $MYSQLD_DATADIR/test/t12#p#p1.ibd -d $JSON_FILE_PATH 2>&1
291 --source ../include/ibd2sdi_replace.inc
292 if ($MTR_RECORD == 0) {
293 --diff_files $SRC_DIR/t12#p#p1.json $JSON_FILE_PATH
294 }
295
296 --echo # Check SDI from t13.ibd
297 --let JSON_FILE_PATH = $DEST_DIR/t13.json
298 --exec $IBD2SDI $MYSQLD_DATADIR/test/t13.ibd -d $JSON_FILE_PATH 2>&1
299 --source ../include/ibd2sdi_replace.inc
300 if ($MTR_RECORD == 0) {
301 --diff_files $SRC_DIR/t13.json $JSON_FILE_PATH
302 }
303
304 --echo # Check SDI from t14.ibd
305 --let JSON_FILE_PATH = $DEST_DIR/t14.json
306 --exec $IBD2SDI $MYSQLD_DATADIR/test/t14.ibd -d $JSON_FILE_PATH 2>&1
307 --source ../include/ibd2sdi_replace.inc
308 if ($MTR_RECORD == 0) {
309 --diff_files $SRC_DIR/t14.json $JSON_FILE_PATH
310 }
311
312 # This seems very hard
313 #--echo # Check SDI from FTS .ibd files
314
315 --echo # Check SDI from t15.ibd
316 --let JSON_FILE_PATH = $DEST_DIR/t15.json
317 --exec $IBD2SDI $MYSQLD_DATADIR/test/t15.ibd -d $JSON_FILE_PATH 2>&1
318 --source ../include/ibd2sdi_replace.inc
319 if ($MTR_RECORD == 0) {
320 --diff_files $SRC_DIR/t15.json $JSON_FILE_PATH
321 }
322
323 --echo # Check SDI from system tablespace(has 16,17)
324 --let JSON_FILE_PATH = $DEST_DIR/ibdata1.json
325 --exec $IBD2SDI $MYSQLD_DATADIR/ibdata1 -d $JSON_FILE_PATH 2>&1
326 --source ../include/ibd2sdi_replace_system.inc
327 if ($MTR_RECORD == 0) {
328 --diff_files $SRC_DIR/ibdata1.json $JSON_FILE_PATH
329 }
330
331 --echo # Check SDI from t18.ibd
332 --let JSON_FILE_PATH = $DEST_DIR/t18.json
333 --exec $IBD2SDI $MYSQLD_DATADIR/test/t18.ibd -d $JSON_FILE_PATH 2>&1
334 --source ../include/ibd2sdi_replace.inc
335 if ($MTR_RECORD == 0) {
336 --diff_files $SRC_DIR/t18.json $JSON_FILE_PATH
337 }
338
339 --echo # Check SDI from t18_#p#p1#sp#p11.ibd
340 --echo # Should have both tablespace and table SDIs
341 --let JSON_FILE_PATH = $DEST_DIR/t18_#p#p1#sp#p11.json
342 --exec $IBD2SDI $MYSQLD_DATADIR/test/t18_#p#p1#sp#p11.ibd -d $JSON_FILE_PATH 2>&1
343 --source ../include/ibd2sdi_replace.inc
344 if ($MTR_RECORD == 0) {
345 --diff_files $SRC_DIR/t18_#p#p1#sp#p11.json $JSON_FILE_PATH
346 }
347
348 --echo # Check SDI from t18_#p#p1#sp#p12.ibd
349 --echo # Should only have tablespace SDI
350 --let JSON_FILE_PATH = $DEST_DIR/t18_#p#p1#sp#p12.json
351 --exec $IBD2SDI $MYSQLD_DATADIR/test/t18_#p#p1#sp#p12.ibd -d $JSON_FILE_PATH 2>&1
352 --source ../include/ibd2sdi_replace.inc
353 if ($MTR_RECORD == 0) {
354 --diff_files $SRC_DIR/t18_#p#p1#sp#p12.json $JSON_FILE_PATH
355 }
356
357 --replace_result $MYSQLD_DATADIR MYSQLD_DATADIR $LOG_CAPACITY LOG_CAPACITY
358 --source include/start_mysqld.inc
359 --echo # ALTER TABLE t1, ADD COLUMN. Verify SDI shows the newly added column
360 ALTER TABLE t1 ADD COLUMN b INT, ALGORITHM=INSTANT;
361
362 --echo # ALTER TABLE t2, ADD INDEX, Verify SDI shows the newly added index
363 ALTER TABLE t2 ADD INDEX k1(b(10));
364
365 --echo # ALTER TABLE t3, DROP INDEX, Verify SDI doesn't show dropped index
366 ALTER TABLE t3 DROP INDEX k2;
367
368 --echo # ALTER TABLE t4, DROP column, Verify SDI doesn't show dropped column
369 ALTER TABLE t4 DROP COLUMN d, ALGORITHM=INSTANT;
370
371 --echo # ALTER TABLE RENAME column
372 ALTER TABLE t10 CHANGE a pk INT;
373
374 --echo # Drop virtual column, verify SDI is updated
375 ALTER TABLE t11 DROP COLUMN m;
376
377 --echo # Create and drop tables in general tablespace
378 CREATE TABLE t19(a INT) TABLESPACE=`ts1`;
379 CREATE TABLE t20(a INT, b INT) TABLESPACE=`ts1`;
380 DROP TABLE t19;
381 DROP TABLE t20;
382
383 --source include/shutdown_mysqld.inc
384 --echo # ALTER TABLE t1, ADD COLUMN. Verify SDI shows the newly added column 'b'
385 --echo # Check SDI from t1.ibd
386 --let JSON_FILE_PATH = $DEST_DIR/t1_altered.json
387 --exec $IBD2SDI $MYSQLD_DATADIR/test/t1.ibd -d $JSON_FILE_PATH 2>&1
388 --source ../include/ibd2sdi_replace.inc
389 if ($MTR_RECORD == 0) {
390 --diff_files $SRC_DIR/t1_altered.json $JSON_FILE_PATH
391 }
392
393 --echo # ALTER TABLE t2, ADD INDEX, Verify SDI shows the newly added index 'k1'
394 --echo # Check SDI from t2.ibd
395 --let JSON_FILE_PATH = $DEST_DIR/t2_altered.json
396 --exec $IBD2SDI $MYSQLD_DATADIR/test/t2.ibd -d $JSON_FILE_PATH 2>&1
397 --source ../include/ibd2sdi_replace.inc
398 if ($MTR_RECORD == 0) {
399 --diff_files $SRC_DIR/t2_altered.json $JSON_FILE_PATH
400 }
401
402 --echo # ALTER TABLE t3, DROP INDEX, Verify SDI doesn't show dropped index 'k2'
403 --echo # Check SDI from t3.ibd
404 --let JSON_FILE_PATH = $DEST_DIR/t3_altered.json
405 --exec $IBD2SDI $MYSQLD_DATADIR/test/t3.ibd -d $JSON_FILE_PATH 2>&1
406 --source ../include/ibd2sdi_replace.inc
407 if ($MTR_RECORD == 0) {
408 --diff_files $SRC_DIR/t3_altered.json $JSON_FILE_PATH
409 }
410
411 --echo # ALTER TABLE t4, DROP column, Verify SDI doesn't show dropped column 'd'
412 --echo # Check SDI from t4.ibd
413 --let JSON_FILE_PATH = $DEST_DIR/t4_altered.json
414 --exec $IBD2SDI $MYSQLD_DATADIR/test/t4.ibd -d $JSON_FILE_PATH 2>&1
415 --source ../include/ibd2sdi_replace.inc
416 if ($MTR_RECORD == 0) {
417 --diff_files $SRC_DIR/t4_altered.json $JSON_FILE_PATH
418 }
419
420 --echo # ALTER TABLE t10 RENAME column from 'a' to 'pk'. Verify column name is 'pk'
421 --echo # Check SDI from t10.ibd
422 --let JSON_FILE_PATH = $DEST_DIR/t10_altered.json
423 --exec $IBD2SDI $MYSQLD_DATADIR/test/t10.ibd -d $JSON_FILE_PATH 2>&1
424 --source ../include/ibd2sdi_replace.inc
425 if ($MTR_RECORD == 0) {
426 --diff_files $SRC_DIR/t10_altered.json $JSON_FILE_PATH
427 }
428
429 --echo # Drop virtual column of t11, verify SDI doesn't show clumn 'm'
430 --echo # Check SDI from t11.ibd
431 --let JSON_FILE_PATH = $DEST_DIR/t11_altered.json
432 --exec $IBD2SDI $MYSQLD_DATADIR/test/t11.ibd -d $JSON_FILE_PATH 2>&1
433 --source ../include/ibd2sdi_replace.inc
434 if ($MTR_RECORD == 0) {
435 --diff_files $SRC_DIR/t11_altered.json $JSON_FILE_PATH
436 }
437
438 --echo # Create and drop tables in general tablespace. Shouldn't show t19, t20
439 --let JSON_FILE_PATH = $DEST_DIR/ts1_altered.json
440 --exec $IBD2SDI $MYSQLD_DATADIR/ts1.ibd -d $JSON_FILE_PATH 2>&1
441 --source ../include/ibd2sdi_replace.inc
442 if ($MTR_RECORD == 0) {
443 --diff_files $SRC_DIR/ts1_altered.json $JSON_FILE_PATH
444 }
445
446 # If --record is used, save the json files created in the $DEST_DIR
447 # back to the $SRC_DIR.
448 if ($MTR_RECORD == 1) {
449 --copy_files_wildcard $DEST_DIR $SRC_DIR *.json
450 }
451
452 --echo # Remove json and other test files
453 --force-rmdir $DEST_DIR
454 --force-rmdir $MYSQLD_DATADIR
455 --remove_file $BOOTSTRAP_SQL
456 --remove_file $MYSQLTEST_VARDIR/tmp/bootstrap.log
457
458 --let $restart_parameters=
459 --source include/start_mysqld.inc
460
461 --echo #
462 --echo # Bug#27151163 - INNODB: ASSERTION FAILURE: DICT0SDI.CC:.*
463 --echo #
464 --disable_query_log
465 call mtr.add_suppression("Operating system error number 2 in a file operation.");
466 call mtr.add_suppression("The error means the system cannot find the path specified.");
467 call mtr.add_suppression("Cannot open datafile for read-only:");
468 call mtr.add_suppression("Cannot calculate statistics for table .* because the \.ibd file is missing");
469 call mtr.add_suppression("Tablespace .*, name 'ts1', file 'ts1.ibd' is missing!");
470 call mtr.add_suppression("Cannot find tablespace for 'ts1' in the tablespace memory cache");
471
472 --enable_query_log
473
474 let $MYSQLD_DATADIR= `select @@datadir`;
475 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
476 CREATE DATABASE sdi;
477
478 CREATE TABLE sdi.t1(i int) TABLESPACE ts1;
479
480 --echo # Shutdown the server
481 --source include/shutdown_mysqld.inc
482
483 --echo # Remove ts1.ibd file
484 --remove_file $MYSQLD_DATADIR/ts1.ibd
485
486 --source include/start_mysqld.inc
487
488 --error ER_TABLESPACE_MISSING
489 ALTER TABLE sdi.t1 ADD COLUMN j INT;
490 --error ER_TABLESPACE_MISSING
491 ALTER TABLE sdi.t1 RENAME COLUMN i to j;
492 --error ER_ALTER_FILEGROUP_FAILED
493 ALTER TABLESPACE ts1 RENAME to ts2;
494 SHOW WARNINGS;
495 DROP DATABASE sdi;
496 DROP TABLESPACE ts1;