Debian Codegraph @

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