Debian Codegraph @

mysql-test/suite/rpl/r/rpl_variables_stm_innodb.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
7 ==== Initialization ====
8 [on master]
9 SET @m_auto_increment_increment= @@global.auto_increment_increment;
10 SET @m_auto_increment_offset= @@global.auto_increment_offset;
11 SET @m_character_set_client= @@global.character_set_client;
12 SET @m_collation_connection= @@global.collation_connection;
13 SET @m_collation_server= @@global.collation_server;
14 SET @m_time_zone= @@global.time_zone;
15 SET @m_lc_time_names= @@global.lc_time_names;
16 SET @m_collation_database= @@global.collation_database;
17 [on slave]
18 SET @s_auto_increment_increment= @@global.auto_increment_increment;
19 SET @s_auto_increment_offset= @@global.auto_increment_offset;
20 SET @s_character_set_client= @@global.character_set_client;
21 SET @s_collation_connection= @@global.collation_connection;
22 SET @s_collation_server= @@global.collation_server;
23 SET @s_time_zone= @@global.time_zone;
24 SET @s_lc_time_names= @@global.lc_time_names;
25 SET @s_collation_database= @@global.collation_database;
26 SET @@global.auto_increment_increment=19;
27 SET @@global.auto_increment_offset=4;
28 SET @@global.character_set_client='latin2';
29 SET @@global.collation_connection='latin2_bin';
30 SET @@global.collation_server='geostd8_general_ci';
31 SET @@global.time_zone='Japan';
32 SET @@global.lc_time_names='sv_SE';
33 SET @@global.collation_database='geostd8_bin';
34 Warnings:
35 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
36 [on master]
37 CREATE TABLE tstmt (id INT AUTO_INCREMENT PRIMARY KEY,
38 num INT,
39 text VARCHAR(100)) ENGINE=INNODB;
40 CREATE TABLE tproc LIKE tstmt;
41 CREATE TABLE tfunc LIKE tstmt;
42 CREATE TABLE ttrig LIKE tstmt;
43 CREATE TABLE tprep LIKE tstmt;
44 CREATE TABLE trigger_table (text CHAR(4)) ENGINE=INNODB;
45 ==== Insert variables directly ====
46 SET @@pseudo_thread_id= 4712;
47 INSERT INTO tstmt(num) VALUES (@@session.pseudo_thread_id);
48 SET @@pseudo_thread_id= 4713;
49 INSERT INTO tstmt(num) VALUES (@@session.pseudo_thread_id);
50 SET @@foreign_key_checks= 0;
51 INSERT INTO tstmt(num) VALUES (@@session.foreign_key_checks);
52 SET @@foreign_key_checks= 1;
53 INSERT INTO tstmt(num) VALUES (@@session.foreign_key_checks);
54 SET @@sql_auto_is_null= 0;
55 INSERT INTO tstmt(num) VALUES (@@session.sql_auto_is_null);
56 SET @@sql_auto_is_null= 1;
57 INSERT INTO tstmt(num) VALUES (@@session.sql_auto_is_null);
58 SET @@unique_checks= 0;
59 INSERT INTO tstmt(num) VALUES (@@session.unique_checks);
60 SET @@unique_checks= 1;
61 INSERT INTO tstmt(num) VALUES (@@session.unique_checks);
62 SET @@auto_increment_increment= 11;
63 INSERT INTO tstmt(num) VALUES (@@session.auto_increment_increment);
64 SET @@auto_increment_increment= 19;
65 INSERT INTO tstmt(num) VALUES (@@session.auto_increment_increment);
66 SET @@auto_increment_offset= 13;
67 INSERT INTO tstmt(num) VALUES (@@session.auto_increment_offset);
68 SET @@auto_increment_offset= 17;
69 INSERT INTO tstmt(num) VALUES (@@session.auto_increment_offset);
70 SET @@auto_increment_increment= 1;
71 SET @@auto_increment_offset= 1;
72 SET @@character_set_client= 'cp1257';
73 INSERT INTO tstmt(text) VALUES (@@session.character_set_client);
74 SET @@character_set_client= 'cp1256';
75 INSERT INTO tstmt(text) VALUES (@@session.character_set_client);
76 SET @@collation_connection= 'cp1251_ukrainian_ci';
77 INSERT INTO tstmt(text) VALUES (@@session.collation_connection);
78 INSERT INTO tstmt(text) VALUES (@@session.character_set_connection);
79 SET @@collation_connection= 'cp1251_bulgarian_ci';
80 INSERT INTO tstmt(text) VALUES (@@session.collation_connection);
81 INSERT INTO tstmt(text) VALUES (@@session.character_set_connection);
82 SET @@collation_server= 'latin7_bin';
83 INSERT INTO tstmt(text) VALUES (@@session.collation_server);
84 INSERT INTO tstmt(text) VALUES (@@session.character_set_server);
85 SET @@collation_server= 'latin7_general_cs';
86 INSERT INTO tstmt(text) VALUES (@@session.collation_server);
87 INSERT INTO tstmt(text) VALUES (@@session.character_set_server);
88 SET @@time_zone= 'Europe/Moscow';
89 INSERT INTO tstmt(text) VALUES (@@session.time_zone);
90 SET @@time_zone= 'Universal';
91 INSERT INTO tstmt(text) VALUES (@@session.time_zone);
92 SET @@lc_time_names= 'sv_FI';
93 INSERT INTO tstmt(text) VALUES (@@session.lc_time_names);
94 SET @@lc_time_names= 'no_NO';
95 INSERT INTO tstmt(text) VALUES (@@session.lc_time_names);
96 SET @@collation_database= 'latin7_general_ci';
97 Warnings:
98 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
99 INSERT INTO tstmt(text) VALUES (@@session.collation_database);
100 INSERT INTO tstmt(text) VALUES (@@session.character_set_database);
101 SET @@collation_database= 'latin7_estonian_cs';
102 Warnings:
103 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
104 INSERT INTO tstmt(text) VALUES (@@session.collation_database);
105 INSERT INTO tstmt(text) VALUES (@@session.character_set_database);
106 SET @@timestamp= 47114711;
107 INSERT INTO tstmt(text) VALUES (@@session.timestamp);
108 SET @@timestamp= 47124712;
109 INSERT INTO tstmt(text) VALUES (@@session.timestamp);
110 SET @@last_insert_id= 1616;
111 INSERT INTO tstmt(text) VALUES (@@session.last_insert_id);
112 SET @@last_insert_id= 1717;
113 INSERT INTO tstmt(text) VALUES (@@session.last_insert_id);
114 ==== Insert variables from a stored procedure ====
115 CREATE PROCEDURE proc()
116 BEGIN
117 SET @@pseudo_thread_id= 4712;
118 INSERT INTO tproc(num) VALUES (@@session.pseudo_thread_id);
119 SET @@pseudo_thread_id= 4713;
120 INSERT INTO tproc(num) VALUES (@@session.pseudo_thread_id);
121 SET @@foreign_key_checks= 0;
122 INSERT INTO tproc(num) VALUES (@@session.foreign_key_checks);
123 SET @@foreign_key_checks= 1;
124 INSERT INTO tproc(num) VALUES (@@session.foreign_key_checks);
125 SET @@sql_auto_is_null= 0;
126 INSERT INTO tproc(num) VALUES (@@session.sql_auto_is_null);
127 SET @@sql_auto_is_null= 1;
128 INSERT INTO tproc(num) VALUES (@@session.sql_auto_is_null);
129 SET @@unique_checks= 0;
130 INSERT INTO tproc(num) VALUES (@@session.unique_checks);
131 SET @@unique_checks= 1;
132 INSERT INTO tproc(num) VALUES (@@session.unique_checks);
133 SET @@auto_increment_increment= 11;
134 INSERT INTO tproc(num) VALUES (@@session.auto_increment_increment);
135 SET @@auto_increment_increment= 19;
136 INSERT INTO tproc(num) VALUES (@@session.auto_increment_increment);
137 SET @@auto_increment_offset= 13;
138 INSERT INTO tproc(num) VALUES (@@session.auto_increment_offset);
139 SET @@auto_increment_offset= 17;
140 INSERT INTO tproc(num) VALUES (@@session.auto_increment_offset);
141 # reset these as they affect the index column
142 SET @@auto_increment_increment= 1;
143 SET @@auto_increment_offset= 1;
144 SET @@character_set_client= 'cp1257';
145 INSERT INTO tproc(text) VALUES (@@session.character_set_client);
146 SET @@character_set_client= 'cp1256';
147 INSERT INTO tproc(text) VALUES (@@session.character_set_client);
148 SET @@collation_connection= 'cp1251_ukrainian_ci';
149 INSERT INTO tproc(text) VALUES (@@session.collation_connection);
150 INSERT INTO tproc(text) VALUES (@@session.character_set_connection);
151 SET @@collation_connection= 'cp1251_bulgarian_ci';
152 INSERT INTO tproc(text) VALUES (@@session.collation_connection);
153 INSERT INTO tproc(text) VALUES (@@session.character_set_connection);
154 SET @@collation_server= 'latin7_bin';
155 INSERT INTO tproc(text) VALUES (@@session.collation_server);
156 INSERT INTO tproc(text) VALUES (@@session.character_set_server);
157 SET @@collation_server= 'latin7_general_cs';
158 INSERT INTO tproc(text) VALUES (@@session.collation_server);
159 INSERT INTO tproc(text) VALUES (@@session.character_set_server);
160 SET @@time_zone= 'Europe/Moscow';
161 INSERT INTO tproc(text) VALUES (@@session.time_zone);
162 SET @@time_zone= 'Universal';
163 INSERT INTO tproc(text) VALUES (@@session.time_zone);
164 SET @@lc_time_names= 'sv_FI';
165 INSERT INTO tproc(text) VALUES (@@session.lc_time_names);
166 SET @@lc_time_names= 'no_NO';
167 INSERT INTO tproc(text) VALUES (@@session.lc_time_names);
168 SET @@collation_database= 'latin7_general_ci';
169 INSERT INTO tproc(text) VALUES (@@session.collation_database);
170 INSERT INTO tproc(text) VALUES (@@session.character_set_database);
171 SET @@collation_database= 'latin7_estonian_cs';
172 INSERT INTO tproc(text) VALUES (@@session.collation_database);
173 INSERT INTO tproc(text) VALUES (@@session.character_set_database);
174 SET @@timestamp= 47114711;
175 INSERT INTO tproc(text) VALUES (@@session.timestamp);
176 SET @@timestamp= 47124712;
177 INSERT INTO tproc(text) VALUES (@@session.timestamp);
178 SET @@last_insert_id= 1616;
179 INSERT INTO tproc(text) VALUES (@@session.last_insert_id);
180 SET @@last_insert_id= 1717;
181 INSERT INTO tproc(text) VALUES (@@session.last_insert_id);
182 END|
183 CALL proc();
184 ==== Insert variables from a stored function ====
185 CREATE FUNCTION func()
186 RETURNS INT
187 BEGIN
188 SET @@pseudo_thread_id= 4712;
189 INSERT INTO tfunc(num) VALUES (@@session.pseudo_thread_id);
190 SET @@pseudo_thread_id= 4713;
191 INSERT INTO tfunc(num) VALUES (@@session.pseudo_thread_id);
192 SET @@foreign_key_checks= 0;
193 INSERT INTO tfunc(num) VALUES (@@session.foreign_key_checks);
194 SET @@foreign_key_checks= 1;
195 INSERT INTO tfunc(num) VALUES (@@session.foreign_key_checks);
196 SET @@sql_auto_is_null= 0;
197 INSERT INTO tfunc(num) VALUES (@@session.sql_auto_is_null);
198 SET @@sql_auto_is_null= 1;
199 INSERT INTO tfunc(num) VALUES (@@session.sql_auto_is_null);
200 SET @@unique_checks= 0;
201 INSERT INTO tfunc(num) VALUES (@@session.unique_checks);
202 SET @@unique_checks= 1;
203 INSERT INTO tfunc(num) VALUES (@@session.unique_checks);
204 SET @@auto_increment_increment= 11;
205 INSERT INTO tfunc(num) VALUES (@@session.auto_increment_increment);
206 SET @@auto_increment_increment= 19;
207 INSERT INTO tfunc(num) VALUES (@@session.auto_increment_increment);
208 SET @@auto_increment_offset= 13;
209 INSERT INTO tfunc(num) VALUES (@@session.auto_increment_offset);
210 SET @@auto_increment_offset= 17;
211 INSERT INTO tfunc(num) VALUES (@@session.auto_increment_offset);
212 # reset these as they affect the index column
213 SET @@auto_increment_increment= 1;
214 SET @@auto_increment_offset= 1;
215 SET @@character_set_client= 'cp1257';
216 INSERT INTO tfunc(text) VALUES (@@session.character_set_client);
217 SET @@character_set_client= 'cp1256';
218 INSERT INTO tfunc(text) VALUES (@@session.character_set_client);
219 SET @@collation_connection= 'cp1251_ukrainian_ci';
220 INSERT INTO tfunc(text) VALUES (@@session.collation_connection);
221 INSERT INTO tfunc(text) VALUES (@@session.character_set_connection);
222 SET @@collation_connection= 'cp1251_bulgarian_ci';
223 INSERT INTO tfunc(text) VALUES (@@session.collation_connection);
224 INSERT INTO tfunc(text) VALUES (@@session.character_set_connection);
225 SET @@collation_server= 'latin7_bin';
226 INSERT INTO tfunc(text) VALUES (@@session.collation_server);
227 INSERT INTO tfunc(text) VALUES (@@session.character_set_server);
228 SET @@collation_server= 'latin7_general_cs';
229 INSERT INTO tfunc(text) VALUES (@@session.collation_server);
230 INSERT INTO tfunc(text) VALUES (@@session.character_set_server);
231 SET @@time_zone= 'Europe/Moscow';
232 INSERT INTO tfunc(text) VALUES (@@session.time_zone);
233 SET @@time_zone= 'Universal';
234 INSERT INTO tfunc(text) VALUES (@@session.time_zone);
235 SET @@lc_time_names= 'sv_FI';
236 INSERT INTO tfunc(text) VALUES (@@session.lc_time_names);
237 SET @@lc_time_names= 'no_NO';
238 INSERT INTO tfunc(text) VALUES (@@session.lc_time_names);
239 SET @@collation_database= 'latin7_general_ci';
240 INSERT INTO tfunc(text) VALUES (@@session.collation_database);
241 INSERT INTO tfunc(text) VALUES (@@session.character_set_database);
242 SET @@collation_database= 'latin7_estonian_cs';
243 INSERT INTO tfunc(text) VALUES (@@session.collation_database);
244 INSERT INTO tfunc(text) VALUES (@@session.character_set_database);
245 SET @@timestamp= 47114711;
246 INSERT INTO tfunc(text) VALUES (@@session.timestamp);
247 SET @@timestamp= 47124712;
248 INSERT INTO tfunc(text) VALUES (@@session.timestamp);
249 SET @@last_insert_id= 1616;
250 INSERT INTO tfunc(text) VALUES (@@session.last_insert_id);
251 SET @@last_insert_id= 1717;
252 INSERT INTO tfunc(text) VALUES (@@session.last_insert_id);
253 RETURN 0;
254 END|
255 SELECT func();
256 func()
257 0
258 ==== Insert variables from a trigger ====
259 CREATE TRIGGER trig
260 BEFORE INSERT ON trigger_table
261 FOR EACH ROW
262 BEGIN
263 SET @@pseudo_thread_id= 4712;
264 INSERT INTO ttrig(num) VALUES (@@session.pseudo_thread_id);
265 SET @@pseudo_thread_id= 4713;
266 INSERT INTO ttrig(num) VALUES (@@session.pseudo_thread_id);
267 SET @@foreign_key_checks= 0;
268 INSERT INTO ttrig(num) VALUES (@@session.foreign_key_checks);
269 SET @@foreign_key_checks= 1;
270 INSERT INTO ttrig(num) VALUES (@@session.foreign_key_checks);
271 SET @@sql_auto_is_null= 0;
272 INSERT INTO ttrig(num) VALUES (@@session.sql_auto_is_null);
273 SET @@sql_auto_is_null= 1;
274 INSERT INTO ttrig(num) VALUES (@@session.sql_auto_is_null);
275 SET @@unique_checks= 0;
276 INSERT INTO ttrig(num) VALUES (@@session.unique_checks);
277 SET @@unique_checks= 1;
278 INSERT INTO ttrig(num) VALUES (@@session.unique_checks);
279 SET @@auto_increment_increment= 11;
280 INSERT INTO ttrig(num) VALUES (@@session.auto_increment_increment);
281 SET @@auto_increment_increment= 19;
282 INSERT INTO ttrig(num) VALUES (@@session.auto_increment_increment);
283 SET @@auto_increment_offset= 13;
284 INSERT INTO ttrig(num) VALUES (@@session.auto_increment_offset);
285 SET @@auto_increment_offset= 17;
286 INSERT INTO ttrig(num) VALUES (@@session.auto_increment_offset);
287 # reset these as they affect the index column
288 SET @@auto_increment_increment= 1;
289 SET @@auto_increment_offset= 1;
290 SET @@character_set_client= 'cp1257';
291 INSERT INTO ttrig(text) VALUES (@@session.character_set_client);
292 SET @@character_set_client= 'cp1256';
293 INSERT INTO ttrig(text) VALUES (@@session.character_set_client);
294 SET @@collation_connection= 'cp1251_ukrainian_ci';
295 INSERT INTO ttrig(text) VALUES (@@session.collation_connection);
296 INSERT INTO ttrig(text) VALUES (@@session.character_set_connection);
297 SET @@collation_connection= 'cp1251_bulgarian_ci';
298 INSERT INTO ttrig(text) VALUES (@@session.collation_connection);
299 INSERT INTO ttrig(text) VALUES (@@session.character_set_connection);
300 SET @@collation_server= 'latin7_bin';
301 INSERT INTO ttrig(text) VALUES (@@session.collation_server);
302 INSERT INTO ttrig(text) VALUES (@@session.character_set_server);
303 SET @@collation_server= 'latin7_general_cs';
304 INSERT INTO ttrig(text) VALUES (@@session.collation_server);
305 INSERT INTO ttrig(text) VALUES (@@session.character_set_server);
306 SET @@time_zone= 'Europe/Moscow';
307 INSERT INTO ttrig(text) VALUES (@@session.time_zone);
308 SET @@time_zone= 'Universal';
309 INSERT INTO ttrig(text) VALUES (@@session.time_zone);
310 SET @@lc_time_names= 'sv_FI';
311 INSERT INTO ttrig(text) VALUES (@@session.lc_time_names);
312 SET @@lc_time_names= 'no_NO';
313 INSERT INTO ttrig(text) VALUES (@@session.lc_time_names);
314 SET @@collation_database= 'latin7_general_ci';
315 INSERT INTO ttrig(text) VALUES (@@session.collation_database);
316 INSERT INTO ttrig(text) VALUES (@@session.character_set_database);
317 SET @@collation_database= 'latin7_estonian_cs';
318 INSERT INTO ttrig(text) VALUES (@@session.collation_database);
319 INSERT INTO ttrig(text) VALUES (@@session.character_set_database);
320 SET @@timestamp= 47114711;
321 INSERT INTO ttrig(text) VALUES (@@session.timestamp);
322 SET @@timestamp= 47124712;
323 INSERT INTO ttrig(text) VALUES (@@session.timestamp);
324 SET @@last_insert_id= 1616;
325 INSERT INTO ttrig(text) VALUES (@@session.last_insert_id);
326 SET @@last_insert_id= 1717;
327 INSERT INTO ttrig(text) VALUES (@@session.last_insert_id);
328 END|
329 INSERT INTO trigger_table VALUES ('bye.');
330 ==== Insert variables from a prepared statement ====
331 PREPARE p1 FROM 'SET @@pseudo_thread_id= 4712';
332 PREPARE p2 FROM 'INSERT INTO tprep(num) VALUES (@@session.pseudo_thread_id)';
333 PREPARE p3 FROM 'SET @@pseudo_thread_id= 4713';
334 PREPARE p4 FROM 'INSERT INTO tprep(num) VALUES (@@session.pseudo_thread_id)';
335 PREPARE p5 FROM 'SET @@foreign_key_checks= 0';
336 PREPARE p6 FROM 'INSERT INTO tprep(num) VALUES (@@session.foreign_key_checks)';
337 PREPARE p7 FROM 'SET @@foreign_key_checks= 1';
338 PREPARE p8 FROM 'INSERT INTO tprep(num) VALUES (@@session.foreign_key_checks)';
339 PREPARE p9 FROM 'SET @@sql_auto_is_null= 0';
340 PREPARE p10 FROM 'INSERT INTO tprep(num) VALUES (@@session.sql_auto_is_null)';
341 PREPARE p11 FROM 'SET @@sql_auto_is_null= 1';
342 PREPARE p12 FROM 'INSERT INTO tprep(num) VALUES (@@session.sql_auto_is_null)';
343 PREPARE p13 FROM 'SET @@unique_checks= 0';
344 PREPARE p14 FROM 'INSERT INTO tprep(num) VALUES (@@session.unique_checks)';
345 PREPARE p15 FROM 'SET @@unique_checks= 1';
346 PREPARE p16 FROM 'INSERT INTO tprep(num) VALUES (@@session.unique_checks)';
347 PREPARE p17 FROM 'SET @@auto_increment_increment= 11';
348 PREPARE p18 FROM 'INSERT INTO tprep(num) VALUES (@@session.auto_increment_increment)';
349 PREPARE p19 FROM 'SET @@auto_increment_increment= 19';
350 PREPARE p20 FROM 'INSERT INTO tprep(num) VALUES (@@session.auto_increment_increment)';
351 PREPARE p21 FROM 'SET @@auto_increment_offset= 13';
352 PREPARE p22 FROM 'INSERT INTO tprep(num) VALUES (@@session.auto_increment_offset)';
353 PREPARE p23 FROM 'SET @@auto_increment_offset= 17';
354 PREPARE p24 FROM 'INSERT INTO tprep(num) VALUES (@@session.auto_increment_offset)';
355 PREPARE p25 FROM 'SET @@auto_increment_increment= 1';
356 PREPARE p26 FROM 'SET @@auto_increment_offset= 1';
357 PREPARE p27 FROM 'SET @@character_set_client= \'cp1257\'';
358 PREPARE p28 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_client)';
359 PREPARE p29 FROM 'SET @@character_set_client= \'cp1256\'';
360 PREPARE p30 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_client)';
361 PREPARE p31 FROM 'SET @@collation_connection= \'cp1251_ukrainian_ci\'';
362 PREPARE p32 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_connection)';
363 PREPARE p33 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_connection)';
364 PREPARE p34 FROM 'SET @@collation_connection= \'cp1251_bulgarian_ci\'';
365 PREPARE p35 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_connection)';
366 PREPARE p36 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_connection)';
367 PREPARE p37 FROM 'SET @@collation_server= \'latin7_bin\'';
368 PREPARE p38 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_server)';
369 PREPARE p39 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_server)';
370 PREPARE p40 FROM 'SET @@collation_server= \'latin7_general_cs\'';
371 PREPARE p41 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_server)';
372 PREPARE p42 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_server)';
373 PREPARE p43 FROM 'SET @@time_zone= \'Europe/Moscow\'';
374 PREPARE p44 FROM 'INSERT INTO tprep(text) VALUES (@@session.time_zone)';
375 PREPARE p45 FROM 'SET @@time_zone= \'Universal\'';
376 PREPARE p46 FROM 'INSERT INTO tprep(text) VALUES (@@session.time_zone)';
377 PREPARE p47 FROM 'SET @@lc_time_names= \'sv_FI\'';
378 PREPARE p48 FROM 'INSERT INTO tprep(text) VALUES (@@session.lc_time_names)';
379 PREPARE p49 FROM 'SET @@lc_time_names= \'no_NO\'';
380 PREPARE p50 FROM 'INSERT INTO tprep(text) VALUES (@@session.lc_time_names)';
381 PREPARE p51 FROM 'SET @@collation_database= \'latin7_general_ci\'';
382 PREPARE p52 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_database)';
383 PREPARE p53 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_database)';
384 PREPARE p54 FROM 'SET @@collation_database= \'latin7_estonian_cs\'';
385 PREPARE p55 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_database)';
386 PREPARE p56 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_database)';
387 PREPARE p57 FROM 'SET @@timestamp= 47114711';
388 PREPARE p58 FROM 'INSERT INTO tprep(text) VALUES (@@session.timestamp)';
389 PREPARE p59 FROM 'SET @@timestamp= 47124712';
390 PREPARE p60 FROM 'INSERT INTO tprep(text) VALUES (@@session.timestamp)';
391 PREPARE p61 FROM 'SET @@last_insert_id= 1616';
392 PREPARE p62 FROM 'INSERT INTO tprep(text) VALUES (@@session.last_insert_id)';
393 PREPARE p63 FROM 'SET @@last_insert_id= 1717';
394 PREPARE p64 FROM 'INSERT INTO tprep(text) VALUES (@@session.last_insert_id)';
395 EXECUTE p1;
396 EXECUTE p2;
397 EXECUTE p3;
398 EXECUTE p4;
399 EXECUTE p5;
400 EXECUTE p6;
401 EXECUTE p7;
402 EXECUTE p8;
403 EXECUTE p9;
404 EXECUTE p10;
405 EXECUTE p11;
406 EXECUTE p12;
407 EXECUTE p13;
408 EXECUTE p14;
409 EXECUTE p15;
410 EXECUTE p16;
411 EXECUTE p17;
412 EXECUTE p18;
413 EXECUTE p19;
414 EXECUTE p20;
415 EXECUTE p21;
416 EXECUTE p22;
417 EXECUTE p23;
418 EXECUTE p24;
419 EXECUTE p25;
420 EXECUTE p26;
421 EXECUTE p27;
422 EXECUTE p28;
423 EXECUTE p29;
424 EXECUTE p30;
425 EXECUTE p31;
426 EXECUTE p32;
427 EXECUTE p33;
428 EXECUTE p34;
429 EXECUTE p35;
430 EXECUTE p36;
431 EXECUTE p37;
432 EXECUTE p38;
433 EXECUTE p39;
434 EXECUTE p40;
435 EXECUTE p41;
436 EXECUTE p42;
437 EXECUTE p43;
438 EXECUTE p44;
439 EXECUTE p45;
440 EXECUTE p46;
441 EXECUTE p47;
442 EXECUTE p48;
443 EXECUTE p49;
444 EXECUTE p50;
445 EXECUTE p51;
446 Warnings:
447 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
448 EXECUTE p52;
449 EXECUTE p53;
450 EXECUTE p54;
451 Warnings:
452 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
453 EXECUTE p55;
454 EXECUTE p56;
455 EXECUTE p57;
456 EXECUTE p58;
457 EXECUTE p59;
458 EXECUTE p60;
459 EXECUTE p61;
460 EXECUTE p62;
461 EXECUTE p63;
462 EXECUTE p64;
463 ==== Results ====
464 SELECT * FROM tstmt ORDER BY id;
465 id num text
466 1 4712 NULL
467 2 4713 NULL
468 3 0 NULL
469 4 1 NULL
470 5 0 NULL
471 6 1 NULL
472 7 0 NULL
473 8 1 NULL
474 12 11 NULL
475 39 19 NULL
476 70 13 NULL
477 93 17 NULL
478 112 NULL cp1257
479 113 NULL cp1256
480 114 NULL cp1251_ukrainian_ci
481 115 NULL cp1251
482 116 NULL cp1251_bulgarian_ci
483 117 NULL cp1251
484 118 NULL latin7_bin
485 119 NULL latin7
486 120 NULL latin7_general_cs
487 121 NULL latin7
488 122 NULL Europe/Moscow
489 123 NULL Universal
490 124 NULL sv_FI
491 125 NULL no_NO
492 126 NULL latin7_general_ci
493 127 NULL latin7
494 128 NULL latin7_estonian_cs
495 129 NULL latin7
496 130 NULL 47114711
497 131 NULL 47124712
498 132 NULL 1616
499 133 NULL 1717
500 include/diff_tables.inc [master:tstmt, master:tproc, master:tfunc, master:ttrig, master:tprep, slave:tstmt, slave:tproc, slave:tfunc, slave:ttrig, slave:tprep]
501 ==== Clean up ====
502 [on master]
503 DROP PROCEDURE proc;
504 DROP FUNCTION func;
505 DROP TRIGGER trig;
506 DROP TABLE tstmt, tproc, tfunc, ttrig, tprep, trigger_table;
507 SET @@global.auto_increment_increment= @m_auto_increment_increment;
508 SET @@global.auto_increment_offset= @m_auto_increment_offset;
509 SET @@global.character_set_client= @m_character_set_client;
510 SET @@global.collation_connection= @m_collation_connection;
511 SET @@global.collation_server= @m_collation_server;
512 SET @@global.time_zone= @m_time_zone;
513 SET @@global.lc_time_names= @m_lc_time_names;
514 SET @@global.collation_database= @m_collation_database;
515 Warnings:
516 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
517 [on slave]
518 SET @@global.auto_increment_increment= @s_auto_increment_increment;
519 SET @@global.auto_increment_offset= @s_auto_increment_offset;
520 SET @@global.character_set_client= @s_character_set_client;
521 SET @@global.collation_connection= @s_collation_connection;
522 SET @@global.collation_server= @s_collation_server;
523 SET @@global.time_zone= @s_time_zone;
524 SET @@global.lc_time_names= @s_lc_time_names;
525 SET @@global.collation_database= @s_collation_database;
526 Warnings:
527 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
528 include/rpl_end.inc