Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_flush_neighbors_basic.test

raw
1
2
3 # 2011-02-23 - Added
4 #
5
6
7 SET @start_global_value = @@global.innodb_flush_neighbors;
8 SELECT @start_global_value;
9
10 #
11 # exists as global only
12 #
13 select @@global.innodb_flush_neighbors;
14 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
15 select @@session.innodb_flush_neighbors;
16 show global variables like 'innodb_flush_neighbors';
17 show session variables like 'innodb_flush_neighbors';
18 --disable_warnings
19 select * from performance_schema.global_variables where variable_name='innodb_flush_neighbors';
20 select * from performance_schema.session_variables where variable_name='innodb_flush_neighbors';
21 --enable_warnings
22
23 #
24 # show that it's writable
25 #
26 set global innodb_flush_neighbors=0;
27 select @@global.innodb_flush_neighbors;
28 --disable_warnings
29 select * from performance_schema.global_variables where variable_name='innodb_flush_neighbors';
30 select * from performance_schema.session_variables where variable_name='innodb_flush_neighbors';
31 --enable_warnings
32 set @@global.innodb_flush_neighbors=TRUE;
33 select @@global.innodb_flush_neighbors;
34 --disable_warnings
35 select * from performance_schema.global_variables where variable_name='innodb_flush_neighbors';
36 select * from performance_schema.session_variables where variable_name='innodb_flush_neighbors';
37 --enable_warnings
38 set global innodb_flush_neighbors=0;
39 select @@global.innodb_flush_neighbors;
40 --disable_warnings
41 select * from performance_schema.global_variables where variable_name='innodb_flush_neighbors';
42 select * from performance_schema.session_variables where variable_name='innodb_flush_neighbors';
43 --enable_warnings
44 set @@global.innodb_flush_neighbors=2;
45 select @@global.innodb_flush_neighbors;
46 --disable_warnings
47 select * from performance_schema.global_variables where variable_name='innodb_flush_neighbors';
48 select * from performance_schema.session_variables where variable_name='innodb_flush_neighbors';
49 --enable_warnings
50 set @@global.innodb_flush_neighbors=DEFAULT;
51 select @@global.innodb_flush_neighbors;
52 --disable_warnings
53 select * from performance_schema.global_variables where variable_name='innodb_flush_neighbors';
54 select * from performance_schema.session_variables where variable_name='innodb_flush_neighbors';
55 --enable_warnings
56 --error ER_GLOBAL_VARIABLE
57 set session innodb_flush_neighbors=0;
58 --error ER_GLOBAL_VARIABLE
59 set @@session.innodb_flush_neighbors=1;
60
61 #
62 # incorrect types
63 #
64 --error ER_WRONG_TYPE_FOR_VAR
65 set global innodb_flush_neighbors='OFF';
66 --error ER_WRONG_TYPE_FOR_VAR
67 set global innodb_flush_neighbors='ON';
68 --error ER_WRONG_TYPE_FOR_VAR
69 set global innodb_flush_neighbors=1.1;
70 --error ER_WRONG_TYPE_FOR_VAR
71 set global innodb_flush_neighbors=1e1;
72 set global innodb_flush_neighbors=3;
73 select @@global.innodb_flush_neighbors;
74 set global innodb_flush_neighbors=-3;
75 select @@global.innodb_flush_neighbors;
76 --error ER_WRONG_TYPE_FOR_VAR
77 set global innodb_flush_neighbors='AUTO';
78
79 #
80 # Cleanup
81 #
82
83 SET @@global.innodb_flush_neighbors = @start_global_value;
84 SELECT @@global.innodb_flush_neighbors;