Debian Codegraph @

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

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