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 select @@innodb_buffer_pool_filename;
29 @@innodb_buffer_pool_filename
30 ib_buffer_pool
31 set @blah='hello';
32 set global innodb_buffer_pool_filename = @blah;
33 select @@innodb_buffer_pool_filename;
34 @@innodb_buffer_pool_filename
35 hello
36 set global innodb_buffer_pool_filename="bye";
37 select @@innodb_buffer_pool_filename;
38 @@innodb_buffer_pool_filename
39 bye
40 set global innodb_buffer_pool_filename=default;
41 select @@innodb_buffer_pool_filename;
42 @@innodb_buffer_pool_filename
43 ib_buffer_pool
44 CREATE TABLE t1 ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
45 opening_line TEXT(500), author VARCHAR(200), title VARCHAR(200), FULLTEXT idx
46 (opening_line)) ENGINE=InnoDB;
47 CREATE TABLE t2 ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
48 opening_line TEXT(500), author VARCHAR(200), title VARCHAR(200), FULLTEXT idx
49 (opening_line)) ENGINE=InnoDB;
50 select @@innodb_ft_aux_table;
51 @@innodb_ft_aux_table
52 NULL
53 set @blah = 'test/t1';
54 SET GLOBAL innodb_ft_aux_table = @blah;
55 select @@innodb_ft_aux_table;
56 @@innodb_ft_aux_table
57 test/t1
58 set @blah = 'test/t2';
59 SET GLOBAL innodb_ft_aux_table = @blah;
60 SET GLOBAL innodb_ft_aux_table = NULL;
61 select @@innodb_ft_aux_table;
62 @@innodb_ft_aux_table
63 NULL
64 SET GLOBAL innodb_ft_aux_table =default;
65 select @@innodb_ft_aux_table;
66 @@innodb_ft_aux_table
67 NULL
68 drop table t1,t2;
69 set @blah = 'label1:/home/guest/redo_log_archive_1';
70 SET global innodb_redo_log_archive_dirs = @blah;
71 select @@innodb_redo_log_archive_dirs;
72 @@innodb_redo_log_archive_dirs
73 label1:/home/guest/redo_log_archive_1
74 SET global innodb_redo_log_archive_dirs = default;
75 select @@innodb_redo_log_archive_dirs;
76 @@innodb_redo_log_archive_dirs
77 NULL
78 SET global innodb_redo_log_archive_dirs = NULL;
79 select @@innodb_redo_log_archive_dirs;
80 @@innodb_redo_log_archive_dirs
81 NULL
82 SET @@global.innodb_redo_log_archive_dirs = '';