Debian Codegraph @

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

raw
1 SET @start_value = @@global.slow_query_log;
2 SELECT @start_value;
3 @start_value
4 1
5 '#---------------------FN_DYNVARS_004_01-------------------------#'
6 SET @@global.slow_query_log = DEFAULT;
7 SELECT @@global.slow_query_log = 0;
8 @@global.slow_query_log = 0
9 1
10 '#--------------------FN_DYNVARS_004_02------------------------#'
11 SET @@global.slow_query_log = ON;
12 SELECT @@global.slow_query_log;
13 @@global.slow_query_log
14 1
15 SET @@global.slow_query_log = OFF;
16 SELECT @@global.slow_query_log;
17 @@global.slow_query_log
18 0
19 '#--------------------FN_DYNVARS_004_03-------------------------#'
20 SET @@global.slow_query_log = 2;
21 ERROR 42000: Variable 'slow_query_log' can't be set to the value of '2'
22 SET @@global.slow_query_log = -1;
23 ERROR 42000: Variable 'slow_query_log' can't be set to the value of '-1'
24 SET @@global.slow_query_log = TRUEF;
25 ERROR 42000: Variable 'slow_query_log' can't be set to the value of 'TRUEF'
26 SET @@global.slow_query_log = TRUE_F;
27 ERROR 42000: Variable 'slow_query_log' can't be set to the value of 'TRUE_F'
28 SET @@global.slow_query_log = FALSE0;
29 ERROR 42000: Variable 'slow_query_log' can't be set to the value of 'FALSE0'
30 SET @@global.slow_query_log = OON;
31 ERROR 42000: Variable 'slow_query_log' can't be set to the value of 'OON'
32 SET @@global.slow_query_log = ONN;
33 ERROR 42000: Variable 'slow_query_log' can't be set to the value of 'ONN'
34 SET @@global.slow_query_log = OOFF;
35 ERROR 42000: Variable 'slow_query_log' can't be set to the value of 'OOFF'
36 SET @@global.slow_query_log = 0FF;
37 ERROR 42000: Variable 'slow_query_log' can't be set to the value of '0FF'
38 SET @@global.slow_query_log = ' ';
39 ERROR 42000: Variable 'slow_query_log' can't be set to the value of ' '
40 SET @@global.slow_query_log = " ";
41 ERROR 42000: Variable 'slow_query_log' can't be set to the value of ' '
42 SET @@global.slow_query_log = '';
43 ERROR 42000: Variable 'slow_query_log' can't be set to the value of ''
44 '#-------------------FN_DYNVARS_004_04----------------------------#'
45 SET @@session.slow_query_log = OFF;
46 ERROR HY000: Variable 'slow_query_log' is a GLOBAL variable and should be set with SET GLOBAL
47 SELECT @@session.slow_query_log;
48 ERROR HY000: Variable 'slow_query_log' is a GLOBAL variable
49 '#----------------------FN_DYNVARS_004_05------------------------#'
50 SELECT IF(@@global.slow_query_log, "ON", "OFF") = VARIABLE_VALUE
51 FROM performance_schema.global_variables
52 WHERE VARIABLE_NAME='slow_query_log';
53 IF(@@global.slow_query_log, "ON", "OFF") = VARIABLE_VALUE
54 1
55 '#---------------------FN_DYNVARS_004_06----------------------#'
56 SET @@global.slow_query_log = 0;
57 SELECT @@global.slow_query_log;
58 @@global.slow_query_log
59 0
60 SET @@global.slow_query_log = 1;
61 SELECT @@global.slow_query_log;
62 @@global.slow_query_log
63 1
64 '#---------------------FN_DYNVARS_004_07----------------------#'
65 SET @@global.slow_query_log = TRUE;
66 SELECT @@global.slow_query_log;
67 @@global.slow_query_log
68 1
69 SET @@global.slow_query_log = FALSE;
70 SELECT @@global.slow_query_log;
71 @@global.slow_query_log
72 0
73 '#---------------------FN_DYNVARS_004_08----------------------#'
74 SET @@global.slow_query_log = ON;
75 SELECT @@slow_query_log = @@global.slow_query_log;
76 @@slow_query_log = @@global.slow_query_log
77 1
78 '#---------------------FN_DYNVARS_004_09----------------------#'
79 SET slow_query_log = ON;
80 ERROR HY000: Variable 'slow_query_log' is a GLOBAL variable and should be set with SET GLOBAL
81 SET local.slow_query_log = OFF;
82 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.slow_query_log = OFF' at line 1
83 SELECT local.slow_query_log;
84 ERROR 42S02: Unknown table 'local' in field list
85 SET global.slow_query_log = ON;
86 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.slow_query_log = ON' at line 1
87 SELECT global.slow_query_log;
88 ERROR 42S02: Unknown table 'global' in field list
89 SELECT slow_query_log;
90 ERROR 42S22: Unknown column 'slow_query_log' in 'field list'
91 SELECT @@session.slow_query_log;
92 ERROR HY000: Variable 'slow_query_log' is a GLOBAL variable
93 SET @@global.slow_query_log = @start_value;
94 SELECT @@global.slow_query_log;
95 @@global.slow_query_log
96 1