1SET @start_global_value = @@global.log_disabled_statements;
2select @@global.log_disabled_statements;
3@@global.log_disabled_statements
4sp
5select @@session.log_disabled_statements;
6@@session.log_disabled_statements
7sp
8show global variables like 'log_disabled_statements';
9Variable_name	Value
10log_disabled_statements	sp
11show session variables like 'log_disabled_statements';
12Variable_name	Value
13log_disabled_statements	sp
14select * from information_schema.global_variables where variable_name='log_disabled_statements';
15VARIABLE_NAME	VARIABLE_VALUE
16LOG_DISABLED_STATEMENTS	sp
17select * from information_schema.session_variables where variable_name='log_disabled_statements';
18VARIABLE_NAME	VARIABLE_VALUE
19LOG_DISABLED_STATEMENTS	sp
20set global log_disabled_statements=1;
21select @@global.log_disabled_statements;
22@@global.log_disabled_statements
23slave
24set session log_disabled_statements=1;
25select @@session.log_disabled_statements;
26@@session.log_disabled_statements
27slave
28set session log_disabled_statements=1;
29select @@session.log_disabled_statements;
30@@session.log_disabled_statements
31slave
32set session log_disabled_statements=2;
33select @@session.log_disabled_statements;
34@@session.log_disabled_statements
35sp
36set session log_disabled_statements='slave';
37select @@session.log_disabled_statements;
38@@session.log_disabled_statements
39slave
40set session log_disabled_statements='sp';
41select @@session.log_disabled_statements;
42@@session.log_disabled_statements
43sp
44set session log_disabled_statements='slave,sp';
45select @@session.log_disabled_statements;
46@@session.log_disabled_statements
47slave,sp
48set session log_disabled_statements='';
49select @@session.log_disabled_statements;
50@@session.log_disabled_statements
51
52set session log_disabled_statements=1.1;
53ERROR 42000: Incorrect argument type to variable 'log_disabled_statements'
54set session log_disabled_statements=1e1;
55ERROR 42000: Incorrect argument type to variable 'log_disabled_statements'
56set session log_disabled_statements="foo";
57ERROR 42000: Variable 'log_disabled_statements' can't be set to the value of 'foo'
58set session log_disabled_statements=1024;
59ERROR 42000: Variable 'log_disabled_statements' can't be set to the value of '1024'
60SET @@global.log_disabled_statements = @start_global_value;
61