Debian Codegraph @

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

raw
1 # set session
2
3 SET @start_global_value = @@global.log_disabled_statements;
4
5 #
6 # exists as global only
7 #
8 select @@global.log_disabled_statements;
9 select @@session.log_disabled_statements;
10 show global variables like 'log_disabled_statements';
11 show session variables like 'log_disabled_statements';
12 select * from information_schema.global_variables where variable_name='log_disabled_statements';
13 select * from information_schema.session_variables where variable_name='log_disabled_statements';
14
15 #
16 # show that it's writable
17 #
18 set global log_disabled_statements=1;
19 select @@global.log_disabled_statements;
20 set session log_disabled_statements=1;
21 select @@session.log_disabled_statements;
22
23 #
24 # all valid values
25 #
26 set session log_disabled_statements=1;
27 select @@session.log_disabled_statements;
28 set session log_disabled_statements=2;
29 select @@session.log_disabled_statements;
30 set session log_disabled_statements='slave';
31 select @@session.log_disabled_statements;
32 set session log_disabled_statements='sp';
33 select @@session.log_disabled_statements;
34 set session log_disabled_statements='slave,sp';
35 select @@session.log_disabled_statements;
36 set session log_disabled_statements='';
37 select @@session.log_disabled_statements;
38
39 #
40 # incorrect types/values
41 #
42 --error ER_WRONG_TYPE_FOR_VAR
43 set session log_disabled_statements=1.1;
44 --error ER_WRONG_TYPE_FOR_VAR
45 set session log_disabled_statements=1e1;
46 --error ER_WRONG_VALUE_FOR_VAR
47 set session log_disabled_statements="foo";
48 --error ER_WRONG_VALUE_FOR_VAR
49 set session log_disabled_statements=1024;
50
51 SET @@global.log_disabled_statements = @start_global_value;