Debian Codegraph @

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

raw
1 DROP DATABASE IF EXISTS test_jfg2;
2 Warnings:
3 Note 1008 Can't drop database 'test_jfg2'; database doesn't exist
4 DROP DATABASE IF EXISTS test_jfg;
5 Warnings:
6 Note 1008 Can't drop database 'test_jfg'; database doesn't exist
7 CREATE DATABASE test_jfg;
8 CREATE DATABASE test_jfg2;
9 CREATE TABLE test_jfg.test (a int unsigned NOT NULL PRIMARY KEY);
10 RENAME TABLE test_jfg.test TO test_jfg2.test;
11 SELECT * FROM INFORMATION_SCHEMA.INNODB_DATAFILES WHERE PATH LIKE "%test%";
12 SPACE PATH
13 # ./mtr/asserted_test_suppressions.ibd
14 # ./mtr/test_ignored_global_suppressions.ibd
15 # ./mtr/test_suppressions.ibd
16 # ./test_jfg2/test.ibd
17 DROP DATABASE test_jfg;
18 # restart
19 DROP DATABASE test_jfg2;
20 CREATE DATABASE abc_def;
21 CREATE DATABASE abc_def2;
22 CREATE TABLE abc_def.test (a int unsigned NOT NULL PRIMARY KEY);
23 RENAME TABLE abc_def.test TO abc_def2.test1;
24 SELECT * FROM INFORMATION_SCHEMA.INNODB_DATAFILES WHERE PATH LIKE "%test%";
25 SPACE PATH
26 # ./abc_def2/test1.ibd
27 # ./mtr/asserted_test_suppressions.ibd
28 # ./mtr/test_ignored_global_suppressions.ibd
29 # ./mtr/test_suppressions.ibd
30 DROP DATABASE abc_def;
31 # restart
32 DROP DATABASE abc_def2;
33 #
34 # Bug #31773368 AUXILIARY TABLES FOR ALL FTS INDEX
35 # FOR A TABLE WITHOUT RENAMING
36 #
37 CREATE DATABASE test1;
38 CREATE TABLE t1(a int, t1_new_col varchar(100));
39 ALTER TABLE t1 ADD fulltext index full_t2_idx(t1_new_col);
40 Warnings:
41 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
42 ALTER TABLE t1 DROP index full_t2_idx;
43 "List files under test"
44 fts_tableId_being_deleted.ibd
45 fts_tableId_being_deleted_cache.ibd
46 fts_tableId_config.ibd
47 fts_tableId_deleted.ibd
48 fts_tableId_deleted_cache.ibd
49 t1.ibd
50 RENAME TABLE t1 TO test1.t2;
51 "List files under test"
52 "List files under test1"
53 fts_tableId_being_deleted.ibd
54 fts_tableId_being_deleted_cache.ibd
55 fts_tableId_config.ibd
56 fts_tableId_deleted.ibd
57 fts_tableId_deleted_cache.ibd
58 t2.ibd
59 DROP TABLE test1.t2;
60 DROP DATABASE test1;