Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 ==== Initialization ====
4 connection master;
5 SET @m_default_week_format= @@global.default_week_format;
6 SET @m_init_slave= @@global.init_slave;
7 SET @m_lc_time_names= @@global.lc_time_names;
8 SET @m_low_priority_updates= @@global.low_priority_updates;
9 SET @m_relay_log_purge= @@global.relay_log_purge;
10 SET @m_slave_exec_mode= @@global.slave_exec_mode;
11 SET @m_sql_mode= @@global.sql_mode;
12 SET @m_sync_binlog= @@global.sync_binlog;
13 connection slave;
14 SET @s_default_week_format= @@global.default_week_format;
15 SET @s_init_slave= @@global.init_slave;
16 SET @s_lc_time_names= @@global.lc_time_names;
17 SET @s_low_priority_updates= @@global.low_priority_updates;
18 SET @s_relay_log_purge= @@global.relay_log_purge;
19 SET @s_slave_exec_mode= @@global.slave_exec_mode;
20 SET @s_sql_mode= @@global.sql_mode;
21 SET @s_sync_binlog= @@global.sync_binlog;
22 SET @@global.relay_log_purge = OFF;
23 SET @@global.sync_binlog = 1000000;
24 SET @@global.slave_exec_mode = 'STRICT';
25 SET @@sql_big_selects = OFF;
26 SET @@last_insert_id = 10;
27 SET @@global.low_priority_updates = OFF;
28 SET @@local.low_priority_updates = OFF;
29 SET @@global.default_week_format = 1;
30 SET @@local.default_week_format = 2;
31 SET @@global.lc_time_names = 'zh_HK';
32 SET @@local.lc_time_names = 'zh_TW';
33 SET @@global.sql_mode = 'ALLOW_INVALID_DATES';
34 SET @@local.sql_mode = 'ANSI_QUOTES,ERROR_FOR_DIVISION_BY_ZERO,HIGH_NOT_PRECEDENCE';
35 SET @user_num = 10;
36 SET @user_text = 'Alunda';
37 include/stop_slave.inc
38 include/start_slave.inc
39 SET @@global.init_slave = 'SELECT 1';
40 connection master;
41 SELECT @@pid_file, @@datadir;
42 @@pid_file MYSQLTEST_VARDIR/run/mysqld.1.pid
43 @@datadir MYSQLTEST_VARDIR/mysqld.1/data/
44 **** Relay log variables
45 SELECT @@relay_log, @@relay_log_index, @@relay_log_basename;
46 @@relay_log master-relay-bin
47 @@relay_log_index MYSQLTEST_VARDIR/mysqld.1/data/master-relay-bin.index
48 @@relay_log_basename MYSQLTEST_VARDIR/mysqld.1/data/master-relay-bin
49 **** Binary log variables
50 SELECT @@log_bin, @@log_bin_index, @@log_bin_basename;
51 @@log_bin 1
52 @@log_bin_index MYSQLTEST_VARDIR/mysqld.1/data/master-bin.index
53 @@log_bin_basename MYSQLTEST_VARDIR/mysqld.1/data/master-bin
54 connection slave;
55 SELECT @@pid_file, @@datadir;
56 @@pid_file MYSQLTEST_VARDIR/run/mysqld.2.pid
57 @@datadir MYSQLTEST_VARDIR/mysqld.2/data/
58 **** Relay log variables
59 SELECT @@relay_log, @@relay_log_index, @@relay_log_basename;
60 @@relay_log slave-relay-bin
61 @@relay_log_index MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.index
62 @@relay_log_basename MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin
63 **** Binary log variables
64 SELECT @@log_bin, @@log_bin_index, @@log_bin_basename;
65 @@log_bin 1
66 @@log_bin_index MYSQLTEST_VARDIR/mysqld.2/data/slave-bin.index
67 @@log_bin_basename MYSQLTEST_VARDIR/mysqld.2/data/slave-bin
68 connection master;
69 CREATE TABLE tstmt (id INT AUTO_INCREMENT PRIMARY KEY,
70 truth BOOLEAN,
71 num INT,
72 text VARCHAR(100));
73 CREATE TABLE tproc LIKE tstmt;
74 CREATE TABLE tfunc LIKE tstmt;
75 CREATE TABLE ttrig LIKE tstmt;
76 CREATE TABLE tprep LIKE tstmt;
77 CREATE TABLE trigger_table (text CHAR(4));
78 ==== Insert variables directly ====
79 ---- global variables ----
80 SET @@global.relay_log_purge = ON;
81 INSERT INTO tstmt(truth) VALUES (@@global.relay_log_purge);
82 SET @@global.relay_log_purge = OFF;
83 INSERT INTO tstmt(truth) VALUES (@@global.relay_log_purge);
84 SET @@global.sync_binlog = 2000000;
85 INSERT INTO tstmt(num) VALUES (@@global.sync_binlog);
86 SET @@global.sync_binlog = 3000000;
87 INSERT INTO tstmt(num) VALUES (@@global.sync_binlog);
88 SET @@global.init_slave = 'SELECT 2';
89 INSERT INTO tstmt(text) VALUES (@@global.init_slave);
90 SET @@global.init_slave = 'SELECT 3';
91 INSERT INTO tstmt(text) VALUES (@@global.init_slave);
92 SET @@global.slave_exec_mode = 'IDEMPOTENT';
93 INSERT INTO tstmt(text) VALUES (@@global.slave_exec_mode);
94 SET @@global.slave_exec_mode = 'STRICT';
95 INSERT INTO tstmt(text) VALUES (@@global.slave_exec_mode);
96 ---- session variables ----
97 SET @@sql_big_selects = ON;
98 INSERT INTO tstmt(truth) VALUES (@@sql_big_selects);
99 SET @@sql_big_selects = OFF;
100 INSERT INTO tstmt(truth) VALUES (@@sql_big_selects);
101 SET @@last_insert_id = 20;
102 INSERT INTO tstmt(num) VALUES (@@last_insert_id);
103 SET @@last_insert_id = 30;
104 INSERT INTO tstmt(num) VALUES (@@last_insert_id);
105 ---- global and session variables ----
106 SET @@global.low_priority_updates = ON;
107 SET @@local.low_priority_updates = OFF;
108 INSERT INTO tstmt(truth) VALUES (@@global.low_priority_updates);
109 INSERT INTO tstmt(truth) VALUES (@@local.low_priority_updates);
110 SET @@global.low_priority_updates = OFF;
111 SET @@local.low_priority_updates = ON;
112 INSERT INTO tstmt(truth) VALUES (@@global.low_priority_updates);
113 INSERT INTO tstmt(truth) VALUES (@@local.low_priority_updates);
114 SET @@global.default_week_format = 3;
115 SET @@local.default_week_format = 4;
116 INSERT INTO tstmt(num) VALUES (@@global.default_week_format);
117 INSERT INTO tstmt(num) VALUES (@@local.default_week_format);
118 SET @@global.default_week_format = 5;
119 SET @@local.default_week_format = 6;
120 INSERT INTO tstmt(num) VALUES (@@global.default_week_format);
121 INSERT INTO tstmt(num) VALUES (@@local.default_week_format);
122 SET @@global.lc_time_names = 'sv_SE';
123 SET @@local.lc_time_names = 'sv_FI';
124 INSERT INTO tstmt(text) VALUES (@@global.lc_time_names);
125 INSERT INTO tstmt(text) VALUES (@@local.lc_time_names);
126 SET @@global.lc_time_names = 'ar_TN';
127 SET @@local.lc_time_names = 'ar_IQ';
128 INSERT INTO tstmt(text) VALUES (@@global.lc_time_names);
129 INSERT INTO tstmt(text) VALUES (@@local.lc_time_names);
130 SET @@global.sql_mode = '';
131 SET @@local.sql_mode = 'IGNORE_SPACE,NO_AUTO_CREATE_USER';
132 INSERT INTO tstmt(text) VALUES (@@global.sql_mode);
133 INSERT INTO tstmt(text) VALUES (@@local.sql_mode);
134 SET @@global.sql_mode = 'NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,NO_DIR_IN_CREATE,NO_ENGINE_SUBSTITUTION';
135 SET @@local.sql_mode = 'NO_FIELD_OPTIONS,NO_KEY_OPTIONS,NO_TABLE_OPTIONS';
136 INSERT INTO tstmt(text) VALUES (@@global.sql_mode);
137 INSERT INTO tstmt(text) VALUES (@@local.sql_mode);
138 ---- user variables ----
139 SET @user_num = 20;
140 INSERT INTO tstmt(num) VALUES (@user_num);
141 SET @user_num = 30;
142 INSERT INTO tstmt(num) VALUES (@user_num);
143 SET @user_text = 'Bergsbrunna';
144 INSERT INTO tstmt(text) VALUES (@user_text);
145 SET @user_text = 'Centrum';
146 INSERT INTO tstmt(text) VALUES (@user_text);
147 ==== Insert variables from a stored procedure ====
148 CREATE PROCEDURE proc()
149 BEGIN
150 # GLOBAL
151 # boolean
152 SET @@global.relay_log_purge = ON;
153 INSERT INTO tproc(truth) VALUES (@@global.relay_log_purge);
154 SET @@global.relay_log_purge = OFF;
155 INSERT INTO tproc(truth) VALUES (@@global.relay_log_purge);
156 # numeric
157 SET @@global.sync_binlog = 2000000;
158 INSERT INTO tproc(num) VALUES (@@global.sync_binlog);
159 SET @@global.sync_binlog = 3000000;
160 INSERT INTO tproc(num) VALUES (@@global.sync_binlog);
161 # string
162 SET @@global.init_slave = 'SELECT 2';
163 INSERT INTO tproc(text) VALUES (@@global.init_slave);
164 SET @@global.init_slave = 'SELECT 3';
165 INSERT INTO tproc(text) VALUES (@@global.init_slave);
166 # enumeration
167 SET @@global.slave_exec_mode = 'IDEMPOTENT';
168 INSERT INTO tproc(text) VALUES (@@global.slave_exec_mode);
169 SET @@global.slave_exec_mode = 'STRICT';
170 INSERT INTO tproc(text) VALUES (@@global.slave_exec_mode);
171 # SESSION
172 # boolean
173 SET @@sql_big_selects = ON;
174 INSERT INTO tproc(truth) VALUES (@@sql_big_selects);
175 SET @@sql_big_selects = OFF;
176 INSERT INTO tproc(truth) VALUES (@@sql_big_selects);
177 # numeric
178 SET @@last_insert_id = 20;
179 INSERT INTO tproc(num) VALUES (@@last_insert_id);
180 SET @@last_insert_id = 30;
181 INSERT INTO tproc(num) VALUES (@@last_insert_id);
182 # BOTH
183 # boolean
184 SET @@global.low_priority_updates = ON;
185 SET @@local.low_priority_updates = OFF;
186 INSERT INTO tproc(truth) VALUES (@@global.low_priority_updates);
187 INSERT INTO tproc(truth) VALUES (@@local.low_priority_updates);
188 SET @@global.low_priority_updates = OFF;
189 SET @@local.low_priority_updates = ON;
190 INSERT INTO tproc(truth) VALUES (@@global.low_priority_updates);
191 INSERT INTO tproc(truth) VALUES (@@local.low_priority_updates);
192 # numeric
193 SET @@global.default_week_format = 3;
194 SET @@local.default_week_format = 4;
195 INSERT INTO tproc(num) VALUES (@@global.default_week_format);
196 INSERT INTO tproc(num) VALUES (@@local.default_week_format);
197 SET @@global.default_week_format = 5;
198 SET @@local.default_week_format = 6;
199 INSERT INTO tproc(num) VALUES (@@global.default_week_format);
200 INSERT INTO tproc(num) VALUES (@@local.default_week_format);
201 # text
202 SET @@global.lc_time_names = 'sv_SE';
203 SET @@local.lc_time_names = 'sv_FI';
204 INSERT INTO tproc(text) VALUES (@@global.lc_time_names);
205 INSERT INTO tproc(text) VALUES (@@local.lc_time_names);
206 SET @@global.lc_time_names = 'ar_TN';
207 SET @@local.lc_time_names = 'ar_IQ';
208 INSERT INTO tproc(text) VALUES (@@global.lc_time_names);
209 INSERT INTO tproc(text) VALUES (@@local.lc_time_names);
210 # enum
211 SET @@global.sql_mode = '';
212 SET @@local.sql_mode = 'IGNORE_SPACE,NO_AUTO_CREATE_USER';
213 INSERT INTO tproc(text) VALUES (@@global.sql_mode);
214 INSERT INTO tproc(text) VALUES (@@local.sql_mode);
215 SET @@global.sql_mode = 'NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,NO_DIR_IN_CREATE,NO_ENGINE_SUBSTITUTION';
216 SET @@local.sql_mode = 'NO_FIELD_OPTIONS,NO_KEY_OPTIONS,NO_TABLE_OPTIONS';
217 INSERT INTO tproc(text) VALUES (@@global.sql_mode);
218 INSERT INTO tproc(text) VALUES (@@local.sql_mode);
219 # USER
220 # numeric
221 SET @user_num = 20;
222 INSERT INTO tproc(num) VALUES (@user_num);
223 SET @user_num = 30;
224 INSERT INTO tproc(num) VALUES (@user_num);
225 # string
226 SET @user_text = 'Bergsbrunna';
227 INSERT INTO tproc(text) VALUES (@user_text);
228 SET @user_text = 'Centrum';
229 INSERT INTO tproc(text) VALUES (@user_text);
230 END|
231 CALL proc();
232 ==== Insert variables from a stored function ====
233 CREATE FUNCTION func()
234 RETURNS INT
235 BEGIN
236 # GLOBAL
237 # boolean
238 SET @@global.relay_log_purge = ON;
239 INSERT INTO tfunc(truth) VALUES (@@global.relay_log_purge);
240 SET @@global.relay_log_purge = OFF;
241 INSERT INTO tfunc(truth) VALUES (@@global.relay_log_purge);
242 # numeric
243 SET @@global.sync_binlog = 2000000;
244 INSERT INTO tfunc(num) VALUES (@@global.sync_binlog);
245 SET @@global.sync_binlog = 3000000;
246 INSERT INTO tfunc(num) VALUES (@@global.sync_binlog);
247 # string
248 SET @@global.init_slave = 'SELECT 2';
249 INSERT INTO tfunc(text) VALUES (@@global.init_slave);
250 SET @@global.init_slave = 'SELECT 3';
251 INSERT INTO tfunc(text) VALUES (@@global.init_slave);
252 # enumeration
253 SET @@global.slave_exec_mode = 'IDEMPOTENT';
254 INSERT INTO tfunc(text) VALUES (@@global.slave_exec_mode);
255 SET @@global.slave_exec_mode = 'STRICT';
256 INSERT INTO tfunc(text) VALUES (@@global.slave_exec_mode);
257 # SESSION
258 # boolean
259 SET @@sql_big_selects = ON;
260 INSERT INTO tfunc(truth) VALUES (@@sql_big_selects);
261 SET @@sql_big_selects = OFF;
262 INSERT INTO tfunc(truth) VALUES (@@sql_big_selects);
263 # numeric
264 SET @@last_insert_id = 20;
265 INSERT INTO tfunc(num) VALUES (@@last_insert_id);
266 SET @@last_insert_id = 30;
267 INSERT INTO tfunc(num) VALUES (@@last_insert_id);
268 # BOTH
269 # boolean
270 SET @@global.low_priority_updates = ON;
271 SET @@local.low_priority_updates = OFF;
272 INSERT INTO tfunc(truth) VALUES (@@global.low_priority_updates);
273 INSERT INTO tfunc(truth) VALUES (@@local.low_priority_updates);
274 SET @@global.low_priority_updates = OFF;
275 SET @@local.low_priority_updates = ON;
276 INSERT INTO tfunc(truth) VALUES (@@global.low_priority_updates);
277 INSERT INTO tfunc(truth) VALUES (@@local.low_priority_updates);
278 # numeric
279 SET @@global.default_week_format = 3;
280 SET @@local.default_week_format = 4;
281 INSERT INTO tfunc(num) VALUES (@@global.default_week_format);
282 INSERT INTO tfunc(num) VALUES (@@local.default_week_format);
283 SET @@global.default_week_format = 5;
284 SET @@local.default_week_format = 6;
285 INSERT INTO tfunc(num) VALUES (@@global.default_week_format);
286 INSERT INTO tfunc(num) VALUES (@@local.default_week_format);
287 # text
288 SET @@global.lc_time_names = 'sv_SE';
289 SET @@local.lc_time_names = 'sv_FI';
290 INSERT INTO tfunc(text) VALUES (@@global.lc_time_names);
291 INSERT INTO tfunc(text) VALUES (@@local.lc_time_names);
292 SET @@global.lc_time_names = 'ar_TN';
293 SET @@local.lc_time_names = 'ar_IQ';
294 INSERT INTO tfunc(text) VALUES (@@global.lc_time_names);
295 INSERT INTO tfunc(text) VALUES (@@local.lc_time_names);
296 # enum
297 SET @@global.sql_mode = '';
298 SET @@local.sql_mode = 'IGNORE_SPACE,NO_AUTO_CREATE_USER';
299 INSERT INTO tfunc(text) VALUES (@@global.sql_mode);
300 INSERT INTO tfunc(text) VALUES (@@local.sql_mode);
301 SET @@global.sql_mode = 'NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,NO_DIR_IN_CREATE,NO_ENGINE_SUBSTITUTION';
302 SET @@local.sql_mode = 'NO_FIELD_OPTIONS,NO_KEY_OPTIONS,NO_TABLE_OPTIONS';
303 INSERT INTO tfunc(text) VALUES (@@global.sql_mode);
304 INSERT INTO tfunc(text) VALUES (@@local.sql_mode);
305 # USER
306 # numeric
307 SET @user_num = 20;
308 INSERT INTO tfunc(num) VALUES (@user_num);
309 SET @user_num = 30;
310 INSERT INTO tfunc(num) VALUES (@user_num);
311 # string
312 SET @user_text = 'Bergsbrunna';
313 INSERT INTO tfunc(text) VALUES (@user_text);
314 SET @user_text = 'Centrum';
315 INSERT INTO tfunc(text) VALUES (@user_text);
316 RETURN 0;
317 END|
318 SELECT func();
319 func()
320 0
321 ==== Insert variables from a trigger ====
322 CREATE TRIGGER trig
323 BEFORE INSERT ON trigger_table
324 FOR EACH ROW
325 BEGIN
326 # GLOBAL
327 # boolean
328 SET @@global.relay_log_purge = ON;
329 INSERT INTO ttrig(truth) VALUES (@@global.relay_log_purge);
330 SET @@global.relay_log_purge = OFF;
331 INSERT INTO ttrig(truth) VALUES (@@global.relay_log_purge);
332 # numeric
333 SET @@global.sync_binlog = 2000000;
334 INSERT INTO ttrig(num) VALUES (@@global.sync_binlog);
335 SET @@global.sync_binlog = 3000000;
336 INSERT INTO ttrig(num) VALUES (@@global.sync_binlog);
337 # string
338 SET @@global.init_slave = 'SELECT 2';
339 INSERT INTO ttrig(text) VALUES (@@global.init_slave);
340 SET @@global.init_slave = 'SELECT 3';
341 INSERT INTO ttrig(text) VALUES (@@global.init_slave);
342 # enumeration
343 SET @@global.slave_exec_mode = 'IDEMPOTENT';
344 INSERT INTO ttrig(text) VALUES (@@global.slave_exec_mode);
345 SET @@global.slave_exec_mode = 'STRICT';
346 INSERT INTO ttrig(text) VALUES (@@global.slave_exec_mode);
347 # SESSION
348 # boolean
349 SET @@sql_big_selects = ON;
350 INSERT INTO ttrig(truth) VALUES (@@sql_big_selects);
351 SET @@sql_big_selects = OFF;
352 INSERT INTO ttrig(truth) VALUES (@@sql_big_selects);
353 # numeric
354 SET @@last_insert_id = 20;
355 INSERT INTO ttrig(num) VALUES (@@last_insert_id);
356 SET @@last_insert_id = 30;
357 INSERT INTO ttrig(num) VALUES (@@last_insert_id);
358 # BOTH
359 # boolean
360 SET @@global.low_priority_updates = ON;
361 SET @@local.low_priority_updates = OFF;
362 INSERT INTO ttrig(truth) VALUES (@@global.low_priority_updates);
363 INSERT INTO ttrig(truth) VALUES (@@local.low_priority_updates);
364 SET @@global.low_priority_updates = OFF;
365 SET @@local.low_priority_updates = ON;
366 INSERT INTO ttrig(truth) VALUES (@@global.low_priority_updates);
367 INSERT INTO ttrig(truth) VALUES (@@local.low_priority_updates);
368 # numeric
369 SET @@global.default_week_format = 3;
370 SET @@local.default_week_format = 4;
371 INSERT INTO ttrig(num) VALUES (@@global.default_week_format);
372 INSERT INTO ttrig(num) VALUES (@@local.default_week_format);
373 SET @@global.default_week_format = 5;
374 SET @@local.default_week_format = 6;
375 INSERT INTO ttrig(num) VALUES (@@global.default_week_format);
376 INSERT INTO ttrig(num) VALUES (@@local.default_week_format);
377 # text
378 SET @@global.lc_time_names = 'sv_SE';
379 SET @@local.lc_time_names = 'sv_FI';
380 INSERT INTO ttrig(text) VALUES (@@global.lc_time_names);
381 INSERT INTO ttrig(text) VALUES (@@local.lc_time_names);
382 SET @@global.lc_time_names = 'ar_TN';
383 SET @@local.lc_time_names = 'ar_IQ';
384 INSERT INTO ttrig(text) VALUES (@@global.lc_time_names);
385 INSERT INTO ttrig(text) VALUES (@@local.lc_time_names);
386 # enum
387 SET @@global.sql_mode = '';
388 SET @@local.sql_mode = 'IGNORE_SPACE,NO_AUTO_CREATE_USER';
389 INSERT INTO ttrig(text) VALUES (@@global.sql_mode);
390 INSERT INTO ttrig(text) VALUES (@@local.sql_mode);
391 SET @@global.sql_mode = 'NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,NO_DIR_IN_CREATE,NO_ENGINE_SUBSTITUTION';
392 SET @@local.sql_mode = 'NO_FIELD_OPTIONS,NO_KEY_OPTIONS,NO_TABLE_OPTIONS';
393 INSERT INTO ttrig(text) VALUES (@@global.sql_mode);
394 INSERT INTO ttrig(text) VALUES (@@local.sql_mode);
395 # USER
396 # numeric
397 SET @user_num = 20;
398 INSERT INTO ttrig(num) VALUES (@user_num);
399 SET @user_num = 30;
400 INSERT INTO ttrig(num) VALUES (@user_num);
401 # string
402 SET @user_text = 'Bergsbrunna';
403 INSERT INTO ttrig(text) VALUES (@user_text);
404 SET @user_text = 'Centrum';
405 INSERT INTO ttrig(text) VALUES (@user_text);
406 END|
407 INSERT INTO trigger_table VALUES ('bye.');
408 ==== Insert variables from a prepared statement ====
409 PREPARE p1 FROM 'SET @@global.relay_log_purge = ON';
410 PREPARE p2 FROM 'INSERT INTO tprep(truth) VALUES (@@global.relay_log_purge)';
411 PREPARE p3 FROM 'SET @@global.relay_log_purge = OFF';
412 PREPARE p4 FROM 'INSERT INTO tprep(truth) VALUES (@@global.relay_log_purge)';
413 PREPARE p5 FROM 'SET @@global.sync_binlog = 2000000';
414 PREPARE p6 FROM 'INSERT INTO tprep(num) VALUES (@@global.sync_binlog)';
415 PREPARE p7 FROM 'SET @@global.sync_binlog = 3000000';
416 PREPARE p8 FROM 'INSERT INTO tprep(num) VALUES (@@global.sync_binlog)';
417 PREPARE p9 FROM 'SET @@global.init_slave = \'SELECT 2\'';
418 PREPARE p10 FROM 'INSERT INTO tprep(text) VALUES (@@global.init_slave)';
419 PREPARE p11 FROM 'SET @@global.init_slave = \'SELECT 3\'';
420 PREPARE p12 FROM 'INSERT INTO tprep(text) VALUES (@@global.init_slave)';
421 PREPARE p13 FROM 'SET @@global.slave_exec_mode = \'IDEMPOTENT\'';
422 PREPARE p14 FROM 'INSERT INTO tprep(text) VALUES (@@global.slave_exec_mode)';
423 PREPARE p15 FROM 'SET @@global.slave_exec_mode = \'STRICT\'';
424 PREPARE p16 FROM 'INSERT INTO tprep(text) VALUES (@@global.slave_exec_mode)';
425 PREPARE p17 FROM 'SET @@sql_big_selects = ON';
426 PREPARE p18 FROM 'INSERT INTO tprep(truth) VALUES (@@sql_big_selects)';
427 PREPARE p19 FROM 'SET @@sql_big_selects = OFF';
428 PREPARE p20 FROM 'INSERT INTO tprep(truth) VALUES (@@sql_big_selects)';
429 PREPARE p21 FROM 'SET @@last_insert_id = 20';
430 PREPARE p22 FROM 'INSERT INTO tprep(num) VALUES (@@last_insert_id)';
431 PREPARE p23 FROM 'SET @@last_insert_id = 30';
432 PREPARE p24 FROM 'INSERT INTO tprep(num) VALUES (@@last_insert_id)';
433 PREPARE p25 FROM 'SET @@global.low_priority_updates = ON';
434 PREPARE p26 FROM 'SET @@local.low_priority_updates = OFF';
435 PREPARE p27 FROM 'INSERT INTO tprep(truth) VALUES (@@global.low_priority_updates)';
436 PREPARE p28 FROM 'INSERT INTO tprep(truth) VALUES (@@local.low_priority_updates)';
437 PREPARE p29 FROM 'SET @@global.low_priority_updates = OFF';
438 PREPARE p30 FROM 'SET @@local.low_priority_updates = ON';
439 PREPARE p31 FROM 'INSERT INTO tprep(truth) VALUES (@@global.low_priority_updates)';
440 PREPARE p32 FROM 'INSERT INTO tprep(truth) VALUES (@@local.low_priority_updates)';
441 PREPARE p33 FROM 'SET @@global.default_week_format = 3';
442 PREPARE p34 FROM 'SET @@local.default_week_format = 4';
443 PREPARE p35 FROM 'INSERT INTO tprep(num) VALUES (@@global.default_week_format)';
444 PREPARE p36 FROM 'INSERT INTO tprep(num) VALUES (@@local.default_week_format)';
445 PREPARE p37 FROM 'SET @@global.default_week_format = 5';
446 PREPARE p38 FROM 'SET @@local.default_week_format = 6';
447 PREPARE p39 FROM 'INSERT INTO tprep(num) VALUES (@@global.default_week_format)';
448 PREPARE p40 FROM 'INSERT INTO tprep(num) VALUES (@@local.default_week_format)';
449 PREPARE p41 FROM 'SET @@global.lc_time_names = \'sv_SE\'';
450 PREPARE p42 FROM 'SET @@local.lc_time_names = \'sv_FI\'';
451 PREPARE p43 FROM 'INSERT INTO tprep(text) VALUES (@@global.lc_time_names)';
452 PREPARE p44 FROM 'INSERT INTO tprep(text) VALUES (@@local.lc_time_names)';
453 PREPARE p45 FROM 'SET @@global.lc_time_names = \'ar_TN\'';
454 PREPARE p46 FROM 'SET @@local.lc_time_names = \'ar_IQ\'';
455 PREPARE p47 FROM 'INSERT INTO tprep(text) VALUES (@@global.lc_time_names)';
456 PREPARE p48 FROM 'INSERT INTO tprep(text) VALUES (@@local.lc_time_names)';
457 PREPARE p49 FROM 'SET @@global.sql_mode = \'\'';
458 PREPARE p50 FROM 'SET @@local.sql_mode = \'IGNORE_SPACE,NO_AUTO_CREATE_USER\'';
459 PREPARE p51 FROM 'INSERT INTO tprep(text) VALUES (@@global.sql_mode)';
460 PREPARE p52 FROM 'INSERT INTO tprep(text) VALUES (@@local.sql_mode)';
461 PREPARE p53 FROM 'SET @@global.sql_mode = \'NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,NO_DIR_IN_CREATE,NO_ENGINE_SUBSTITUTION\'';
462 PREPARE p54 FROM 'SET @@local.sql_mode = \'NO_FIELD_OPTIONS,NO_KEY_OPTIONS,NO_TABLE_OPTIONS\'';
463 PREPARE p55 FROM 'INSERT INTO tprep(text) VALUES (@@global.sql_mode)';
464 PREPARE p56 FROM 'INSERT INTO tprep(text) VALUES (@@local.sql_mode)';
465 PREPARE p57 FROM 'SET @user_num = 20';
466 PREPARE p58 FROM 'INSERT INTO tprep(num) VALUES (@user_num)';
467 PREPARE p59 FROM 'SET @user_num = 30';
468 PREPARE p60 FROM 'INSERT INTO tprep(num) VALUES (@user_num)';
469 PREPARE p61 FROM 'SET @user_text = \'Bergsbrunna\'';
470 PREPARE p62 FROM 'INSERT INTO tprep(text) VALUES (@user_text)';
471 PREPARE p63 FROM 'SET @user_text = \'Centrum\'';
472 PREPARE p64 FROM 'INSERT INTO tprep(text) VALUES (@user_text)';
473 EXECUTE p1;
474 EXECUTE p2;
475 EXECUTE p3;
476 EXECUTE p4;
477 EXECUTE p5;
478 EXECUTE p6;
479 EXECUTE p7;
480 EXECUTE p8;
481 EXECUTE p9;
482 EXECUTE p10;
483 EXECUTE p11;
484 EXECUTE p12;
485 EXECUTE p13;
486 EXECUTE p14;
487 EXECUTE p15;
488 EXECUTE p16;
489 EXECUTE p17;
490 EXECUTE p18;
491 EXECUTE p19;
492 EXECUTE p20;
493 EXECUTE p21;
494 EXECUTE p22;
495 EXECUTE p23;
496 EXECUTE p24;
497 EXECUTE p25;
498 EXECUTE p26;
499 EXECUTE p27;
500 EXECUTE p28;
501 EXECUTE p29;
502 EXECUTE p30;
503 EXECUTE p31;
504 EXECUTE p32;
505 EXECUTE p33;
506 EXECUTE p34;
507 EXECUTE p35;
508 EXECUTE p36;
509 EXECUTE p37;
510 EXECUTE p38;
511 EXECUTE p39;
512 EXECUTE p40;
513 EXECUTE p41;
514 EXECUTE p42;
515 EXECUTE p43;
516 EXECUTE p44;
517 EXECUTE p45;
518 EXECUTE p46;
519 EXECUTE p47;
520 EXECUTE p48;
521 EXECUTE p49;
522 EXECUTE p50;
523 EXECUTE p51;
524 EXECUTE p52;
525 EXECUTE p53;
526 EXECUTE p54;
527 EXECUTE p55;
528 EXECUTE p56;
529 EXECUTE p57;
530 EXECUTE p58;
531 EXECUTE p59;
532 EXECUTE p60;
533 EXECUTE p61;
534 EXECUTE p62;
535 EXECUTE p63;
536 EXECUTE p64;
537 connection slave;
538 connection master;
539 ==== Results ====
540 SELECT * FROM tstmt ORDER BY id;
541 id truth num text
542 1 1 NULL NULL
543 2 0 NULL NULL
544 3 NULL 2000000 NULL
545 4 NULL 3000000 NULL
546 5 NULL NULL SELECT 2
547 6 NULL NULL SELECT 3
548 7 NULL NULL IDEMPOTENT
549 8 NULL NULL STRICT
550 9 1 NULL NULL
551 10 0 NULL NULL
552 11 NULL 20 NULL
553 12 NULL 30 NULL
554 13 1 NULL NULL
555 14 0 NULL NULL
556 15 0 NULL NULL
557 16 1 NULL NULL
558 17 NULL 3 NULL
559 18 NULL 4 NULL
560 19 NULL 5 NULL
561 20 NULL 6 NULL
562 21 NULL NULL sv_SE
563 22 NULL NULL sv_FI
564 23 NULL NULL ar_TN
565 24 NULL NULL ar_IQ
566 25 NULL NULL
567 26 NULL NULL IGNORE_SPACE,NO_AUTO_CREATE_USER
568 27 NULL NULL NO_DIR_IN_CREATE,NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,NO_ENGINE_SUBSTITUTION
569 28 NULL NULL NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS
570 29 NULL 20 NULL
571 30 NULL 30 NULL
572 31 NULL NULL Bergsbrunna
573 32 NULL NULL Centrum
574 connection slave;
575 include/diff_tables.inc [master:tstmt, master:tproc, master:tfunc, master:ttrig, master:tprep, slave:tstmt, slave:tproc, slave:tfunc, slave:ttrig, slave:tprep]
576 ==== Clean up ====
577 connection master;
578 DROP PROCEDURE proc;
579 DROP FUNCTION func;
580 DROP TRIGGER trig;
581 DROP TABLE tstmt, tproc, tfunc, ttrig, tprep, trigger_table;
582 SET @@global.default_week_format= @m_default_week_format;
583 SET @@global.init_slave= @m_init_slave;
584 SET @@global.lc_time_names= @m_lc_time_names;
585 SET @@global.low_priority_updates= @m_low_priority_updates;
586 SET @@global.relay_log_purge= @m_relay_log_purge;
587 SET @@global.slave_exec_mode= @m_slave_exec_mode;
588 SET @@global.sql_mode= @m_sql_mode;
589 SET @@global.sync_binlog= @m_sync_binlog;
590 connection slave;
591 SET @@global.default_week_format= @s_default_week_format;
592 SET @@global.init_slave= @s_init_slave;
593 SET @@global.lc_time_names= @s_lc_time_names;
594 SET @@global.low_priority_updates= @s_low_priority_updates;
595 SET @@global.relay_log_purge= @s_relay_log_purge;
596 SET @@global.slave_exec_mode= @s_slave_exec_mode;
597 SET @@global.sql_mode= @s_sql_mode;
598 SET @@global.sync_binlog= @s_sync_binlog;
599 connection master;
600 connection slave;
601 include/rpl_end.inc