Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.log_slow_verbosity;
2 select @@global.log_slow_verbosity = @@session.log_slow_verbosity;
3 @@global.log_slow_verbosity = @@session.log_slow_verbosity
4 1
5 SET @@global.log_slow_verbosity="",@@session.log_slow_verbosity="";
6 show global variables like 'log_slow_verbosity';
7 Variable_name Value
8 log_slow_verbosity
9 show session variables like 'log_slow_verbosity';
10 Variable_name Value
11 log_slow_verbosity
12 select * from information_schema.global_variables where variable_name='log_slow_verbosity';
13 VARIABLE_NAME VARIABLE_VALUE
14 LOG_SLOW_VERBOSITY
15 select * from information_schema.session_variables where variable_name='log_slow_verbosity';
16 VARIABLE_NAME VARIABLE_VALUE
17 LOG_SLOW_VERBOSITY
18 set global log_slow_verbosity=1;
19 select @@global.log_slow_verbosity;
20 @@global.log_slow_verbosity
21 innodb
22 set session log_slow_verbosity=1;
23 select @@session.log_slow_verbosity;
24 @@session.log_slow_verbosity
25 innodb
26 set session log_slow_verbosity=1;
27 select @@session.log_slow_verbosity;
28 @@session.log_slow_verbosity
29 innodb
30 set session log_slow_verbosity=2;
31 select @@session.log_slow_verbosity;
32 @@session.log_slow_verbosity
33 query_plan
34 set session log_slow_verbosity=3;
35 select @@session.log_slow_verbosity;
36 @@session.log_slow_verbosity
37 innodb,query_plan
38 set session log_slow_verbosity=4;
39 select @@session.log_slow_verbosity;
40 @@session.log_slow_verbosity
41 explain
42 set session log_slow_verbosity=5;
43 select @@session.log_slow_verbosity;
44 @@session.log_slow_verbosity
45 innodb,explain
46 set session log_slow_verbosity=6;
47 select @@session.log_slow_verbosity;
48 @@session.log_slow_verbosity
49 query_plan,explain
50 set session log_slow_verbosity=7;
51 select @@session.log_slow_verbosity;
52 @@session.log_slow_verbosity
53 innodb,query_plan,explain
54 set session log_slow_verbosity=8;
55 select @@session.log_slow_verbosity;
56 @@session.log_slow_verbosity
57 engine
58 set session log_slow_verbosity=16;
59 select @@session.log_slow_verbosity;
60 @@session.log_slow_verbosity
61 warnings
62 set session log_slow_verbosity=32;
63 select @@session.log_slow_verbosity;
64 @@session.log_slow_verbosity
65 full
66 set session log_slow_verbosity='innodb';
67 select @@session.log_slow_verbosity;
68 @@session.log_slow_verbosity
69 innodb
70 set session log_slow_verbosity='query_plan';
71 select @@session.log_slow_verbosity;
72 @@session.log_slow_verbosity
73 query_plan
74 set session log_slow_verbosity='innodb,query_plan';
75 select @@session.log_slow_verbosity;
76 @@session.log_slow_verbosity
77 innodb,query_plan
78 set session log_slow_verbosity='explain';
79 select @@session.log_slow_verbosity;
80 @@session.log_slow_verbosity
81 explain
82 set session log_slow_verbosity='innodb,query_plan,explain,engine,warnings,full';
83 select @@session.log_slow_verbosity;
84 @@session.log_slow_verbosity
85 innodb,query_plan,explain,engine,warnings,full
86 set session log_slow_verbosity='';
87 select @@session.log_slow_verbosity;
88 @@session.log_slow_verbosity
89
90 set session log_slow_verbosity=1.1;
91 ERROR 42000: Incorrect argument type to variable 'log_slow_verbosity'
92 set session log_slow_verbosity=1e1;
93 ERROR 42000: Incorrect argument type to variable 'log_slow_verbosity'
94 set session log_slow_verbosity="foo";
95 ERROR 42000: Variable 'log_slow_verbosity' can't be set to the value of 'foo'
96 set session log_slow_verbosity=64;
97 ERROR 42000: Variable 'log_slow_verbosity' can't be set to the value of '64'
98 SET @@global.log_slow_verbosity = @start_global_value;