1SET @global_start_value = @@global.innodb_fast_shutdown;
2SELECT @@global.innodb_fast_shutdown;
3@@global.innodb_fast_shutdown
41
5'#--------------------FN_DYNVARS_042_01------------------------#'
6SET @@global.innodb_fast_shutdown = 0;
7SET @@global.innodb_fast_shutdown = DEFAULT;
8SELECT @@global.innodb_fast_shutdown;
9@@global.innodb_fast_shutdown
101
11'#---------------------FN_DYNVARS_042_02-------------------------#'
12SET innodb_fast_shutdown = 1;
13ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL
14SELECT @@innodb_fast_shutdown;
15@@innodb_fast_shutdown
161
17SELECT global.innodb_fast_shutdown;
18ERROR 42S02: Unknown table 'global' in field list
19SET global innodb_fast_shutdown = 1;
20SELECT @@global.innodb_fast_shutdown;
21@@global.innodb_fast_shutdown
221
23'#--------------------FN_DYNVARS_042_03------------------------#'
24SET @@global.innodb_fast_shutdown = 0;
25SELECT @@global.innodb_fast_shutdown;
26@@global.innodb_fast_shutdown
270
28SET @@global.innodb_fast_shutdown = 1;
29SELECT @@global.innodb_fast_shutdown;
30@@global.innodb_fast_shutdown
311
32SET @@global.innodb_fast_shutdown = 2;
33SELECT @@global.innodb_fast_shutdown;
34@@global.innodb_fast_shutdown
352
36'#--------------------FN_DYNVARS_042_04-------------------------#'
37SET @@global.innodb_fast_shutdown = -1;
38Warnings:
39Warning	1292	Truncated incorrect innodb_fast_shutdown value: '-1'
40SELECT @@global.innodb_fast_shutdown;
41@@global.innodb_fast_shutdown
420
43SET @@global.innodb_fast_shutdown = TRU;
44ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
45SELECT @@global.innodb_fast_shutdown;
46@@global.innodb_fast_shutdown
470
48SET @@global.innodb_fast_shutdown = TRUE_F;
49ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
50SELECT @@global.innodb_fast_shutdown;
51@@global.innodb_fast_shutdown
520
53SET @@global.innodb_fast_shutdown = FALS;
54ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
55SELECT @@global.innodb_fast_shutdown;
56@@global.innodb_fast_shutdown
570
58SET @@global.innodb_fast_shutdown = OON;
59ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
60SELECT @@global.innodb_fast_shutdown;
61@@global.innodb_fast_shutdown
620
63SET @@global.innodb_fast_shutdown = ONN;
64ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
65SELECT @@global.innodb_fast_shutdown;
66@@global.innodb_fast_shutdown
670
68SET @@global.innodb_fast_shutdown = OOFF;
69ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
70SELECT @@global.innodb_fast_shutdown;
71@@global.innodb_fast_shutdown
720
73SET @@global.innodb_fast_shutdown = 0FF;
74ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
75SELECT @@global.innodb_fast_shutdown;
76@@global.innodb_fast_shutdown
770
78SET @@global.innodb_fast_shutdown = '1';
79ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
80SELECT @@global.innodb_fast_shutdown;
81@@global.innodb_fast_shutdown
820
83SET @@global.innodb_fast_shutdown = "0";
84ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
85SELECT @@global.innodb_fast_shutdown;
86@@global.innodb_fast_shutdown
870
88SET @@global.innodb_fast_shutdown = 1.1;
89ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
90SELECT @@global.innodb_fast_shutdown;
91@@global.innodb_fast_shutdown
920
93SET @@global.innodb_fast_shutdown = ' ';
94ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
95SELECT @@global.innodb_fast_shutdown;
96@@global.innodb_fast_shutdown
970
98SET @@global.innodb_fast_shutdown = " ";
99ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
100SELECT @@global.innodb_fast_shutdown;
101@@global.innodb_fast_shutdown
1020
103'#-------------------FN_DYNVARS_042_05----------------------------#'
104SET @@session.innodb_fast_shutdown = 0;
105ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL
106SET @@innodb_fast_shutdown = 0;
107ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL
108SET @@local.innodb_fast_shutdown = 0;
109ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL
110'#----------------------FN_DYNVARS_042_06------------------------#'
111SELECT count(VARIABLE_VALUE) AS res_is_0
112FROM INFORMATION_SCHEMA.SESSION_VARIABLES
113WHERE VARIABLE_NAME='innodb_fast_shutdown';
114res_is_0
1151
116'#----------------------FN_DYNVARS_042_07------------------------#'
117SELECT @@global.innodb_fast_shutdown =
118VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
119WHERE VARIABLE_NAME='innodb_fast_shutdown';
120@@global.innodb_fast_shutdown =
121VARIABLE_VALUE
1221
123'#---------------------FN_DYNVARS_042_08-------------------------#'
124SET @@global.innodb_fast_shutdown = OFF;
125ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
126SELECT @@global.innodb_fast_shutdown;
127@@global.innodb_fast_shutdown
1280
129SET @@global.innodb_fast_shutdown = ON;
130ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
131SELECT @@global.innodb_fast_shutdown;
132@@global.innodb_fast_shutdown
1330
134'#---------------------FN_DYNVARS_042_09----------------------#'
135SET @@global.innodb_fast_shutdown = TRUE;
136SELECT @@global.innodb_fast_shutdown;
137@@global.innodb_fast_shutdown
1381
139SET @@global.innodb_fast_shutdown = FALSE;
140SELECT @@global.innodb_fast_shutdown;
141@@global.innodb_fast_shutdown
1420
143SET @@global.innodb_fast_shutdown = @global_start_value;
144SELECT @@global.innodb_fast_shutdown;
145@@global.innodb_fast_shutdown
1461
147