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