Debian Codegraph @

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

raw
1 # set session
2
3 SET @start_global_value = @@global.log_slow_verbosity;
4 select @@global.log_slow_verbosity = @@session.log_slow_verbosity;
5 SET @@global.log_slow_verbosity="",@@session.log_slow_verbosity="";
6
7 #
8 # exists as global only
9 #
10 show global variables like 'log_slow_verbosity';
11 show session variables like 'log_slow_verbosity';
12 select * from information_schema.global_variables where variable_name='log_slow_verbosity';
13 select * from information_schema.session_variables where variable_name='log_slow_verbosity';
14
15 #
16 # show that it's writable
17 #
18 set global log_slow_verbosity=1;
19 select @@global.log_slow_verbosity;
20 set session log_slow_verbosity=1;
21 select @@session.log_slow_verbosity;
22
23 #
24 # all valid values
25 #
26 set session log_slow_verbosity=1;
27 select @@session.log_slow_verbosity;
28 set session log_slow_verbosity=2;
29 select @@session.log_slow_verbosity;
30 set session log_slow_verbosity=3;
31 select @@session.log_slow_verbosity;
32 set session log_slow_verbosity=4;
33 select @@session.log_slow_verbosity;
34 set session log_slow_verbosity=5;
35 select @@session.log_slow_verbosity;
36 set session log_slow_verbosity=6;
37 select @@session.log_slow_verbosity;
38 set session log_slow_verbosity=7;
39 select @@session.log_slow_verbosity;
40 set session log_slow_verbosity=8;
41 select @@session.log_slow_verbosity;
42 set session log_slow_verbosity=16;
43 select @@session.log_slow_verbosity;
44 set session log_slow_verbosity=32;
45 select @@session.log_slow_verbosity;
46
47
48 set session log_slow_verbosity='innodb';
49 select @@session.log_slow_verbosity;
50 set session log_slow_verbosity='query_plan';
51 select @@session.log_slow_verbosity;
52 set session log_slow_verbosity='innodb,query_plan';
53 select @@session.log_slow_verbosity;
54 set session log_slow_verbosity='explain';
55 select @@session.log_slow_verbosity;
56 set session log_slow_verbosity='innodb,query_plan,explain,engine,warnings,full';
57 select @@session.log_slow_verbosity;
58 set session log_slow_verbosity='';
59 select @@session.log_slow_verbosity;
60
61 #
62 # incorrect types/values
63 #
64 --error ER_WRONG_TYPE_FOR_VAR
65 set session log_slow_verbosity=1.1;
66 --error ER_WRONG_TYPE_FOR_VAR
67 set session log_slow_verbosity=1e1;
68 --error ER_WRONG_VALUE_FOR_VAR
69 set session log_slow_verbosity="foo";
70 --error ER_WRONG_VALUE_FOR_VAR
71 set session log_slow_verbosity=64;
72
73 SET @@global.log_slow_verbosity = @start_global_value;