diff options
Diffstat (limited to 'mysql-test/suite/encryption/r/innodb_import.result')
-rw-r--r-- | mysql-test/suite/encryption/r/innodb_import.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/suite/encryption/r/innodb_import.result b/mysql-test/suite/encryption/r/innodb_import.result index 54b95ab26d4..b1895b65ef7 100644 --- a/mysql-test/suite/encryption/r/innodb_import.result +++ b/mysql-test/suite/encryption/r/innodb_import.result @@ -20,3 +20,22 @@ SELECT * FROM t2; f1 f2 1 InnoDB DROP TABLE t1, t2; +# +# MDEV-26137 ALTER TABLE IMPORT enhancement +# +# with encryption and page_compressed +CREATE TABLE t1 (a int, b varchar(50)) ENGINE=InnoDB ENCRYPTED=YES ENCRYPTION_KEY_ID=6 PAGE_COMPRESSED=1; +INSERT INTO t1 VALUES(42, "hello"); +FLUSH TABLES t1 FOR EXPORT; +UNLOCK TABLES; +ALTER TABLE t2 IMPORT TABLESPACE; +SHOW CREATE TABLE t2; +Table Create Table +t2 CREATE TABLE `t2` ( + `a` int(11) DEFAULT NULL, + `b` varchar(50) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `ENCRYPTED`=YES `ENCRYPTION_KEY_ID`=6 `PAGE_COMPRESSED`=1 +SELECT * FROM t2; +a b +42 hello +DROP TABLE t1, t2; |