Debian Codegraph @

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

raw
1 --echo # WL#12393: Logging: Add new command line option for richer slow query logging
2 --echo
3 --echo # test global variable "log_slow_extra"
4 --echo
5
6 SELECT @@global.log_slow_extra INTO @old_lse;
7 SELECT @@global.log_output INTO @old_lo;
8 SELECT @@global.slow_query_log INTO @old_sql;
9
10 --echo # invalid values / types
11
12 --error ER_WRONG_VALUE_FOR_VAR
13 SET GLOBAL log_slow_extra=symbol;
14
15 --error ER_WRONG_VALUE_FOR_VAR
16 SET GLOBAL log_slow_extra="string";
17
18 --error ER_WRONG_VALUE_FOR_VAR
19 SET GLOBAL log_slow_extra=99;
20
21 --error ER_WRONG_TYPE_FOR_VAR
22 SET GLOBAL log_slow_extra=0.5;
23
24 --echo
25 --echo # only GLOBAL scope is valid
26
27 --error ER_GLOBAL_VARIABLE
28 SET SESSION log_slow_extra=0;
29
30 --echo
31
32 --echo # valid values
33 SET GLOBAL slow_query_log=0;
34
35 SET GLOBAL log_slow_extra=0;
36 SELECT @@global.log_slow_extra;
37
38 SET GLOBAL log_slow_extra=1;
39 SELECT @@global.log_slow_extra;
40
41 SET GLOBAL log_slow_extra=DEFAULT;
42 SELECT @@global.log_slow_extra;
43
44 --echo
45
46 --echo # warnings and errors
47
48 SET GLOBAL slow_query_log=1;
49 --echo
50
51 --echo # Switching slow query log file format while target is not FILE is legal,
52 --echo # but does nothing. Throw a warning!
53 SET GLOBAL log_output="TABLE";
54 SELECT @@global.log_slow_extra INTO @old;
55 SET GLOBAL log_slow_extra=1;
56 --echo # Value must have changed:
57 SELECT @@global.log_slow_extra!=@old;
58 SET GLOBAL log_slow_extra=DEFAULT;
59 --echo
60
61 --echo # Switching slow query log file format while target is not FILE is legal,
62 --echo # but does nothing. Throw a warning!
63 SET GLOBAL log_output="NONE";
64 SELECT @@global.log_slow_extra INTO @old;
65 SET GLOBAL log_slow_extra=1;
66 --echo # Value must have changed:
67 SELECT @@global.log_slow_extra!=@old;
68 SET GLOBAL log_slow_extra=DEFAULT;
69 --echo
70
71 --echo # clean up
72 SET GLOBAL log_slow_extra=@old_lse;
73 SET GLOBAL log_output=@old_lo;
74 SET GLOBAL slow_query_log=@old_sql;
75 TRUNCATE TABLE mysql.general_log;
76 TRUNCATE TABLE mysql.slow_log;
77
78 --echo
79
80 --echo # READY