1
include/master-slave.inc
3
call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
4
==== Initialization ====
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;
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';
32
CREATE TABLE tstmt (id INT AUTO_INCREMENT PRIMARY KEY,
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()
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);
175
==== Insert variables from a stored function ====
176
CREATE FUNCTION func()
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);
249
==== Insert variables from a trigger ====
251
BEFORE INSERT ON trigger_table
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);
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)';
451
SELECT * FROM tstmt ORDER BY id;
467
39 NULL cp1251_ukrainian_ci
469
41 NULL cp1251_bulgarian_ci
473
45 NULL latin7_general_cs
475
47 NULL Europe/Moscow
479
51 NULL latin7_general_ci
481
53 NULL latin7_estonian_cs
487
include/diff_tables.inc [master:tstmt, master:tproc, master:tfunc, master:ttrig, master:tprep, slave:tstmt, slave:tproc, slave:tfunc, slave:ttrig, slave:tprep]
493
DROP TABLE tstmt, tproc, tfunc, ttrig, tprep, trigger_table;
494
SET @@global.auto_increment_increment= @m_auto_increment_increment;
495
SET @@global.auto_increment_offset= @m_auto_increment_offset;
496
SET @@global.character_set_client= @m_character_set_client;
497
SET @@global.collation_connection= @m_collation_connection;
498
SET @@global.collation_server= @m_collation_server;
499
SET @@global.time_zone= @m_time_zone;
500
SET @@global.lc_time_names= @m_lc_time_names;
501
SET @@global.collation_database= @m_collation_database;
503
SET @@global.auto_increment_increment= @s_auto_increment_increment;
504
SET @@global.auto_increment_offset= @s_auto_increment_offset;
505
SET @@global.character_set_client= @s_character_set_client;
506
SET @@global.collation_connection= @s_collation_connection;
507
SET @@global.collation_server= @s_collation_server;
508
SET @@global.time_zone= @s_time_zone;
509
SET @@global.lc_time_names= @s_lc_time_names;
510
SET @@global.collation_database= @s_collation_database;