Debian Codegraph @

mysql-test/suite/encryption/r/innodb_import.result

raw
1 #
2 # MDEV-26131 SEGV in ha_innobase::discard_or_import_tablespace
3 #
4 CREATE TABLE t1(f1 int,f2 text)ENGINE=InnoDB;
5 INSERT INTO t1 VALUES(1, "InnoDB");
6 CREATE TABLE t2 LIKE t1;
7 ALTER TABLE t2 ADD KEY idx (f2(13));
8 ALTER TABLE t2 DISCARD TABLESPACE;
9 FLUSH TABLES t1 FOR EXPORT;
10 UNLOCK TABLES;
11 ALTER TABLE t2 IMPORT TABLESPACE;
12 ERROR HY000: Internal error: Drop all secondary indexes before importing table test/t2 when .cfg file is missing.
13 ALTER TABLE t2 DROP KEY idx;
14 Warnings:
15 Warning 1814 Tablespace has been discarded for table `t2`
16 ALTER TABLE t2 IMPORT TABLESPACE;
17 Warnings:
18 Warning 1810 IO Read error: (2, No such file or directory) Error opening './test/t2.cfg', will attempt to import without schema verification
19 SELECT * FROM t2;
20 f1 f2
21 1 InnoDB
22 DROP TABLE t1, t2;
23 #
24 # MDEV-26137 ALTER TABLE IMPORT enhancement
25 #
26 # with encryption and page_compressed
27 CREATE TABLE t1 (a int, b varchar(50)) ENGINE=InnoDB ENCRYPTED=YES ENCRYPTION_KEY_ID=6 PAGE_COMPRESSED=1;
28 INSERT INTO t1 VALUES(42, "hello");
29 FLUSH TABLES t1 FOR EXPORT;
30 UNLOCK TABLES;
31 ALTER TABLE t2 IMPORT TABLESPACE;
32 SHOW CREATE TABLE t2;
33 Table Create Table
34 t2 CREATE TABLE `t2` (
35 `a` int(11) DEFAULT NULL,
36 `b` varchar(50) DEFAULT NULL
37 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `ENCRYPTED`=YES `ENCRYPTION_KEY_ID`=6 `PAGE_COMPRESSED`=1
38 SELECT * FROM t2;
39 a b
40 42 hello
41 DROP TABLE t1, t2;