blob: d1ed09456a541f4def649fe7f14d76e5084469b0 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
#
# MDEV-26137 ALTER TABLE IMPORT enhancement
#
CREATE TABLE t1(a INT PRIMARY KEY DEFAULT 42) CREATE_OPTIONS;
INSERT INTO t1() VALUES();
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) NOT NULL DEFAULT 42,
PRIMARY KEY (`a`)
) CREATE_OPTIONS
SELECT * FROM t2;
a
42
DROP TABLE t1, t2;
|
