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 field list
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 '#--------------------FN_DYNVARS_042_04-------------------------#'
37 SET @@global.innodb_fast_shutdown = -1;
38 Warnings:
39 Warning 1292 Truncated incorrect innodb_fast_shutdown value: '-1'
40 SELECT @@global.innodb_fast_shutdown;
41 @@global.innodb_fast_shutdown
42 0
43 SET @@global.innodb_fast_shutdown = TRU;
44 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
45 SELECT @@global.innodb_fast_shutdown;
46 @@global.innodb_fast_shutdown
47 0
48 SET @@global.innodb_fast_shutdown = TRUE_F;
49 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
50 SELECT @@global.innodb_fast_shutdown;
51 @@global.innodb_fast_shutdown
52 0
53 SET @@global.innodb_fast_shutdown = FALS;
54 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
55 SELECT @@global.innodb_fast_shutdown;
56 @@global.innodb_fast_shutdown
57 0
58 SET @@global.innodb_fast_shutdown = OON;
59 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
60 SELECT @@global.innodb_fast_shutdown;
61 @@global.innodb_fast_shutdown
62 0
63 SET @@global.innodb_fast_shutdown = ONN;
64 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
65 SELECT @@global.innodb_fast_shutdown;
66 @@global.innodb_fast_shutdown
67 0
68 SET @@global.innodb_fast_shutdown = OOFF;
69 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
70 SELECT @@global.innodb_fast_shutdown;
71 @@global.innodb_fast_shutdown
72 0
73 SET @@global.innodb_fast_shutdown = 0FF;
74 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
75 SELECT @@global.innodb_fast_shutdown;
76 @@global.innodb_fast_shutdown
77 0
78 SET @@global.innodb_fast_shutdown = '1';
79 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
80 SELECT @@global.innodb_fast_shutdown;
81 @@global.innodb_fast_shutdown
82 0
83 SET @@global.innodb_fast_shutdown = "0";
84 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
85 SELECT @@global.innodb_fast_shutdown;
86 @@global.innodb_fast_shutdown
87 0
88 SET @@global.innodb_fast_shutdown = 1.1;
89 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
90 SELECT @@global.innodb_fast_shutdown;
91 @@global.innodb_fast_shutdown
92 0
93 SET @@global.innodb_fast_shutdown = ' ';
94 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
95 SELECT @@global.innodb_fast_shutdown;
96 @@global.innodb_fast_shutdown
97 0
98 SET @@global.innodb_fast_shutdown = " ";
99 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
100 SELECT @@global.innodb_fast_shutdown;
101 @@global.innodb_fast_shutdown
102 0
103 '#-------------------FN_DYNVARS_042_05----------------------------#'
104 SET @@session.innodb_fast_shutdown = 0;
105 ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL
106 SET @@innodb_fast_shutdown = 0;
107 ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL
108 SET @@local.innodb_fast_shutdown = 0;
109 ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL
110 '#----------------------FN_DYNVARS_042_06------------------------#'
111 SELECT count(VARIABLE_VALUE) AS res_is_0
112 FROM performance_schema.session_variables
113 WHERE VARIABLE_NAME='innodb_fast_shutdown';
114 res_is_0
115 1
116 '#----------------------FN_DYNVARS_042_07------------------------#'
117 SELECT @@global.innodb_fast_shutdown =
118 VARIABLE_VALUE FROM performance_schema.global_variables
119 WHERE VARIABLE_NAME='innodb_fast_shutdown';
120 @@global.innodb_fast_shutdown =
121 VARIABLE_VALUE
122 1
123 '#---------------------FN_DYNVARS_042_08-------------------------#'
124 SET @@global.innodb_fast_shutdown = OFF;
125 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
126 SELECT @@global.innodb_fast_shutdown;
127 @@global.innodb_fast_shutdown
128 0
129 SET @@global.innodb_fast_shutdown = ON;
130 ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
131 SELECT @@global.innodb_fast_shutdown;
132 @@global.innodb_fast_shutdown
133 0
134 '#---------------------FN_DYNVARS_042_09----------------------#'
135 SET @@global.innodb_fast_shutdown = TRUE;
136 SELECT @@global.innodb_fast_shutdown;
137 @@global.innodb_fast_shutdown
138 1
139 SET @@global.innodb_fast_shutdown = FALSE;
140 SELECT @@global.innodb_fast_shutdown;
141 @@global.innodb_fast_shutdown
142 0
143 SET @@global.innodb_fast_shutdown = @global_start_value;
144 SELECT @@global.innodb_fast_shutdown;
145 @@global.innodb_fast_shutdown
146 1