Debian Codegraph @

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

raw
1
2
3 # 2010-01-25 - Added
4 #
5
6
7 SET @start_global_value = @@global.innodb_change_buffering;
8 SELECT @start_global_value;
9
10 #
11 # exists as global only
12 #
13 --echo Valid values are 'all', 'deletes', 'changes', 'inserts', 'none', 'purges'
14 select @@global.innodb_change_buffering in ('all', 'deletes', 'changes', 'inserts', 'none', 'purges');
15 select @@global.innodb_change_buffering;
16 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
17 select @@session.innodb_change_buffering;
18 show global variables like 'innodb_change_buffering';
19 show session variables like 'innodb_change_buffering';
20 --disable_warnings
21 select * from performance_schema.global_variables where variable_name='innodb_change_buffering';
22 select * from performance_schema.session_variables where variable_name='innodb_change_buffering';
23 --enable_warnings
24
25 #
26 # show that it's writable
27 #
28 set global innodb_change_buffering='none';
29 select @@global.innodb_change_buffering;
30 --disable_warnings
31 select * from performance_schema.global_variables where variable_name='innodb_change_buffering';
32 select * from performance_schema.session_variables where variable_name='innodb_change_buffering';
33 --enable_warnings
34 set @@global.innodb_change_buffering='inserts';
35 select @@global.innodb_change_buffering;
36 --disable_warnings
37 select * from performance_schema.global_variables where variable_name='innodb_change_buffering';
38 select * from performance_schema.session_variables where variable_name='innodb_change_buffering';
39 --enable_warnings
40 --error ER_GLOBAL_VARIABLE
41 set session innodb_change_buffering='some';
42 --error ER_GLOBAL_VARIABLE
43 set @@session.innodb_change_buffering='some';
44
45 #
46 # incorrect types
47 #
48 --error ER_WRONG_TYPE_FOR_VAR
49 set global innodb_change_buffering=1.1;
50 set global innodb_change_buffering=1;
51 SELECT @@global.innodb_change_buffering;
52 --error ER_WRONG_VALUE_FOR_VAR
53 set global innodb_change_buffering=-2;
54 --error ER_WRONG_TYPE_FOR_VAR
55 set global innodb_change_buffering=1e1;
56 --error ER_WRONG_VALUE_FOR_VAR
57 set global innodb_change_buffering='some';
58
59 #
60 # Cleanup
61 #
62
63 SET @@global.innodb_change_buffering = @start_global_value;
64 SELECT @@global.innodb_change_buffering;