1SET @start_value = @@global.flush;
2SELECT @start_value;
3@start_value
40
5'#--------------------FN_DYNVARS_030_01------------------------#'
6SET @@global.flush = ON;
7SET @@global.flush = DEFAULT;
8SELECT @@global.flush;
9@@global.flush
100
11'#---------------------FN_DYNVARS_030_02-------------------------#'
12SET @@global.flush = @start_value;
13SELECT @@global.flush;
14@@global.flush
150
16'#--------------------FN_DYNVARS_030_03------------------------#'
17SET @@global.flush = ON;
18SELECT @@global.flush;
19@@global.flush
201
21SET @@global.flush = OFF;
22SELECT @@global.flush;
23@@global.flush
240
25SET @@global.flush = 0;
26SELECT @@global.flush;
27@@global.flush
280
29SET @@global.flush = 1;
30SELECT @@global.flush;
31@@global.flush
321
33'#--------------------FN_DYNVARS_030_04-------------------------#'
34SET @@global.flush = 2;
35ERROR 42000: Variable 'flush' can't be set to the value of '2'
36SET @@global.flush = -1;
37ERROR 42000: Variable 'flush' can't be set to the value of '-1'
38SET @@global.flush = TRUEF;
39ERROR 42000: Variable 'flush' can't be set to the value of 'TRUEF'
40SET @@global.flush = TRUE_F;
41ERROR 42000: Variable 'flush' can't be set to the value of 'TRUE_F'
42SET @@global.flush = FALSE0;
43ERROR 42000: Variable 'flush' can't be set to the value of 'FALSE0'
44SET @@global.flush = OON;
45ERROR 42000: Variable 'flush' can't be set to the value of 'OON'
46SET @@global.flush = ONN;
47ERROR 42000: Variable 'flush' can't be set to the value of 'ONN'
48SET @@global.flush = OOFF;
49ERROR 42000: Variable 'flush' can't be set to the value of 'OOFF'
50SET @@global.flush = 0FF;
51ERROR 42000: Variable 'flush' can't be set to the value of '0FF'
52SET @@global.flush = ' ';
53ERROR 42000: Variable 'flush' can't be set to the value of ' '
54SET @@global.flush = " ";
55ERROR 42000: Variable 'flush' can't be set to the value of ' '
56SET @@global.flush = '';
57ERROR 42000: Variable 'flush' can't be set to the value of ''
58'#-------------------FN_DYNVARS_030_05----------------------------#'
59SET @@session.flush = 1;
60ERROR HY000: Variable 'flush' is a GLOBAL variable and should be set with SET GLOBAL
61SELECT @@session.flush;
62ERROR HY000: Variable 'flush' is a GLOBAL variable
63'#----------------------FN_DYNVARS_030_06------------------------#'
64SELECT IF(@@global.flush, "ON", "OFF") = VARIABLE_VALUE
65FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
66WHERE VARIABLE_NAME='flush';
67IF(@@global.flush, "ON", "OFF") = VARIABLE_VALUE
681
69'#---------------------FN_DYNVARS_030_07----------------------#'
70SET @@global.flush = TRUE;
71SELECT @@global.flush;
72@@global.flush
731
74SET @@global.flush = FALSE;
75SELECT @@global.flush;
76@@global.flush
770
78'#---------------------FN_DYNVARS_030_08----------------------#'
79SET @@global.flush = 1;
80SELECT @@flush = @@global.flush;
81@@flush = @@global.flush
821
83'#---------------------FN_DYNVARS_030_09----------------------#'
84SET flush = 1;
85ERROR HY000: Variable 'flush' is a GLOBAL variable and should be set with SET GLOBAL
86SET global.flush = 1;
87ERROR 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 'flush = 1' at line 1
88SELECT global.flush;
89ERROR 42S02: Unknown table 'global' in field list
90SELECT flush = @@session.flush;
91ERROR 42S22: Unknown column 'flush' in 'field list'
92SET @@global.flush = @start_value;
93SELECT @@global.flush;
94@@global.flush
950
96