1SET @start_value = @@global.relay_log_purge;
2SELECT @start_value;
3@start_value
41
5'#--------------------FN_DYNVARS_141_01------------------------#'
6SET @@global.relay_log_purge = FALSE;
7SET @@global.relay_log_purge = DEFAULT;
8SELECT @@global.relay_log_purge;
9@@global.relay_log_purge
101
11'#---------------------FN_DYNVARS_141_02-------------------------#'
12SET @@global.relay_log_purge = @start_value;
13SELECT @@global.relay_log_purge = TRUE;
14@@global.relay_log_purge = TRUE
151
16'#--------------------FN_DYNVARS_141_03------------------------#'
17SET @@global.relay_log_purge = ON;
18SELECT @@global.relay_log_purge;
19@@global.relay_log_purge
201
21SET @@global.relay_log_purge = OFF;
22SELECT @@global.relay_log_purge;
23@@global.relay_log_purge
240
25SET @@global.relay_log_purge = 0;
26SELECT @@global.relay_log_purge;
27@@global.relay_log_purge
280
29SET @@global.relay_log_purge = 1;
30SELECT @@global.relay_log_purge;
31@@global.relay_log_purge
321
33SET @@global.relay_log_purge = TRUE;
34SELECT @@global.relay_log_purge;
35@@global.relay_log_purge
361
37SET @@global.relay_log_purge = FALSE;
38SELECT @@global.relay_log_purge;
39@@global.relay_log_purge
400
41'#--------------------FN_DYNVARS_141_04-------------------------#'
42SET @@global.relay_log_purge = 2;
43ERROR 42000: Variable 'relay_log_purge' can't be set to the value of '2'
44SET @@global.relay_log_purge = -1;
45ERROR 42000: Variable 'relay_log_purge' can't be set to the value of '-1'
46SET @@global.relay_log_purge = TRUEF;
47ERROR 42000: Variable 'relay_log_purge' can't be set to the value of 'TRUEF'
48SET @@global.relay_log_purge = TRUE_F;
49ERROR 42000: Variable 'relay_log_purge' can't be set to the value of 'TRUE_F'
50SET @@global.relay_log_purge = FALSE0;
51ERROR 42000: Variable 'relay_log_purge' can't be set to the value of 'FALSE0'
52SET @@global.relay_log_purge = OON;
53ERROR 42000: Variable 'relay_log_purge' can't be set to the value of 'OON'
54SET @@global.relay_log_purge = ONN;
55ERROR 42000: Variable 'relay_log_purge' can't be set to the value of 'ONN'
56SET @@global.relay_log_purge = OOFF;
57ERROR 42000: Variable 'relay_log_purge' can't be set to the value of 'OOFF'
58SET @@global.relay_log_purge = 0FF;
59ERROR 42000: Variable 'relay_log_purge' can't be set to the value of '0FF'
60SET @@global.relay_log_purge = ' ';
61ERROR 42000: Variable 'relay_log_purge' can't be set to the value of ' '
62SET @@global.relay_log_purge = " ";
63ERROR 42000: Variable 'relay_log_purge' can't be set to the value of ' '
64SET @@global.relay_log_purge = '';
65ERROR 42000: Variable 'relay_log_purge' can't be set to the value of ''
66'#-------------------FN_DYNVARS_141_05----------------------------#'
67SET @@session.relay_log_purge = 1;
68ERROR HY000: Variable 'relay_log_purge' is a GLOBAL variable and should be set with SET GLOBAL
69SELECT @@session.relay_log_purge;
70ERROR HY000: Variable 'relay_log_purge' is a GLOBAL variable
71'#----------------------FN_DYNVARS_141_06------------------------#'
72SELECT IF(@@global.relay_log_purge, "ON", "OFF") = VARIABLE_VALUE
73FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
74WHERE VARIABLE_NAME='relay_log_purge';
75IF(@@global.relay_log_purge, "ON", "OFF") = VARIABLE_VALUE
761
77'#---------------------FN_DYNVARS_141_07----------------------#'
78SET @@global.relay_log_purge = 1;
79SELECT @@relay_log_purge = @@global.relay_log_purge;
80@@relay_log_purge = @@global.relay_log_purge
811
82'#---------------------FN_DYNVARS_141_08----------------------#'
83SET relay_log_purge = 1;
84ERROR HY000: Variable 'relay_log_purge' is a GLOBAL variable and should be set with SET GLOBAL
85SELECT global.relay_log_purge;
86ERROR 42S02: Unknown table 'global' in field list
87SELECT relay_log_purge = @@session.relay_log_purge;
88ERROR 42S22: Unknown column 'relay_log_purge' in 'field list'
89SET @@global.relay_log_purge = @start_value;
90SELECT @@global.relay_log_purge;
91@@global.relay_log_purge
921
93