Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.keep_files_on_create;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 SET @start_session_value = @@session.keep_files_on_create;
6 SELECT @start_session_value;
7 @start_session_value
8 0
9 '#--------------------FN_DYNVARS_054_01-------------------------#'
10 SET @@global.keep_files_on_create = ON;
11 Warnings:
12 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
13 SET @@global.keep_files_on_create = DEFAULT;
14 Warnings:
15 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
16 SELECT @@global.keep_files_on_create;
17 @@global.keep_files_on_create
18 0
19 SET @@session.keep_files_on_create = ON;
20 Warnings:
21 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
22 SET @@session.keep_files_on_create = DEFAULT;
23 Warnings:
24 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
25 SELECT @@session.keep_files_on_create;
26 @@session.keep_files_on_create
27 0
28 '#--------------------FN_DYNVARS_054_02-------------------------#'
29 SET @@global.keep_files_on_create = DEFAULT;
30 Warnings:
31 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
32 SELECT @@global.keep_files_on_create = 'OFF';
33 @@global.keep_files_on_create = 'OFF'
34 1
35 Warnings:
36 Warning 1292 Truncated incorrect DECIMAL value: 'OFF'
37 SET @@session.keep_files_on_create = DEFAULT;
38 Warnings:
39 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
40 SELECT @@session.keep_files_on_create = 'OFF';
41 @@session.keep_files_on_create = 'OFF'
42 1
43 Warnings:
44 Warning 1292 Truncated incorrect DECIMAL value: 'OFF'
45 '#--------------------FN_DYNVARS_054_03-------------------------#'
46 SET @@global.keep_files_on_create = ON;
47 Warnings:
48 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
49 SELECT @@global.keep_files_on_create;
50 @@global.keep_files_on_create
51 1
52 SET @@global.keep_files_on_create = OFF;
53 Warnings:
54 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
55 SELECT @@global.keep_files_on_create;
56 @@global.keep_files_on_create
57 0
58 SET @@global.keep_files_on_create = 0;
59 Warnings:
60 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
61 SELECT @@global.keep_files_on_create;
62 @@global.keep_files_on_create
63 0
64 SET @@global.keep_files_on_create = 1;
65 Warnings:
66 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
67 SELECT @@global.keep_files_on_create;
68 @@global.keep_files_on_create
69 1
70 SET @@global.keep_files_on_create = TRUE;
71 Warnings:
72 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
73 SELECT @@global.keep_files_on_create;
74 @@global.keep_files_on_create
75 1
76 SET @@global.keep_files_on_create = FALSE;
77 Warnings:
78 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
79 SELECT @@global.keep_files_on_create;
80 @@global.keep_files_on_create
81 0
82 '#--------------------FN_DYNVARS_054_04-------------------------#'
83 SET @@session.keep_files_on_create = ON;
84 Warnings:
85 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
86 SELECT @@session.keep_files_on_create;
87 @@session.keep_files_on_create
88 1
89 SET @@session.keep_files_on_create = OFF;
90 Warnings:
91 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
92 SELECT @@session.keep_files_on_create;
93 @@session.keep_files_on_create
94 0
95 SET @@session.keep_files_on_create = 0;
96 Warnings:
97 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
98 SELECT @@session.keep_files_on_create;
99 @@session.keep_files_on_create
100 0
101 SET @@session.keep_files_on_create = 1;
102 Warnings:
103 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
104 SELECT @@session.keep_files_on_create;
105 @@session.keep_files_on_create
106 1
107 SET @@session.keep_files_on_create = TRUE;
108 Warnings:
109 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
110 SELECT @@session.keep_files_on_create;
111 @@session.keep_files_on_create
112 1
113 SET @@session.keep_files_on_create = FALSE;
114 Warnings:
115 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
116 SELECT @@session.keep_files_on_create;
117 @@session.keep_files_on_create
118 0
119 '#------------------FN_DYNVARS_054_05-----------------------#'
120 SET @@global.keep_files_on_create = 'ONN';
121 ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'ONN'
122 SET @@global.keep_files_on_create = "OFFF";
123 ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'OFFF'
124 SET @@global.keep_files_on_create = TTRUE;
125 ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'TTRUE'
126 SET @@global.keep_files_on_create = FELSE;
127 ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'FELSE'
128 SET @@global.keep_files_on_create = -1024;
129 ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of '-1024'
130 SET @@global.keep_files_on_create = 65536;
131 ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of '65536'
132 SET @@global.keep_files_on_create = 65530.34;
133 ERROR 42000: Incorrect argument type to variable 'keep_files_on_create'
134 SET @@global.keep_files_on_create = test;
135 ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'test'
136 SET @@session.keep_files_on_create = ONN;
137 ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'ONN'
138 SET @@session.keep_files_on_create = ONF;
139 ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'ONF'
140 SET @@session.keep_files_on_create = OF;
141 ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'OF'
142 SET @@session.keep_files_on_create = 'OFN';
143 ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'OFN'
144 SET @@session.keep_files_on_create = -2;
145 ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of '-2'
146 SET @@session.keep_files_on_create = 65530.34;
147 ERROR 42000: Incorrect argument type to variable 'keep_files_on_create'
148 SET @@session.keep_files_on_create = 65550;
149 ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of '65550'
150 SET @@session.keep_files_on_create = test;
151 ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'test'
152 SELECT @@session.keep_files_on_create;
153 @@session.keep_files_on_create
154 0
155 '#------------------FN_DYNVARS_054_06-----------------------#'
156 SELECT IF(@@global.keep_files_on_create, "ON", "OFF") = VARIABLE_VALUE
157 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
158 WHERE VARIABLE_NAME='keep_files_on_create';
159 IF(@@global.keep_files_on_create, "ON", "OFF") = VARIABLE_VALUE
160 1
161 '#------------------FN_DYNVARS_054_07-----------------------#'
162 SELECT IF(@@session.keep_files_on_create, "ON", "OFF") = VARIABLE_VALUE
163 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
164 WHERE VARIABLE_NAME='keep_files_on_create';
165 IF(@@session.keep_files_on_create, "ON", "OFF") = VARIABLE_VALUE
166 1
167 '#---------------------FN_DYNVARS_001_08----------------------#'
168 SET @@keep_files_on_create = OFF;
169 Warnings:
170 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
171 SET @@global.keep_files_on_create = ON;
172 Warnings:
173 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
174 SELECT @@keep_files_on_create = @@global.keep_files_on_create;
175 @@keep_files_on_create = @@global.keep_files_on_create
176 0
177 '#---------------------FN_DYNVARS_001_09----------------------#'
178 SET @@keep_files_on_create = ON;
179 Warnings:
180 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
181 SELECT @@keep_files_on_create = @@local.keep_files_on_create;
182 @@keep_files_on_create = @@local.keep_files_on_create
183 1
184 SELECT @@local.keep_files_on_create = @@session.keep_files_on_create;
185 @@local.keep_files_on_create = @@session.keep_files_on_create
186 1
187 '#---------------------FN_DYNVARS_001_10----------------------#'
188 SET keep_files_on_create = 1;
189 Warnings:
190 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
191 SELECT @@keep_files_on_create;
192 @@keep_files_on_create
193 1
194 SELECT local.keep_files_on_create;
195 ERROR 42S02: Unknown table 'local' in SELECT
196 SELECT session.keep_files_on_create;
197 ERROR 42S02: Unknown table 'session' in SELECT
198 SELECT keep_files_on_create = @@session.keep_files_on_create;
199 ERROR 42S22: Unknown column 'keep_files_on_create' in 'SELECT'
200 SET @@global.keep_files_on_create = @start_global_value;
201 Warnings:
202 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
203 SELECT @@global.keep_files_on_create;
204 @@global.keep_files_on_create
205 0
206 SET @@session.keep_files_on_create = @start_session_value;
207 Warnings:
208 Warning 1287 '@@keep_files_on_create' is deprecated and will be removed in a future release
209 SELECT @@session.keep_files_on_create;
210 @@session.keep_files_on_create
211 0