Debian Codegraph @

mysql-test/suite/innodb/r/import_tablespace_schema_missmatch.result

raw
1 #
2 # Bug #30190227 CRASH IMPORTING TABLESPACE WITH DIFFERENT DATA DIRECTORY
3 # BUT NOT .CFG FILE
4 #
5 # Test-case-1
6 CREATE TABLE t1 (id int unsigned NOT NULL PRIMARY KEY) DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir';
7 INSERT INTO t1 VALUES (1), (2), (3);
8 FLUSH TABLES t1 FOR EXPORT;
9 UNLOCK TABLES;
10 DROP TABLE t1;
11 CREATE TABLE t1 (id int unsigned NOT NULL PRIMARY KEY);
12 ALTER TABLE t1 DISCARD TABLESPACE;
13 ALTER TABLE t1 IMPORT TABLESPACE;
14 ERROR HY000: Schema mismatch (Table location flags do not match. The source table uses a DATA DIRECTORY but the destination table does not.)
15 DROP TABLE t1;
16 #
17 # Test-case-2
18 CREATE TABLE t1 (id int unsigned NOT NULL PRIMARY KEY);
19 INSERT INTO t1 VALUES (1), (2), (3);
20 FLUSH TABLES t1 FOR EXPORT;
21 UNLOCK TABLES;
22 DROP TABLE t1;
23 CREATE TABLE t1 (id int unsigned NOT NULL PRIMARY KEY) DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir';
24 ALTER TABLE t1 DISCARD TABLESPACE;
25 ALTER TABLE t1 IMPORT TABLESPACE;
26 ERROR HY000: Schema mismatch (Table location flags do not match. The source table does not use a DATA DIRECTORY but the destination table does.)
27 DROP TABLE t1;
28 #
29 # Bug #30190199 ERROR WHEN IMPORTING TABLESPACE WITH DIFFERENT DATA
30 # DIRECTORY LACKS DETAILS
31 #
32 # Test-case-3
33 CREATE TABLE t1 (id int unsigned NOT NULL PRIMARY KEY) DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir';
34 INSERT INTO t1 VALUES (1), (2), (3);
35 FLUSH TABLES t1 FOR EXPORT;
36 UNLOCK TABLES;
37 DROP TABLE t1;
38 CREATE TABLE t1 (id int unsigned NOT NULL PRIMARY KEY);
39 ALTER TABLE t1 DISCARD TABLESPACE;
40 ALTER TABLE t1 IMPORT TABLESPACE;
41 ERROR HY000: Schema mismatch (Table location flags do not match. The source table uses a DATA DIRECTORY but the destination table does not.)
42 DROP TABLE t1;
43 #
44 # Test-case-4
45 CREATE TABLE t1 (id int unsigned NOT NULL PRIMARY KEY);
46 INSERT INTO t1 VALUES (1), (2), (3);
47 FLUSH TABLES t1 FOR EXPORT;
48 UNLOCK TABLES;
49 DROP TABLE t1;
50 CREATE TABLE t1 (id int unsigned NOT NULL PRIMARY KEY) DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir';
51 ALTER TABLE t1 DISCARD TABLESPACE;
52 ALTER TABLE t1 IMPORT TABLESPACE;
53 ERROR HY000: Schema mismatch (Table location flags do not match. The source table does not use a DATA DIRECTORY but the destination table does.)
54 DROP TABLE t1;
55 #
56 # Cleanup
57 #