Debian Codegraph @

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

raw
1 --echo #
2 --echo # Bug #29717909 MEMORY LIFETIME OF VARIABLES BETWEEN CHECK AND UPDATE INCORRECTLY MANAGED
3 --echo #
4
5 #Test innodb_ft_server_stopword_table (global variable)
6 select @@innodb_ft_server_stopword_table;
7 create table user_stopword_1(value varchar(30)) engine = innodb;
8 create table user_stopword_2(value varchar(30)) engine = innodb;
9
10 set @blah = 'test/user_stopword_1';
11 SET GLOBAL innodb_ft_server_stopword_table= @blah;
12 select @@innodb_ft_server_stopword_table;
13
14 set @blah = 'test/user_stopword_2';
15 SET GLOBAL innodb_ft_server_stopword_table= @blah;
16 select @@innodb_ft_server_stopword_table;
17
18 SET GLOBAL innodb_ft_server_stopword_table= NULL;
19 select @@innodb_ft_server_stopword_table;
20
21 SET GLOBAL innodb_ft_server_stopword_table= default;
22 select @@innodb_ft_server_stopword_table;
23
24 drop table user_stopword_1, user_stopword_2;
25
26 #Test innodb_buffer_pool_filename (global variable)
27
28 select @@innodb_buffer_pool_filename;
29
30 set @blah='hello';
31 set global innodb_buffer_pool_filename = @blah;
32 select @@innodb_buffer_pool_filename;
33
34 set global innodb_buffer_pool_filename="bye";
35 select @@innodb_buffer_pool_filename;
36
37 set global innodb_buffer_pool_filename=default;
38 select @@innodb_buffer_pool_filename;
39
40 #Test innodb_ft_aux_table (global variable)
41 CREATE TABLE t1 ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
42 opening_line TEXT(500), author VARCHAR(200), title VARCHAR(200), FULLTEXT idx
43 (opening_line)) ENGINE=InnoDB;
44
45 CREATE TABLE t2 ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
46 opening_line TEXT(500), author VARCHAR(200), title VARCHAR(200), FULLTEXT idx
47 (opening_line)) ENGINE=InnoDB;
48
49 select @@innodb_ft_aux_table;
50
51 set @blah = 'test/t1';
52 SET GLOBAL innodb_ft_aux_table = @blah;
53 select @@innodb_ft_aux_table;
54
55 set @blah = 'test/t2';
56 SET GLOBAL innodb_ft_aux_table = @blah;
57
58 SET GLOBAL innodb_ft_aux_table = NULL;
59 select @@innodb_ft_aux_table;
60
61 SET GLOBAL innodb_ft_aux_table =default;
62 select @@innodb_ft_aux_table;
63
64 drop table t1,t2;
65
66 #Test innodb_redo_log_archive_dirs
67 --let $saved_dirs = `SELECT @@global.innodb_redo_log_archive_dirs`
68
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
73
74 SET global innodb_redo_log_archive_dirs = default;
75 select @@innodb_redo_log_archive_dirs;
76
77 SET global innodb_redo_log_archive_dirs = NULL;
78 select @@innodb_redo_log_archive_dirs;
79
80 eval SET @@global.innodb_redo_log_archive_dirs = '$saved_dirs';
81
82
83