Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2
3 --echo #
4 --echo # Bug #29717909 MEMORY LIFETIME OF VARIABLES BETWEEN CHECK AND UPDATE INCORRECTLY MANAGED
5 --echo #
6
7 #Test innodb_ft_server_stopword_table (global variable)
8 select @@innodb_ft_server_stopword_table;
9 create table user_stopword_1(value varchar(30)) engine = innodb;
10 create table user_stopword_2(value varchar(30)) engine = innodb;
11
12 set @blah = 'test/user_stopword_1';
13 SET GLOBAL innodb_ft_server_stopword_table= @blah;
14 select @@innodb_ft_server_stopword_table;
15
16 set @blah = 'test/user_stopword_2';
17 SET GLOBAL innodb_ft_server_stopword_table= @blah;
18 select @@innodb_ft_server_stopword_table;
19
20 SET GLOBAL innodb_ft_server_stopword_table= NULL;
21 select @@innodb_ft_server_stopword_table;
22
23 SET GLOBAL innodb_ft_server_stopword_table= default;
24 select @@innodb_ft_server_stopword_table;
25
26 drop table user_stopword_1, user_stopword_2;
27
28 #Test innodb_ft_aux_table (global variable)
29 CREATE TABLE t1 ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
30 opening_line TEXT(500), author VARCHAR(200), title VARCHAR(200), FULLTEXT idx
31 (opening_line)) ENGINE=InnoDB;
32
33 CREATE TABLE t2 ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
34 opening_line TEXT(500), author VARCHAR(200), title VARCHAR(200), FULLTEXT idx
35 (opening_line)) ENGINE=InnoDB;
36
37 select @@innodb_ft_aux_table;
38
39 set @blah = 'test/t1';
40 SET GLOBAL innodb_ft_aux_table = @blah;
41 select @@innodb_ft_aux_table;
42
43 set @blah = 'test/t2';
44 SET GLOBAL innodb_ft_aux_table = @blah;
45
46 SET GLOBAL innodb_ft_aux_table = NULL;
47 select @@innodb_ft_aux_table;
48
49 SET GLOBAL innodb_ft_aux_table =default;
50 select @@innodb_ft_aux_table;
51
52 drop table t1,t2;