Debian Codegraph @

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

raw
1
2 DROP DATABASE IF EXISTS test_jfg2;
3 DROP DATABASE IF EXISTS test_jfg;
4
5 CREATE DATABASE test_jfg;
6 CREATE DATABASE test_jfg2;
7 CREATE TABLE test_jfg.test (a int unsigned NOT NULL PRIMARY KEY);
8 RENAME TABLE test_jfg.test TO test_jfg2.test;
9
10 --replace_column 1 #
11 --sorted_result
12 SELECT * FROM INFORMATION_SCHEMA.INNODB_DATAFILES WHERE PATH LIKE "%test%";
13
14 DROP DATABASE test_jfg;
15
16 let $restart_parameters = restart;
17 --source include/restart_mysqld.inc
18
19 DROP DATABASE test_jfg2;
20
21 CREATE DATABASE abc_def;
22 CREATE DATABASE abc_def2;
23
24 CREATE TABLE abc_def.test (a int unsigned NOT NULL PRIMARY KEY);
25 RENAME TABLE abc_def.test TO abc_def2.test1;
26
27 --replace_column 1 #
28 --sorted_result
29 SELECT * FROM INFORMATION_SCHEMA.INNODB_DATAFILES WHERE PATH LIKE "%test%";
30
31 DROP DATABASE abc_def;
32
33 let $restart_parameters = restart;
34 --source include/restart_mysqld.inc
35
36 DROP DATABASE abc_def2;
37
38 --echo #
39 --echo # Bug #31773368 AUXILIARY TABLES FOR ALL FTS INDEX
40 --echo # FOR A TABLE WITHOUT RENAMING
41 --echo #
42
43 let $MYSQLD_DATADIR= `SELECT @@global.datadir`;
44 CREATE DATABASE test1;
45 CREATE TABLE t1(a int, t1_new_col varchar(100));
46 ALTER TABLE t1 ADD fulltext index full_t2_idx(t1_new_col);
47 ALTER TABLE t1 DROP index full_t2_idx;
48
49 --echo "List files under test"
50 --replace_regex /fts_[0-9a-f]*_/fts_tableId_/
51 --list_files $MYSQLD_DATADIR/test
52
53 RENAME TABLE t1 TO test1.t2;
54
55 --echo "List files under test"
56 --replace_regex /fts_[0-9a-f]*_/fts_tableId_/
57 --list_files $MYSQLD_DATADIR/test
58
59 --echo "List files under test1"
60 --replace_regex /fts_[0-9a-f]*_/fts_tableId_/
61 --list_files $MYSQLD_DATADIR/test1
62
63 # cleanup
64 DROP TABLE test1.t2;
65 DROP DATABASE test1;