Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_change_buffering_basic.result

raw
1 SET @start_global_value = @@global.innodb_change_buffering;
2 SELECT @start_global_value;
3 @start_global_value
4 all
5 Valid values are 'all', 'deletes', 'changes', 'inserts', 'none', 'purges'
6 select @@global.innodb_change_buffering in ('all', 'deletes', 'changes', 'inserts', 'none', 'purges');
7 @@global.innodb_change_buffering in ('all', 'deletes', 'changes', 'inserts', 'none', 'purges')
8 1
9 select @@global.innodb_change_buffering;
10 @@global.innodb_change_buffering
11 all
12 select @@session.innodb_change_buffering;
13 ERROR HY000: Variable 'innodb_change_buffering' is a GLOBAL variable
14 show global variables like 'innodb_change_buffering';
15 Variable_name Value
16 innodb_change_buffering all
17 show session variables like 'innodb_change_buffering';
18 Variable_name Value
19 innodb_change_buffering all
20 select * from performance_schema.global_variables where variable_name='innodb_change_buffering';
21 VARIABLE_NAME VARIABLE_VALUE
22 innodb_change_buffering all
23 select * from performance_schema.session_variables where variable_name='innodb_change_buffering';
24 VARIABLE_NAME VARIABLE_VALUE
25 innodb_change_buffering all
26 set global innodb_change_buffering='none';
27 select @@global.innodb_change_buffering;
28 @@global.innodb_change_buffering
29 none
30 select * from performance_schema.global_variables where variable_name='innodb_change_buffering';
31 VARIABLE_NAME VARIABLE_VALUE
32 innodb_change_buffering none
33 select * from performance_schema.session_variables where variable_name='innodb_change_buffering';
34 VARIABLE_NAME VARIABLE_VALUE
35 innodb_change_buffering none
36 set @@global.innodb_change_buffering='inserts';
37 select @@global.innodb_change_buffering;
38 @@global.innodb_change_buffering
39 inserts
40 select * from performance_schema.global_variables where variable_name='innodb_change_buffering';
41 VARIABLE_NAME VARIABLE_VALUE
42 innodb_change_buffering inserts
43 select * from performance_schema.session_variables where variable_name='innodb_change_buffering';
44 VARIABLE_NAME VARIABLE_VALUE
45 innodb_change_buffering inserts
46 set session innodb_change_buffering='some';
47 ERROR HY000: Variable 'innodb_change_buffering' is a GLOBAL variable and should be set with SET GLOBAL
48 set @@session.innodb_change_buffering='some';
49 ERROR HY000: Variable 'innodb_change_buffering' is a GLOBAL variable and should be set with SET GLOBAL
50 set global innodb_change_buffering=1.1;
51 ERROR 42000: Incorrect argument type to variable 'innodb_change_buffering'
52 set global innodb_change_buffering=1;
53 SELECT @@global.innodb_change_buffering;
54 @@global.innodb_change_buffering
55 inserts
56 set global innodb_change_buffering=-2;
57 ERROR 42000: Variable 'innodb_change_buffering' can't be set to the value of '-2'
58 set global innodb_change_buffering=1e1;
59 ERROR 42000: Incorrect argument type to variable 'innodb_change_buffering'
60 set global innodb_change_buffering='some';
61 ERROR 42000: Variable 'innodb_change_buffering' can't be set to the value of 'some'
62 SET @@global.innodb_change_buffering = @start_global_value;
63 SELECT @@global.innodb_change_buffering;
64 @@global.innodb_change_buffering
65 all