Debian Codegraph @

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

raw
1
2 let $MYSQLD_DATADIR =`SELECT @@datadir`;
3
4 --echo #
5 --echo # Bug#21341030 - IMPORT TABLESPACE HITS DEBUG ASSERTION WHEN
6 --echo # USING 4K AND ROW_FORMAT=DYNAMIC
7
8 CREATE TABLE t1 (c1 INT, c2 BLOB, c3 BLOB) ENGINE=InnoDB
9 ROW_FORMAT=DYNAMIC;
10
11 INSERT INTO t1 VALUES(100, REPEAT('abcdef', 899), REPEAT('ghijklmn', 4800));
12
13 INSERT INTO t1 SELECT * FROM t1;
14 INSERT INTO t1 SELECT * FROM t1;
15 INSERT INTO t1 SELECT * FROM t1;
16 INSERT INTO t1 SELECT * FROM t1;
17 INSERT INTO t1 SELECT * FROM t1;
18 INSERT INTO t1 SELECT * FROM t1;
19 INSERT INTO t1 SELECT * FROM t1;
20 INSERT INTO t1 SELECT * FROM t1;
21
22 FLUSH TABLES t1 FOR EXPORT;
23 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t1b.ibd
24 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t1b.cfg
25 UNLOCK TABLES;
26
27 ALTER TABLE t1 DISCARD TABLESPACE;
28 --move_file $MYSQLD_DATADIR/test/t1b.ibd $MYSQLD_DATADIR/test/t1.ibd
29 --move_file $MYSQLD_DATADIR/test/t1b.cfg $MYSQLD_DATADIR/test/t1.cfg
30
31 ALTER TABLE t1 IMPORT TABLESPACE;
32 CHECK TABLE t1;
33 DROP TABLE t1;