Debian Codegraph @

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

raw
1 --echo #
2 --echo # Bug#26938297 - IMPORT OF COMPRESSED TABLE FAILS AND CRASHES THE SERVER
3 --echo #
4
5 --source include/have_innodb_max_16k.inc
6
7 --let $MYSQLD_DATADIR=`SELECT @@datadir`
8 CREATE DATABASE testdb;
9 USE testdb;
10 CREATE TABLE t1 (
11 `col_1` char(255) DEFAULT NULL,
12 `col_2` varchar(255) DEFAULT NULL,
13 `col_3` longtext,
14 `col_4` longtext,
15 `col_5` longtext,
16 `col_6` longtext,
17 `col_7` longtext,
18 `col_8` longtext,
19 `col_9` longtext,
20 `col_10` longtext,
21 `col_11` int(11),
22 PRIMARY KEY(col_11),
23 KEY k1(col_1(10))
24 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 KEY_BLOCK_SIZE=1 STATS_PERSISTENT=0;
25
26 FLUSH TABLES t1 FOR EXPORT;
27 --echo # Copying exported .ibd
28 --copy_file $MYSQLD_DATADIR/testdb/t1.ibd $MYSQLD_DATADIR/testdb/t1.ibd.backup
29 --copy_file $MYSQLD_DATADIR/testdb/t1.cfg $MYSQLD_DATADIR/testdb/t1.cfg.backup
30 UNLOCK TABLES;
31
32 ALTER TABLE t1 DISCARD TABLESPACE;
33
34 --echo # Copying exported .ibd to import
35 --move_file $MYSQLD_DATADIR/testdb/t1.ibd.backup $MYSQLD_DATADIR/testdb/t1.ibd
36 --move_file $MYSQLD_DATADIR/testdb/t1.cfg.backup $MYSQLD_DATADIR/testdb/t1.cfg
37
38 ALTER TABLE t1 IMPORT TABLESPACE;
39
40 # Verify SDI is writable
41 ALTER TABLE t1 DROP INDEX k1;
42
43 DROP TABLE t1;
44 DROP DATABASE testdb;