Debian Codegraph @

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

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