Debian Codegraph @

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

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