Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2
3 SET @start_global_value = @@global.innodb_flush_sync;
4
5 #
6 # exists as global only
7 #
8 --echo Valid values are 'ON' and 'OFF'
9 select @@global.innodb_flush_sync in (0, 1);
10 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
11 select @@session.innodb_flush_sync;
12 SET GLOBAL innodb_flush_sync = ON;
13 show global variables like 'innodb_flush_sync';
14 show session variables like 'innodb_flush_sync';
15 --disable_warnings
16 select * from information_schema.global_variables where variable_name='innodb_flush_sync';
17 select * from information_schema.session_variables where variable_name='innodb_flush_sync';
18 --enable_warnings
19
20 set global innodb_flush_sync='OFF';
21 select @@global.innodb_flush_sync;
22 --disable_warnings
23 select * from information_schema.global_variables where variable_name='innodb_flush_sync';
24 select * from information_schema.session_variables where variable_name='innodb_flush_sync';
25 --enable_warnings
26 set @@global.innodb_flush_sync=1;
27 select @@global.innodb_flush_sync;
28 --disable_warnings
29 select * from information_schema.global_variables where variable_name='innodb_flush_sync';
30 select * from information_schema.session_variables where variable_name='innodb_flush_sync';
31 --enable_warnings
32 set global innodb_flush_sync=0;
33 select @@global.innodb_flush_sync;
34 --disable_warnings
35 select * from information_schema.global_variables where variable_name='innodb_flush_sync';
36 select * from information_schema.session_variables where variable_name='innodb_flush_sync';
37 --enable_warnings
38 set @@global.innodb_flush_sync='ON';
39 select @@global.innodb_flush_sync;
40 --disable_warnings
41 select * from information_schema.global_variables where variable_name='innodb_flush_sync';
42 select * from information_schema.session_variables where variable_name='innodb_flush_sync';
43 --enable_warnings
44 --error ER_GLOBAL_VARIABLE
45 set session innodb_flush_sync='OFF';
46 --error ER_GLOBAL_VARIABLE
47 set @@session.innodb_flush_sync='ON';
48
49 #
50 # incorrect types
51 #
52 --error ER_WRONG_TYPE_FOR_VAR
53 set global innodb_flush_sync=1.1;
54 --error ER_WRONG_TYPE_FOR_VAR
55 set global innodb_flush_sync=1e1;
56 --error ER_WRONG_VALUE_FOR_VAR
57 set global innodb_flush_sync=2;
58 --error ER_WRONG_VALUE_FOR_VAR
59 set global innodb_flush_sync=-3;
60 select @@global.innodb_flush_sync;
61 --disable_warnings
62 select * from information_schema.global_variables where variable_name='innodb_flush_sync';
63 select * from information_schema.session_variables where variable_name='innodb_flush_sync';
64 --enable_warnings
65 --error ER_WRONG_VALUE_FOR_VAR
66 set global innodb_flush_sync='AUTO';
67
68 #
69 # Cleanup
70 #
71
72 SET @@global.innodb_flush_sync = @start_global_value;