Debian Codegraph @

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

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