mysql-test/suite/innodb/r/import.result
raw| 1 | # |
| 2 | # MDEV-26137 ALTER TABLE IMPORT enhancement |
| 3 | # |
| 4 | CREATE TABLE t1(a INT PRIMARY KEY DEFAULT 42) CREATE_OPTIONS; |
| 5 | INSERT INTO t1() VALUES(); |
| 6 | FLUSH TABLES t1 FOR EXPORT; |
| 7 | UNLOCK TABLES; |
| 8 | ALTER TABLE t2 IMPORT TABLESPACE; |
| 9 | SHOW CREATE TABLE t2; |
| 10 | Table Create Table |
| 11 | t2 CREATE TABLE `t2` ( |
| 12 | `a` int(11) NOT NULL DEFAULT 42, |
| 13 | PRIMARY KEY (`a`) |
| 14 | ) CREATE_OPTIONS |
| 15 | SELECT * FROM t2; |
| 16 | a |
| 17 | 42 |
| 18 | DROP TABLE t1, t2; |