Debian Codegraph @

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

raw
1 SELECT @@have_symlink;
2 @@have_symlink
3 DISABLED
4 CREATE TABLE t1(a INT, KEY(a)) ENGINE=InnoDB DATA DIRECTORY '$MYSQL_TMP_DIR' INDEX DIRECTORY '$MYSQL_TMP_DIR';
5 Warnings:
6 Warning 1618 DATA DIRECTORY option ignored
7 Note 1618 INDEX DIRECTORY option ignored
8 DROP TABLE t1;
9 CREATE TABLE t1(a INT, KEY(a)) ENGINE=InnoDB;
10 ALTER TABLE t1 DATA DIRECTORY '$MYSQL_TMP_DIR' INDEX DIRECTORY '$MYSQL_TMP_DIR';
11 Warnings:
12 Warning 1618 DATA DIRECTORY option ignored
13 Warning 1618 INDEX DIRECTORY option ignored
14 SHOW CREATE TABLE t1;
15 Table Create Table
16 t1 CREATE TABLE `t1` (
17 `a` int(11) DEFAULT NULL,
18 KEY `a` (`a`)
19 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
20 DROP TABLE t1;
21 # restart: --symbolic-links
22 CREATE TABLE t1(a INT PRIMARY KEY, b INT) ENGINE=InnoDB
23 DATA DIRECTORY '$MYSQL_TMP_DIR' INDEX DIRECTORY '$MYSQL_TMP_DIR/other';
24 Warnings:
25 Note 1618 INDEX DIRECTORY option ignored
26 CREATE TABLE t2(a INT PRIMARY KEY, b INT) ENGINE=InnoDB
27 DATA DIRECTORY '$MYSQL_TMP_DIR' INDEX DIRECTORY '$MYSQL_TMP_DIR';
28 TRUNCATE TABLE t1;
29 TRUNCATE TABLE t2;
30 # restart
31 ALTER TABLE t1 FORCE, ALGORITHM=INPLACE;
32 ALTER TABLE t2 FORCE, ALGORITHM=COPY;
33 OPTIMIZE TABLE t1;
34 Table Op Msg_type Msg_text
35 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
36 test.t1 optimize status OK
37 t1.ibd
38 t2.ibd
39 DROP TABLE t2;
40 RENAME TABLE t1 TO t2;
41 ALTER TABLE t2 ADD UNIQUE INDEX(b), RENAME TO t3;
42 Warnings:
43 Warning 1618 DATA DIRECTORY option ignored
44 ALTER TABLE t3 RENAME TO t2;
45 ALTER TABLE t2 DROP INDEX b, RENAME TO t1;
46 Warnings:
47 Warning 1618 DATA DIRECTORY option ignored
48 ALTER TABLE t1 CHANGE b c INT;
49 Warnings:
50 Warning 1618 DATA DIRECTORY option ignored
51 ALTER TABLE t1 CHANGE c b INT NOT NULL;
52 Warnings:
53 Warning 1618 DATA DIRECTORY option ignored
54 t1.ibd
55 TRUNCATE TABLE t1;
56 DROP TABLE t1;