Debian Codegraph @

mysql-test/suite/innodb_fts/t/innodb_ft_aux_table.test

raw
1 --source include/have_innodb.inc
2 --source include/maybe_versioning.inc
3
4 CREATE TABLE t1 (v VARCHAR(100), FULLTEXT INDEX (v)) ENGINE=InnoDB;
5
6 insert into t1 VALUES('First record'),('Second record'),('Third record');
7
8 SET @save_ft_aux_table = @@GLOBAL.innodb_ft_aux_table;
9
10 connect (con1,localhost,root,,);
11 --error ER_WRONG_VALUE_FOR_VAR
12 SET GLOBAL innodb_ft_aux_table = 'test/t0';
13 connection default;
14 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_DEFAULT_STOPWORD;
15 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_DELETED;
16 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_BEING_DELETED;
17 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
18 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
19 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG;
20 connection con1;
21 SET GLOBAL innodb_ft_aux_table = 'test/t1';
22 disconnect con1;
23 connection default;
24 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_DELETED;
25 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_BEING_DELETED;
26 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
27 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
28 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG;
29 SELECT @@GLOBAL.innodb_ft_aux_table;
30 RENAME TABLE t1 TO t2;
31 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_DELETED;
32 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_BEING_DELETED;
33 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
34 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
35 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG;
36 SELECT @@GLOBAL.innodb_ft_aux_table;
37 DROP TABLE t2;
38 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_DELETED;
39 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_BEING_DELETED;
40 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
41 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
42 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG;
43 SELECT @@GLOBAL.innodb_ft_aux_table;
44
45 CREATE TABLE t(a INT) ENGINE=InnoDB;
46 --error ER_WRONG_VALUE_FOR_VAR
47 SET GLOBAL innodb_ft_aux_table='test/t';
48 DROP TABLE t;
49 --error ER_WRONG_VALUE_FOR_VAR
50 SET GLOBAL innodb_ft_aux_table='test/t';
51 SELECT @@GLOBAL.innodb_ft_aux_table;
52
53 SET GLOBAL innodb_ft_aux_table = @save_ft_aux_table;