Debian Codegraph @

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

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