Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.innodb_fast_shutdown;
2 SELECT @@global.innodb_fast_shutdown;
3 @@global.innodb_fast_shutdown
4 1
5 '#--------------------FN_DYNVARS_042_01------------------------#'
6 SET @@global.innodb_fast_shutdown = 0;
7 SET @@global.innodb_fast_shutdown = DEFAULT;
8 SELECT @@global.innodb_fast_shutdown;
9 @@global.innodb_fast_shutdown
10 1
11 '#---------------------FN_DYNVARS_042_02-------------------------#'
12 SET innodb_fast_shutdown = 1;
13 ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL
14 SELECT @@innodb_fast_shutdown;
15 @@innodb_fast_shutdown
16 1
17 SELECT global.innodb_fast_shutdown;
18 ERROR 42S02: Unknown table 'global' in SELECT
19 SET global innodb_fast_shutdown = 1;
20 SELECT @@global.innodb_fast_shutdown;
21 @@global.innodb_fast_shutdown
22 1
23 '#--------------------FN_DYNVARS_042_03------------------------#'
24 SET @@global.innodb_fast_shutdown = 0;
25 SELECT @@global.innodb_fast_shutdown;
26 @@global.innodb_fast_shutdown
27 0
28 SET @@global.innodb_fast_shutdown = 1;
29 SELECT @@global.innodb_fast_shutdown;
30 @@global.innodb_fast_shutdown
31 1
32 SET @@global.innodb_fast_shutdown = 2;
33 SELECT @@global.innodb_fast_shutdown;
34 @@global.innodb_fast_shutdown
35 2
36 SET @@global.innodb_fast_shutdown = 3;
37 SELECT @@global.innodb_fast_shutdown;
38 @@global.innodb_fast_shutdown
39 3
40 '#--------------------FN_DYNVARS_042_04-------------------------#'
41 SET @@global.innodb_fast_shutdown = -1;
42 Warnings:
43 Warning 1292 Truncated incorrect innodb_fast_shutdown value: '-1'
44 SELECT @@global.innodb_fast_shutdown;
45 @@global.innodb_fast_shutdown
46 0
47 SET @@global.innodb_fast_shutdown = TRU;
48 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
49 SELECT @@global.innodb_fast_shutdown;
50 @@global.innodb_fast_shutdown
51 0
52 SET @@global.innodb_fast_shutdown = TRUE_F;
53 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
54 SELECT @@global.innodb_fast_shutdown;
55 @@global.innodb_fast_shutdown
56 0
57 SET @@global.innodb_fast_shutdown = FALS;
58 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
59 SELECT @@global.innodb_fast_shutdown;
60 @@global.innodb_fast_shutdown
61 0
62 SET @@global.innodb_fast_shutdown = OON;
63 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
64 SELECT @@global.innodb_fast_shutdown;
65 @@global.innodb_fast_shutdown
66 0
67 SET @@global.innodb_fast_shutdown = ONN;
68 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
69 SELECT @@global.innodb_fast_shutdown;
70 @@global.innodb_fast_shutdown
71 0
72 SET @@global.innodb_fast_shutdown = OOFF;
73 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
74 SELECT @@global.innodb_fast_shutdown;
75 @@global.innodb_fast_shutdown
76 0
77 SET @@global.innodb_fast_shutdown = 0FF;
78 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
79 SELECT @@global.innodb_fast_shutdown;
80 @@global.innodb_fast_shutdown
81 0
82 SET @@global.innodb_fast_shutdown = '1';
83 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
84 SELECT @@global.innodb_fast_shutdown;
85 @@global.innodb_fast_shutdown
86 0
87 SET @@global.innodb_fast_shutdown = "0";
88 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
89 SELECT @@global.innodb_fast_shutdown;
90 @@global.innodb_fast_shutdown
91 0
92 SET @@global.innodb_fast_shutdown = 1.1;
93 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
94 SELECT @@global.innodb_fast_shutdown;
95 @@global.innodb_fast_shutdown
96 0
97 SET @@global.innodb_fast_shutdown = ' ';
98 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
99 SELECT @@global.innodb_fast_shutdown;
100 @@global.innodb_fast_shutdown
101 0
102 SET @@global.innodb_fast_shutdown = " ";
103 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
104 SELECT @@global.innodb_fast_shutdown;
105 @@global.innodb_fast_shutdown
106 0
107 '#-------------------FN_DYNVARS_042_05----------------------------#'
108 SET @@session.innodb_fast_shutdown = 0;
109 ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL
110 SET @@innodb_fast_shutdown = 0;
111 ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL
112 SET @@local.innodb_fast_shutdown = 0;
113 ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL
114 '#----------------------FN_DYNVARS_042_06------------------------#'
115 SELECT count(VARIABLE_VALUE) AS res_is_0
116 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
117 WHERE VARIABLE_NAME='innodb_fast_shutdown';
118 res_is_0
119 1
120 '#----------------------FN_DYNVARS_042_07------------------------#'
121 SELECT @@global.innodb_fast_shutdown =
122 VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
123 WHERE VARIABLE_NAME='innodb_fast_shutdown';
124 @@global.innodb_fast_shutdown =
125 VARIABLE_VALUE
126 1
127 '#---------------------FN_DYNVARS_042_08-------------------------#'
128 SET @@global.innodb_fast_shutdown = OFF;
129 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
130 SELECT @@global.innodb_fast_shutdown;
131 @@global.innodb_fast_shutdown
132 0
133 SET @@global.innodb_fast_shutdown = ON;
134 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
135 SELECT @@global.innodb_fast_shutdown;
136 @@global.innodb_fast_shutdown
137 0
138 '#---------------------FN_DYNVARS_042_09----------------------#'
139 SET @@global.innodb_fast_shutdown = TRUE;
140 SELECT @@global.innodb_fast_shutdown;
141 @@global.innodb_fast_shutdown
142 1
143 SET @@global.innodb_fast_shutdown = FALSE;
144 SELECT @@global.innodb_fast_shutdown;
145 @@global.innodb_fast_shutdown
146 0
147 SET @@global.innodb_fast_shutdown = @global_start_value;
148 SELECT @@global.innodb_fast_shutdown;
149 @@global.innodb_fast_shutdown
150 1