Debian Codegraph @

mysql-test/suite/innodb/t/skip_symbolic_links.test

raw
1 --source include/have_innodb.inc
2 --source include/not_windows.inc
3
4 SELECT @@have_symlink;
5 evalp CREATE TABLE t1(a INT, KEY(a)) ENGINE=InnoDB DATA DIRECTORY '$MYSQL_TMP_DIR' INDEX DIRECTORY '$MYSQL_TMP_DIR';
6 DROP TABLE t1;
7 CREATE TABLE t1(a INT, KEY(a)) ENGINE=InnoDB;
8
9 evalp ALTER TABLE t1 DATA DIRECTORY '$MYSQL_TMP_DIR' INDEX DIRECTORY '$MYSQL_TMP_DIR';
10 SHOW CREATE TABLE t1;
11
12 DROP TABLE t1;
13
14 --let $restart_parameters=--symbolic-links
15 --source include/restart_mysqld.inc
16
17 evalp CREATE TABLE t1(a INT PRIMARY KEY, b INT) ENGINE=InnoDB
18 DATA DIRECTORY '$MYSQL_TMP_DIR' INDEX DIRECTORY '$MYSQL_TMP_DIR/other';
19 evalp CREATE TABLE t2(a INT PRIMARY KEY, b INT) ENGINE=InnoDB
20 DATA DIRECTORY '$MYSQL_TMP_DIR' INDEX DIRECTORY '$MYSQL_TMP_DIR';
21
22 TRUNCATE TABLE t1;
23 TRUNCATE TABLE t2;
24
25 --let $restart_parameters=
26 --source include/restart_mysqld.inc
27
28 # Native ALTER will retain DATA DIRECTORY
29 ALTER TABLE t1 FORCE, ALGORITHM=INPLACE;
30 ALTER TABLE t2 FORCE, ALGORITHM=COPY;
31 OPTIMIZE TABLE t1;
32 --list_files $MYSQL_TMP_DIR/test
33 DROP TABLE t2;
34
35 RENAME TABLE t1 TO t2;
36 ALTER TABLE t2 ADD UNIQUE INDEX(b), RENAME TO t3;
37
38 ALTER TABLE t3 RENAME TO t2;
39 ALTER TABLE t2 DROP INDEX b, RENAME TO t1;
40 ALTER TABLE t1 CHANGE b c INT;
41 ALTER TABLE t1 CHANGE c b INT NOT NULL;
42
43 --list_files $MYSQL_TMP_DIR/test
44 # TRUNCATE TABLE will discard DATA DIRECTORY.
45 TRUNCATE TABLE t1;
46 --list_files $MYSQL_TMP_DIR/test
47 DROP TABLE t1;