Debian Codegraph @

mysql-test/suite/rpl/include/rpl_mixing_engines.test

raw
1 ################################################################################
2 # - Introduction
3 # This checks if transactions that mixes transactional and non-transactional
4 # are correctly handled. There are several types of statements that require
5 # attention because of their special behavior in transactions:
6 #
7 # * Non-transactional updates that take place inside a transaction present
8 # problems for logging because (1) they are visible to other clients before
9 # the transaction is committed, and (2) they are not rolled back even if the
10 # transaction is rolled back. It is not always possible to log correctly in
11 # statement format when both transactional and non-transactional tables are
12 # used in the same transaction.
13 #
14 # * Statements that do an implicit commit (i.e., most but not all DDL, and
15 # some utility commands) are logged specially
16 #
17 # * Statements that update temporary tables need special treatment since they
18 # are not logged in row format.
19 #
20 # - Definitions
21 #
22 # To reason about logging different table types, we make some preliminary
23 # definitions.
24 #
25 # * A table that has a transactional engine is called a T-table.
26 #
27 # * A table that has a non-transactional engine is called an N-table.
28 #
29 # * A statement makes an N-write if it makes any type of change to the server
30 # state that will not be changed by a ROLLBACK.
31 #
32 # * Events are either appended to the Transaction Cache (TC) or to the
33 # Statement Cache (SC) or written directly to the binlog.
34 #
35 # - Preliminary Rules
36 #
37 # The following preliminary rules are actually consequences of the principle
38 # that statements shall be correctly logged when binlog_format=MIXED or ROW.
39 # They also apply when binlog_format=STATEMENT: this makes statement format
40 # work in many practical cases.
41 #
42 # * (Causality) If statement A is executed before statement B, and B is logged
43 # in statement format, and B reads tables that A may modifies, then B shall be
44 # logged after A.
45 #
46 # * (Durability) Events shall be written to the binary log at the moment they
47 # take effect. In particular, changes to N-tables shall be written to the
48 # binary log when they have been executed, and changes to T-tables shall be
49 # written to the binary log on commit. If --sync-binlog has been specified,
50 # then it suffices that events are be written to the binary log at the next
51 # synchronization point.
52 #
53 # * (causality-precedence) If causality and durability cannot both be
54 # fulfilled, then casuality is considered more important.
55 #
56 # - Rules for non-committing statements, except CREATE TEMPORARY TABLE...SELECT
57 #
58 # The preliminary rules above, together with the principles for logging format
59 # , have been used to construct the following rules.
60 #
61 # CALL statements are unrolled, so that each statement executed by the stored
62 # procedure is logged separately. (If a stored procedure A invokes a stored
63 # procedure B, then B is unrolled recursively). In the following, we assume
64 # that unrolling has already been done, and the word "statement" refers to a
65 # non-CALL top-level statement or a non-CALL sub-statement.
66 #
67 # Let S be a logged statement that does not have an implicit commit, except
68 # CREATE TEMPORARY TABLE...SELECT (This includes all "pure DML": INSERT,
69 # UPDATE, DELETE, REPLACE, TRUNCATE, SELECT, DO, CALL, EXECUTE, LOAD DATA
70 # INFILE, and BINLOG. It also includes CREATE TEMPORARY TABLE without SELECT,
71 # and DROP TEMPORARY TABLE. CREATE TEMPORARY TABLE...SELECT is handled in the
72 # next subsection).
73 #
74 # Before executing S, determine unsafeness:
75 #
76 # * If S either makes N-writes or reads from an N-table, and either S or a
77 # previous statement in the same transaction reads or writes to a T-table,
78 # then S is marked as unsafe.
79 #
80 # When logging S, determine where to log it by applying the following rules in
81 # order:
82 #
83 # * If S is to be logged in statement format (i.e., if one of the following
84 # holds: (1) STATEMENT; (2) MIXED and S is safe; (3) S is of DDL type, i.e.,
85 # CREATE TEMPORARY TABLE):
86 # 1. If S produces an error and does not do any N-write, do not log.
87 # 2. Otherwise, if either S or any previous statement in the same
88 # transaction reads or writes in any T-tables, log to TC.
89 # 3. Otherwise, log to SC.
90 #
91 # * If S is to be logged in row format (i.e., if S is DML and one of the
92 # following holds: (1) ROW; (2) MIXED and S is unsafe):
93 # 1. Do not log row events that write to temporary tables.
94 # 2. Log row events that write to non-temporary N-tables to SC.
95 # 3. Log row events that write to non-temporary T-tables to TC, except
96 # rows that are rolled back due to an error. (Note: if there is an error,
97 # rows written to a T-table are kept if there are subsequent rows written
98 # to an N-table.)
99 #
100 # * At the end of S, write BEGIN + SC + COMMIT to the binlog and clear the
101 # SC.
102 #
103 # At end of transaction:
104 #
105 # * At COMMIT or implicit commit, where all XA tables in the transaction
106 # succeed in the "prepare" phase:
107 # 1. If the TC is non-empty, write BEGIN + TC + COMMIT to the binlog.
108 # 2. If the TC is empty, do nothing.
109 #
110 # * At ROLLBACK; or at COMMIT or implicit commit where some XA table fails
111 # in the "prepare" phase:
112 # 1. If the TC contains any N-write, write BEGIN + TC + ROLLBACK to the
113 # binlog.
114 # 2. If the TC does not contain any N-write, do nothing.
115 #
116 # * At ROLLBACK TO SAVEPOINT:
117 # 1. If the TC contains any N-write after the savepoint, write ROLLBACK TO
118 # SAVEPOINT to the TC.
119 # 2. Otherwise, clear the part of the TC that starts at the savepoint and
120 # extends to the end of the TC. (Bug#47327 breaks this rule)
121 #
122 # * Clear the TC at the end of the transaction.
123 #
124 # - Rules for CREATE [TEMPORARY] TABLE...SELECT
125 #
126 # First, unsafeness is determined as above (R-unsafe-transaction). Then the
127 # logging format is decided. Then the following rules apply.
128 #
129 # * If logging in statement format (i.e., one of the following holds: (1)
130 # STATEMENT; (2) MIXED and statement is safe):
131 # 1. If there is an error, do not write anything.
132 # 2. If there is no error and the TEMPORARY keyword is used, write the
133 # entire CREATE...SELECT statement to the TC.
134 # 3. If there is no error and the TEMPORARY keyword is not used, write the
135 # entire CREATE...SELECT directly to the binlog.
136 #
137 # * If logging in row format (i.e., one of the following holds: (1) ROW; (2)
138 # MIXED and statement is unsafe):
139 # 1. If the TEMPORARY keyword is used, do not write anything.
140 # 2. If the TEMPORARY keyword is not used, write CREATE TABLE (without
141 # select) + BEGIN + row events + COMMIT to the TC. If there is an error,
142 # clear the TC; otherwise flush the TC to the binlog at the end of the
143 # statement and then clear the TC. (Note: currently Bug#47899 breaks this
144 # rule)
145 #
146 # - Rules for committing statements, except CREATE [TEMPORARY] TABLE...SELECT
147 #
148 # * All other statements that have a pre-commit are written directly to the
149 # binlog.
150 #
151 # We use the include file rpl_mixing_engines.inc to generate sql commands from a
152 # format string. The format string consists of a sequence of 'codes' separated
153 # by spaces. The following codes exist:
154 #
155 # - Define the scope of a transaction:
156 # B - Begin.
157 # C - Commit.
158 # R - Rollback.
159 # Sn - Savepoint Sn.
160 # Rn - Rollback to Sn.
161 #
162 # - Change only T-Tables:
163 # T - Updates a T-Table.
164 # T-trig - Updates T-Tables through a trigger.
165 # T-func - Updates T-Tables through a function.
166 # T-proc - Updates T-Tables through a procedure.
167 # eT - Fails while updating the first tuple in a T-Table.
168 # Te - Fails while updating an n-tuple (n > 1) in a T-Table.
169 # Te-trig - Fails while updating an n-tuple (n > 1) in a T-Table.
170 # Te-func - Fails while updating an n-tuple (n > 1) in a T-Table.
171 #
172 # - Change only N-Tables
173 # N - Updates a N-Table.
174 # N-trig - Updates N-Tables through a trigger.
175 # N-func - Updates N-Tables through a function.
176 # N-proc - Updates N-Tables through a procedure.
177 # eN - Fails while updating the first tuple in a N-Table.
178 # Ne - Fails while updating an n-tuple (n > 1) in a N-Table.
179 # Ne-trig - Fails while updating an n-tuple (n > 1) in a N-Table.
180 # Ne-func - Fails while updating an n-tuple (n > 1) in a N-Table.
181 #
182 # - Read T-table and write N-table:
183 # tN - Updates a N-Table
184 # tNe - Fails while updating an n-tuple (n > 1) in a N-Table.
185 #
186 # - Read N-table and write T-table:
187 # nT - Updates a T-Table.
188 # nTe - Fails while updating an n-tuple (n > 1) in a T-Table.
189 #
190 # - Update both types of tables. First a N-Table and the a T-Table:
191 # NT - Upates both types of tables through an update statement.
192 # NT-trig - Updates both types of tables through a trigger.
193 # NT-func - Updates both types of tables through a procedure.
194 # NeT-trig - Fails while updating an n-tuple (n > 1) in a T-Table.
195 # NeT-func - Fails while updating an n-tuple (n > 1) in a T-Table.
196 #
197 # - Update both types of tables. First a T-Table and the a N-Table:
198 # TN - Upates both types of tables through an update statement.
199 # TN-trig - Updates both types of tables through a trigger.
200 # TN-func - Updates both types of tables through a procedure.
201 # TeN-trig - Fails while updating an n-tuple (n > 1) in a N-Table.
202 # TeN-func - Fails while updating an n-tuple (n > 1) in a N-Table.
203 #
204 # - This is CREATE...SELECT:
205 # CS-T->T - Creates a T-table selecting from a T-table.
206 # CS-N->N - Creates a N-table selecting from a N-table.
207 # CS-T->N - Creates a T-table selecting form a N-table.
208 # CS-N->T - Creates a N-table selecting from a T-table.
209 # CSe-T->T - Fails while creating a T-table selecting from a T-table.
210 # CSe-N->N - Fails while creating a N-table selecting from a N-table.
211 # CSe-T->N - Fails while creating a T-table selecting from a a N-table.
212 # CSe-N->T - Fails while creating a N-table selecting from a T-table.
213 # drop-CS - Drops any of the tables previously created.
214 # trunc-CS-T - Truncates a T-table previously created.
215 # trunc-CS-N - Truncates a N-table previously created.
216 # CT - Creates a temporary T-table.
217 # drop-CT - Drops a temporary T-table.
218 #
219 # - This is INSERT...SELECT:
220 # IS-T<-T - Inserts data from a T-table into a T-table.
221 # IS-T<-N - Inserts data from a N-table into a T-table.
222 # IS-N<-T - Inserts data from a T-table into a N-table.
223 # IS-N<-N - Inserts data from a N-table into a N-table.
224 # ISe-T<-T - Fails while inserting data from a T-table into a T-table.
225 # ISe-T<-N - Fails while inserting data from a N-table into a T-table.
226 # ISe-N<-T - Fails while inserting data from a T-table into a N-table.
227 # ISe-N<-N - Fails while inserting data from a N-table into a N-table.
228 #
229 # For the CREATE...SELECT and INSERT...SELECT, the table names are defined based
230 # on the variable $tb_id which is automatically incremented after each drop.
231 # This indirectly means that two tables cannot co-exist unless we manually keep
232 # the variable $tb_id.
233 #
234 # The format of the entries in the binlog depends on the mode and on the type
235 # statements: S - statement and R - row. And when it is clear from the context
236 # which statement is referred to, we sometimes use "M" to denote a "Mixed"
237 # statement, i.e., one that accesses both a T-table and an N-table.
238 #
239 # For further details, please, read WL#2687 and WL#5072.
240 ################################################################################
241 --echo #########################################################################
242 --echo # CONFIGURATION
243 --echo #########################################################################
244
245 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
246
247 --source include/big_test.inc
248
249 --let $verbose= 1
250 --let $commands= configure
251 --source suite/rpl/include/rpl_mixing_engines.inc
252
253 --echo #########################################################################
254 --echo # 1 - MIXING TRANSACTIONAL and NON-TRANSACTIONAL TABLES
255 --echo #########################################################################
256 connection master;
257
258 --echo
259 --echo
260 --echo
261 --echo
262 --echo #
263 --echo #1) Generates in the binlog what follows:
264 --echo # --> STMT "B T C" entries, format S.
265 --echo # --> ROW "B T C" entries, format R.
266 --echo # --> MIXED "B T C" entries, format S.
267 --echo #
268 --let $commands= T
269 --source suite/rpl/include/rpl_mixing_engines.inc
270
271 --let $commands= T-trig
272 --source suite/rpl/include/rpl_mixing_engines.inc
273
274 --let $commands= T-func
275 --source suite/rpl/include/rpl_mixing_engines.inc
276
277 --let $commands= T-proc
278 --source suite/rpl/include/rpl_mixing_engines.inc
279
280
281 --echo
282 --echo
283 --echo
284 --echo
285 --echo #
286 --echo #1.e) Generates in the binlog what follows:
287 --echo # --> STMT empty.
288 --echo # --> ROW empty.
289 --echo # --> MIXED empty.
290 --echo #
291 --let $commands= eT
292 --source suite/rpl/include/rpl_mixing_engines.inc
293
294 --let $commands= Te
295 --source suite/rpl/include/rpl_mixing_engines.inc
296
297 --let $commands= Te-trig
298 --source suite/rpl/include/rpl_mixing_engines.inc
299
300 --let $commands= Te-func
301 --source suite/rpl/include/rpl_mixing_engines.inc
302
303 --echo
304 --echo
305 --echo
306 --echo
307 --echo #
308 --echo #2) Generates in the binlog what follows:
309 --echo # --> STMT "B N C" entry, format S.
310 --echo # --> ROW "B N C" entry, format R.
311 --echo # --> MIXED "B N C" entry, format S.
312 --echo #
313 --let $commands= N
314 --source suite/rpl/include/rpl_mixing_engines.inc
315
316 --let $commands= N-trig
317 --source suite/rpl/include/rpl_mixing_engines.inc
318
319 --let $commands= N-func
320 --source suite/rpl/include/rpl_mixing_engines.inc
321
322 --let $commands= N-proc
323 --source suite/rpl/include/rpl_mixing_engines.inc
324
325
326 --echo
327 --echo
328 --echo
329 --echo
330 --echo #
331 --echo #2.e) Generates in the binlog what follows if a N-table is changed:
332 --echo # --> STMT "B N C" entry, format S.
333 --echo # --> ROW "B N C" entry, format R.
334 --echo # --> MIXED "B N C" entry, format S.
335 --echo #
336 --let $commands= eN
337 --source suite/rpl/include/rpl_mixing_engines.inc
338
339 --let $commands= Ne
340 --source suite/rpl/include/rpl_mixing_engines.inc
341
342 --let $commands= Ne-trig
343 --source suite/rpl/include/rpl_mixing_engines.inc
344
345 --let $commands= Ne-func
346 --source suite/rpl/include/rpl_mixing_engines.inc
347
348 --echo
349 --echo
350 --echo
351 --echo
352 --echo #
353 --echo #3) Generates in the binlog what follows:
354 --echo # --> STMT "B M C" entry if only N-Table is changed, format S.
355 --echo # --> STMT "B M C" entries, format S.
356 --echo # --> ROW "B N T B T C" entries, format R.
357 --echo # --> MIXED "B N T B T C" entries, format R.
358 --echo #
359 --let $commands= tN
360 --source suite/rpl/include/rpl_mixing_engines.inc
361
362 --let $commands= nT
363 --source suite/rpl/include/rpl_mixing_engines.inc
364
365 --let $commands= NT
366 --source suite/rpl/include/rpl_mixing_engines.inc
367
368 --let $commands= NT-trig
369 --source suite/rpl/include/rpl_mixing_engines.inc
370
371 --let $commands= NT-func
372 --source suite/rpl/include/rpl_mixing_engines.inc
373
374 --let $commands= TN
375 --source suite/rpl/include/rpl_mixing_engines.inc
376
377 --let $commands= TN-trig
378 --source suite/rpl/include/rpl_mixing_engines.inc
379
380 --let $commands= TN-func
381 --source suite/rpl/include/rpl_mixing_engines.inc
382
383
384 --echo
385 --echo
386 --echo
387 --echo
388 --echo #
389 --echo #3.e) Generates in the binlog what follows:
390 --echo # --> STMT "B M C" entry if only N-Table is changed, format S.
391 --echo # --> STMT "B M R" entries, format S.
392 --echo # --> ROW "B N C" entry, format R.
393 --echo # --> MIXED "B N C" entry, format R.
394 --let $commands= tNe
395 --source suite/rpl/include/rpl_mixing_engines.inc
396
397 --let $commands= nTe
398 --source suite/rpl/include/rpl_mixing_engines.inc
399
400 --let $commands= NeT-trig
401 --source suite/rpl/include/rpl_mixing_engines.inc
402
403 --let $commands= NeT-func
404 --source suite/rpl/include/rpl_mixing_engines.inc
405
406 --let $commands= TeN-trig
407 --source suite/rpl/include/rpl_mixing_engines.inc
408
409 --let $commands= TeN-func
410 --source suite/rpl/include/rpl_mixing_engines.inc
411
412 --echo
413 --echo
414 --echo
415 --echo
416 --echo #
417 --echo #4) Generates in the binlog what follows:
418 --echo # --> STMT "B T T C" entries, format S.
419 --echo # --> ROW "B T T C" entries, format R.
420 --echo # --> MIXED "B T T C" entries, format S
421 --echo #
422 --let $commands= B T T C
423 --source suite/rpl/include/rpl_mixing_engines.inc
424
425 --let $commands= B T T-trig C
426 --source suite/rpl/include/rpl_mixing_engines.inc
427
428 --let $commands= B T T-func C
429 --source suite/rpl/include/rpl_mixing_engines.inc
430
431 --let $commands= B T T-proc C
432 --source suite/rpl/include/rpl_mixing_engines.inc
433
434 --let $commands= B T-trig T C
435 --source suite/rpl/include/rpl_mixing_engines.inc
436
437 --let $commands= B T-trig T-trig C
438 --source suite/rpl/include/rpl_mixing_engines.inc
439
440 --let $commands= B T-trig T-func C
441 --source suite/rpl/include/rpl_mixing_engines.inc
442
443 --let $commands= B T-trig T-proc C
444 --source suite/rpl/include/rpl_mixing_engines.inc
445
446 --let $commands= B T-func T C
447 --source suite/rpl/include/rpl_mixing_engines.inc
448
449 --let $commands= B T-func T-trig C
450 --source suite/rpl/include/rpl_mixing_engines.inc
451
452 --let $commands= B T-func T-func C
453 --source suite/rpl/include/rpl_mixing_engines.inc
454
455 --let $commands= B T-func T-proc C
456 --source suite/rpl/include/rpl_mixing_engines.inc
457
458 --let $commands= B T-proc T C
459 --source suite/rpl/include/rpl_mixing_engines.inc
460
461 --let $commands= B T-proc T-trig C
462 --source suite/rpl/include/rpl_mixing_engines.inc
463
464 --let $commands= B T-proc T-func C
465 --source suite/rpl/include/rpl_mixing_engines.inc
466
467 --let $commands= B T-proc T-proc C
468 --source suite/rpl/include/rpl_mixing_engines.inc
469
470
471 --echo
472 --echo
473 --echo
474 --echo
475 --echo #
476 --echo #4.e) Generates in the binlog what follows:
477 --echo # --> STMT "B T C" entries, format S.
478 --echo # --> ROW "B T C" entries, format R.
479 --echo # --> MIXED "B T C" entries, format S.
480 --echo #
481 --let $commands= B T eT C
482 --source suite/rpl/include/rpl_mixing_engines.inc
483
484 --let $commands= B T Te C
485 --source suite/rpl/include/rpl_mixing_engines.inc
486
487 --let $commands= B T Te-trig C
488 --source suite/rpl/include/rpl_mixing_engines.inc
489
490 --let $commands= B T Te-func C
491 --source suite/rpl/include/rpl_mixing_engines.inc
492
493 --let $commands= B eT T C
494 --source suite/rpl/include/rpl_mixing_engines.inc
495
496 --let $commands= B Te T C
497 --source suite/rpl/include/rpl_mixing_engines.inc
498
499 --let $commands= B Te-trig T C
500 --source suite/rpl/include/rpl_mixing_engines.inc
501
502 --let $commands= B Te-func T C
503 --source suite/rpl/include/rpl_mixing_engines.inc
504
505
506 --echo
507 --echo
508 --echo
509 --echo
510 --echo #
511 --echo #5) Generates in the binlog what follows:
512 --echo # --> STMT empty.
513 --echo # --> ROW empty.
514 --echo # --> MIXED empty.
515 --echo #
516 --let $commands= B T T R
517 --source suite/rpl/include/rpl_mixing_engines.inc
518
519 --let $commands= B T T-trig R
520 --source suite/rpl/include/rpl_mixing_engines.inc
521
522 --let $commands= B T T-func R
523 --source suite/rpl/include/rpl_mixing_engines.inc
524
525 --let $commands= B T T-proc R
526 --source suite/rpl/include/rpl_mixing_engines.inc
527
528 --let $commands= B T-trig T R
529 --source suite/rpl/include/rpl_mixing_engines.inc
530
531 --let $commands= B T-trig T-trig R
532 --source suite/rpl/include/rpl_mixing_engines.inc
533
534 --let $commands= B T-trig T-func R
535 --source suite/rpl/include/rpl_mixing_engines.inc
536
537 --let $commands= B T-trig T-proc R
538 --source suite/rpl/include/rpl_mixing_engines.inc
539
540 --let $commands= B T-func T R
541 --source suite/rpl/include/rpl_mixing_engines.inc
542
543 --let $commands= B T-func T-trig R
544 --source suite/rpl/include/rpl_mixing_engines.inc
545
546 --let $commands= B T-func T-func R
547 --source suite/rpl/include/rpl_mixing_engines.inc
548
549 --let $commands= B T-func T-proc R
550 --source suite/rpl/include/rpl_mixing_engines.inc
551
552 --let $commands= B T-proc T R
553 --source suite/rpl/include/rpl_mixing_engines.inc
554
555 --let $commands= B T-proc T-trig R
556 --source suite/rpl/include/rpl_mixing_engines.inc
557
558 --let $commands= B T-proc T-func R
559 --source suite/rpl/include/rpl_mixing_engines.inc
560
561 --let $commands= B T-proc T-proc R
562 --source suite/rpl/include/rpl_mixing_engines.inc
563
564
565 --echo
566 --echo
567 --echo
568 --echo
569 --echo #
570 --echo #5.e) Generates in the binlog what follows:
571 --echo # --> STMT empty.
572 --echo # --> ROW empty.
573 --echo # --> MIXED empty.
574 --echo #
575 --let $commands= B T eT R
576 --source suite/rpl/include/rpl_mixing_engines.inc
577
578 --let $commands= B T Te R
579 --source suite/rpl/include/rpl_mixing_engines.inc
580
581 --let $commands= B T Te-trig R
582 --source suite/rpl/include/rpl_mixing_engines.inc
583
584 --let $commands= B T Te-func R
585 --source suite/rpl/include/rpl_mixing_engines.inc
586
587 --let $commands= B eT T R
588 --source suite/rpl/include/rpl_mixing_engines.inc
589
590 --let $commands= B Te T R
591 --source suite/rpl/include/rpl_mixing_engines.inc
592
593 --let $commands= B Te-trig T R
594 --source suite/rpl/include/rpl_mixing_engines.inc
595
596 --let $commands= B Te-func T R
597 --source suite/rpl/include/rpl_mixing_engines.inc
598
599
600 --echo
601 --echo
602 --echo
603 --echo
604 --echo #
605 --echo #6) Generates in the binlog what follows:
606 --echo # --> STMT "B N C B N C" entries, format S.
607 --echo # --> ROW "B N C B N C" entries, format R.
608 --echo # --> MIXED "B N C B N C" entries, format S.
609 --echo #
610 --let $commands= B N N C
611 --source suite/rpl/include/rpl_mixing_engines.inc
612
613 --let $commands= B N N-trig C
614 --source suite/rpl/include/rpl_mixing_engines.inc
615
616 --let $commands= B N N-func C
617 --source suite/rpl/include/rpl_mixing_engines.inc
618
619 --let $commands= B N N-proc C
620 --source suite/rpl/include/rpl_mixing_engines.inc
621
622 --let $commands= B N-trig N C
623 --source suite/rpl/include/rpl_mixing_engines.inc
624
625 --let $commands= B N-trig N-trig C
626 --source suite/rpl/include/rpl_mixing_engines.inc
627
628 --let $commands= B N-trig N-func C
629 --source suite/rpl/include/rpl_mixing_engines.inc
630
631 --let $commands= B N-trig N-proc C
632 --source suite/rpl/include/rpl_mixing_engines.inc
633
634 --let $commands= B N-func N C
635 --source suite/rpl/include/rpl_mixing_engines.inc
636
637 --let $commands= B N-func N-trig C
638 --source suite/rpl/include/rpl_mixing_engines.inc
639
640 --let $commands= B N-func N-func C
641 --source suite/rpl/include/rpl_mixing_engines.inc
642
643 --let $commands= B N-func N-proc C
644 --source suite/rpl/include/rpl_mixing_engines.inc
645
646 --let $commands= B N-proc N C
647 --source suite/rpl/include/rpl_mixing_engines.inc
648
649 --let $commands= B N-proc N-trig C
650 --source suite/rpl/include/rpl_mixing_engines.inc
651
652 --let $commands= B N-proc N-func C
653 --source suite/rpl/include/rpl_mixing_engines.inc
654
655 --let $commands= B N-proc N-proc C
656 --source suite/rpl/include/rpl_mixing_engines.inc
657
658
659 --echo
660 --echo
661 --echo
662 --echo
663 --echo #
664 --echo #6.e) Generates in the binlog what follows if a N-Table is changed:
665 --echo # --> STMT "B N C B N C" entries, format S.
666 --echo # --> ROW "B N C B N C" entries, format R.
667 --echo # --> MIXED "B N C B N C" entries, format S.
668 --echo #
669 --let $commands= B N eN C
670 --source suite/rpl/include/rpl_mixing_engines.inc
671
672 --let $commands= B N Ne C
673 --source suite/rpl/include/rpl_mixing_engines.inc
674
675 --let $commands= B N Ne-trig C
676 --source suite/rpl/include/rpl_mixing_engines.inc
677
678 --let $commands= B N Ne-func C
679 --source suite/rpl/include/rpl_mixing_engines.inc
680
681 --let $commands= B eN N C
682 --source suite/rpl/include/rpl_mixing_engines.inc
683
684 --let $commands= B Ne N C
685 --source suite/rpl/include/rpl_mixing_engines.inc
686
687 --let $commands= B Ne-trig N C
688 --source suite/rpl/include/rpl_mixing_engines.inc
689
690 --let $commands= B Ne-func N C
691 --source suite/rpl/include/rpl_mixing_engines.inc
692
693
694 --echo
695 --echo
696 --echo
697 --echo
698 --echo #
699 --echo #7) Generates in the binlog what follows:
700 --echo # --> STMT "B N C B N C" entries, format S.
701 --echo # --> ROW "B N C B N C" entries, format R.
702 --echo # --> MIXED "B N C B N C" entries, format S.
703 --echo #
704 --let $commands= B N N R
705 --source suite/rpl/include/rpl_mixing_engines.inc
706
707 --let $commands= B N N-trig R
708 --source suite/rpl/include/rpl_mixing_engines.inc
709
710 --let $commands= B N N-func R
711 --source suite/rpl/include/rpl_mixing_engines.inc
712
713 --let $commands= B N N-proc R
714 --source suite/rpl/include/rpl_mixing_engines.inc
715
716 --let $commands= B N-trig N R
717 --source suite/rpl/include/rpl_mixing_engines.inc
718
719 --let $commands= B N-trig N-trig R
720 --source suite/rpl/include/rpl_mixing_engines.inc
721
722 --let $commands= B N-trig N-func R
723 --source suite/rpl/include/rpl_mixing_engines.inc
724
725 --let $commands= B N-trig N-proc R
726 --source suite/rpl/include/rpl_mixing_engines.inc
727
728 --let $commands= B N-func N R
729 --source suite/rpl/include/rpl_mixing_engines.inc
730
731 --let $commands= B N-func N-trig R
732 --source suite/rpl/include/rpl_mixing_engines.inc
733
734 --let $commands= B N-func N-func R
735 --source suite/rpl/include/rpl_mixing_engines.inc
736
737 --let $commands= B N-func N-proc R
738 --source suite/rpl/include/rpl_mixing_engines.inc
739
740 --let $commands= B N-proc N R
741 --source suite/rpl/include/rpl_mixing_engines.inc
742
743 --let $commands= B N-proc N-trig R
744 --source suite/rpl/include/rpl_mixing_engines.inc
745
746 --let $commands= B N-proc N-func R
747 --source suite/rpl/include/rpl_mixing_engines.inc
748
749 --let $commands= B N-proc N-proc R
750 --source suite/rpl/include/rpl_mixing_engines.inc
751
752
753 --echo
754 --echo
755 --echo
756 --echo
757 --echo #
758 --echo #7.e) Generates in the binlog what follows if a N-Table is changed:
759 --echo # --> STMT "B N C B N C" entries, format S.
760 --echo # --> ROW "B N C B N C" entries, format R.
761 --echo # --> MIXED "B N C B N C" entries, format S.
762 --echo #
763 --let $commands= B N eN R
764 --source suite/rpl/include/rpl_mixing_engines.inc
765
766 --let $commands= B N Ne R
767 --source suite/rpl/include/rpl_mixing_engines.inc
768
769 --let $commands= B N Ne-trig R
770 --source suite/rpl/include/rpl_mixing_engines.inc
771
772 --let $commands= B N Ne-func R
773 --source suite/rpl/include/rpl_mixing_engines.inc
774
775 --let $commands= B eN N R
776 --source suite/rpl/include/rpl_mixing_engines.inc
777
778 --let $commands= B Ne N R
779 --source suite/rpl/include/rpl_mixing_engines.inc
780
781 --let $commands= B Ne-trig N R
782 --source suite/rpl/include/rpl_mixing_engines.inc
783
784 --let $commands= B Ne-func N R
785 --source suite/rpl/include/rpl_mixing_engines.inc
786
787
788 --echo
789 --echo
790 --echo
791 --echo
792 --echo #
793 --echo #8) Generates in the binlog what follows:
794 --echo # --> STMT "B T N C" entries, format S.
795 --echo # --> ROW "B N C B T C" entries, format R.
796 --echo # --> MIXED "B N C B T C" entries, format R in N and S in T.
797 --echo #
798 --let $commands= B T N C
799 --source suite/rpl/include/rpl_mixing_engines.inc
800
801 --let $commands= B T N-trig C
802 --source suite/rpl/include/rpl_mixing_engines.inc
803
804 --let $commands= B T N-func C
805 --source suite/rpl/include/rpl_mixing_engines.inc
806
807 --let $commands= B T N-proc C
808 --source suite/rpl/include/rpl_mixing_engines.inc
809
810 --let $commands= B T-trig N C
811 --source suite/rpl/include/rpl_mixing_engines.inc
812
813 --let $commands= B T-trig N-trig C
814 --source suite/rpl/include/rpl_mixing_engines.inc
815
816 --let $commands= B T-trig N-func C
817 --source suite/rpl/include/rpl_mixing_engines.inc
818
819 --let $commands= B T-trig N-proc C
820 --source suite/rpl/include/rpl_mixing_engines.inc
821
822 --let $commands= B T-func N C
823 --source suite/rpl/include/rpl_mixing_engines.inc
824
825 --let $commands= B T-func N-trig C
826 --source suite/rpl/include/rpl_mixing_engines.inc
827
828 --let $commands= B T-func N-func C
829 --source suite/rpl/include/rpl_mixing_engines.inc
830
831 --let $commands= B T-func N-proc C
832 --source suite/rpl/include/rpl_mixing_engines.inc
833
834 --let $commands= B T-proc N C
835 --source suite/rpl/include/rpl_mixing_engines.inc
836
837 --let $commands= B T-proc N-trig C
838 --source suite/rpl/include/rpl_mixing_engines.inc
839
840 --let $commands= B T-proc N-func C
841 --source suite/rpl/include/rpl_mixing_engines.inc
842
843 --let $commands= B T-proc N-proc C
844 --source suite/rpl/include/rpl_mixing_engines.inc
845
846
847 --echo
848 --echo
849 --echo
850 --echo
851 --echo #
852 --echo #8.e) Generates in the binlog what follows if T-* fails:
853 --echo # --> STMT "B N C" entry, format S.
854 --echo # --> ROW "B N C" entry, format R.
855 --echo # --> MIXED "B N C" entry, format R.
856 --echo # Otherwise, what follows if N-* fails and a N-Table is changed:
857 --echo # --> STMT "B T N C" entries, format S.
858 --echo # --> ROW "B N C B T C" entries, format R.
859 --echo # --> MIXED "B N C B T C" entries, format R in N and S in T.
860 --echo #
861 --let $commands= B eT N C
862 --source suite/rpl/include/rpl_mixing_engines.inc
863
864 --let $commands= B Te N C
865 --source suite/rpl/include/rpl_mixing_engines.inc
866
867 --let $commands= B T eN C
868 --source suite/rpl/include/rpl_mixing_engines.inc
869
870 --let $commands= B T Ne C
871 --source suite/rpl/include/rpl_mixing_engines.inc
872
873
874 --echo
875 --echo
876 --echo
877 --echo
878 --echo #
879 --echo #9) Generates in the binlog what follows:
880 --echo # --> STMT "B T N R" entries, format S.
881 --echo # --> ROW "B N C" entry, format R.
882 --echo # --> MIXED "B N C" entry, format R.
883 --echo #
884 --let $commands= B T N R
885 --source suite/rpl/include/rpl_mixing_engines.inc
886
887 --let $commands= B T N-trig R
888 --source suite/rpl/include/rpl_mixing_engines.inc
889
890 --let $commands= B T N-func R
891 --source suite/rpl/include/rpl_mixing_engines.inc
892
893 --let $commands= B T N-proc R
894 --source suite/rpl/include/rpl_mixing_engines.inc
895
896 --let $commands= B T-trig N R
897 --source suite/rpl/include/rpl_mixing_engines.inc
898
899 --let $commands= B T-trig N-trig R
900 --source suite/rpl/include/rpl_mixing_engines.inc
901
902 --let $commands= B T-trig N-func R
903 --source suite/rpl/include/rpl_mixing_engines.inc
904
905 --let $commands= B T-trig N-proc R
906 --source suite/rpl/include/rpl_mixing_engines.inc
907
908 --let $commands= B T-func N R
909 --source suite/rpl/include/rpl_mixing_engines.inc
910
911 --let $commands= B T-func N-trig R
912 --source suite/rpl/include/rpl_mixing_engines.inc
913
914 --let $commands= B T-func N-func R
915 --source suite/rpl/include/rpl_mixing_engines.inc
916
917 --let $commands= B T-func N-proc R
918 --source suite/rpl/include/rpl_mixing_engines.inc
919
920 --let $commands= B T-proc N R
921 --source suite/rpl/include/rpl_mixing_engines.inc
922
923 --let $commands= B T-proc N-trig R
924 --source suite/rpl/include/rpl_mixing_engines.inc
925
926 --let $commands= B T-proc N-func R
927 --source suite/rpl/include/rpl_mixing_engines.inc
928
929 --let $commands= B T-proc N-proc R
930 --source suite/rpl/include/rpl_mixing_engines.inc
931
932
933 --echo
934 --echo
935 --echo
936 --echo
937 --echo #
938 --echo #9.e) Generates in the binlog what follows if T* fails:
939 --echo # --> STMT "B N C" entry, format S.
940 --echo # --> ROW "B N C" entry, format R.
941 --echo # --> MIXED "B N C" entry, format R.
942 --echo # Otherwise, what follows if N* fails and a N-Table is changed:
943 --echo # --> STMT "B T N R" entries, format S.
944 --echo # --> ROW "B N C" entry, format R.
945 --echo # --> MIXED "B N C" entry, format R.
946 --echo #
947 --let $commands= B eT N R
948 --source suite/rpl/include/rpl_mixing_engines.inc
949
950 --let $commands= B Te N R
951 --source suite/rpl/include/rpl_mixing_engines.inc
952
953 --let $commands= B T eN R
954 --source suite/rpl/include/rpl_mixing_engines.inc
955
956 --let $commands= B T Ne R
957 --source suite/rpl/include/rpl_mixing_engines.inc
958
959
960
961 --echo
962 --echo
963 --echo
964 --echo
965 --echo #
966 --echo #10) Generates in the binlog:
967 --echo # --> STMT "B N C B T C" entries, format S.
968 --echo # --> ROW "B N C B T C" entries, format R.
969 --echo # --> MIXED "B N C B T C" entries, format S.
970 --echo #
971 --let $commands= B N T C
972 --source suite/rpl/include/rpl_mixing_engines.inc
973
974 --let $commands= B N T-trig C
975 --source suite/rpl/include/rpl_mixing_engines.inc
976
977 --let $commands= B N T-func C
978 --source suite/rpl/include/rpl_mixing_engines.inc
979
980 --let $commands= B N T-proc C
981 --source suite/rpl/include/rpl_mixing_engines.inc
982
983 --let $commands= B N-trig T C
984 --source suite/rpl/include/rpl_mixing_engines.inc
985
986 --let $commands= B N-trig T-trig C
987 --source suite/rpl/include/rpl_mixing_engines.inc
988
989 --let $commands= B N-trig T-func C
990 --source suite/rpl/include/rpl_mixing_engines.inc
991
992 --let $commands= B N-trig T-proc C
993 --source suite/rpl/include/rpl_mixing_engines.inc
994
995 --let $commands= B N-func T C
996 --source suite/rpl/include/rpl_mixing_engines.inc
997
998 --let $commands= B N-func T-trig C
999 --source suite/rpl/include/rpl_mixing_engines.inc
1000
1001 --let $commands= B N-func T-func C
1002 --source suite/rpl/include/rpl_mixing_engines.inc
1003
1004 --let $commands= B N-func T-proc C
1005 --source suite/rpl/include/rpl_mixing_engines.inc
1006
1007 --let $commands= B N-proc T C
1008 --source suite/rpl/include/rpl_mixing_engines.inc
1009
1010 --let $commands= B N-proc T-trig C
1011 --source suite/rpl/include/rpl_mixing_engines.inc
1012
1013 --let $commands= B N-proc T-func C
1014 --source suite/rpl/include/rpl_mixing_engines.inc
1015
1016 --let $commands= B N-proc T-proc C
1017 --source suite/rpl/include/rpl_mixing_engines.inc
1018
1019
1020 --echo
1021 --echo
1022 --echo
1023 --echo
1024 --echo #
1025 --echo #11) Generates in the binlog what follows:
1026 --echo # --> STMT "B N C" entries, format S.
1027 --echo # --> ROW "B N C" entries, format R.
1028 --echo # --> MIXED "B N C" entries, format S.
1029 --echo #
1030
1031 --let $commands= B N T R
1032 --source suite/rpl/include/rpl_mixing_engines.inc
1033
1034 --let $commands= B N T-proc R
1035 --source suite/rpl/include/rpl_mixing_engines.inc
1036
1037 --let $commands= B N T-trig R
1038 --source suite/rpl/include/rpl_mixing_engines.inc
1039
1040 --let $commands= B N T-func R
1041 --source suite/rpl/include/rpl_mixing_engines.inc
1042
1043 --let $commands= B N-trig T R
1044 --source suite/rpl/include/rpl_mixing_engines.inc
1045
1046 --let $commands= B N-trig T-trig R
1047 --source suite/rpl/include/rpl_mixing_engines.inc
1048
1049 --let $commands= B N-trig T-func R
1050 --source suite/rpl/include/rpl_mixing_engines.inc
1051
1052 --let $commands= B N-trig T-proc R
1053 --source suite/rpl/include/rpl_mixing_engines.inc
1054
1055 --let $commands= B N-func T R
1056 --source suite/rpl/include/rpl_mixing_engines.inc
1057
1058 --let $commands= B N-func T-trig R
1059 --source suite/rpl/include/rpl_mixing_engines.inc
1060
1061 --let $commands= B N-func T-func R
1062 --source suite/rpl/include/rpl_mixing_engines.inc
1063
1064 --let $commands= B N-func T-proc R
1065 --source suite/rpl/include/rpl_mixing_engines.inc
1066
1067 --let $commands= B N-proc T R
1068 --source suite/rpl/include/rpl_mixing_engines.inc
1069
1070 --let $commands= B N-proc T-proc R
1071 --source suite/rpl/include/rpl_mixing_engines.inc
1072
1073 --let $commands= B N-proc T-trig R
1074 --source suite/rpl/include/rpl_mixing_engines.inc
1075
1076 --let $commands= B N-proc T-func R
1077 --source suite/rpl/include/rpl_mixing_engines.inc
1078
1079
1080 --echo
1081 --echo
1082 --echo
1083 --echo
1084 --echo #
1085 --echo #12) Generates in the binlog what follows:
1086 --echo # --> STMT "B M C B T C" entries if in M only N-Table is changed, format S.
1087 --echo # --> STMT "B M T C" entries, format S.
1088 --echo # --> ROW "B N C B T T C" entries, format R.
1089 --echo # --> MIXED "B N C B T T C" entries, format R in N/T and format S in T.
1090 --echo #
1091 --let $commands= B tN T C
1092 --source suite/rpl/include/rpl_mixing_engines.inc
1093
1094 --let $commands= B nT T C
1095 --source suite/rpl/include/rpl_mixing_engines.inc
1096
1097 --let $commands= B NT T C
1098 --source suite/rpl/include/rpl_mixing_engines.inc
1099
1100 --let $commands= B NT-trig T C
1101 --source suite/rpl/include/rpl_mixing_engines.inc
1102
1103 --let $commands= B NT-func T C
1104 --source suite/rpl/include/rpl_mixing_engines.inc
1105
1106 --let $commands= B TN T C
1107 --source suite/rpl/include/rpl_mixing_engines.inc
1108
1109 --let $commands= B TN-trig T C
1110 --source suite/rpl/include/rpl_mixing_engines.inc
1111
1112 --let $commands= B TN-func T C
1113 --source suite/rpl/include/rpl_mixing_engines.inc
1114
1115
1116 --echo
1117 --echo
1118 --echo
1119 --echo
1120 --echo #
1121 --echo #12.e) Generates in the binlog what follows if a N-Table is changed:
1122 --echo # --> STMT "B M C B T C" entries if in M only N-Table is changed, format S.
1123 --echo # --> STMT "B M T C" entries, format S.
1124 --echo # --> ROW "B N C B T T C" entries, format R.
1125 --echo # --> MIXED "B N C B T T C" entries, format R in N/T and format S in T.
1126 --echo #
1127 --let $commands= B tNe T C
1128 --source suite/rpl/include/rpl_mixing_engines.inc
1129
1130 --let $commands= B nTe T C
1131 --source suite/rpl/include/rpl_mixing_engines.inc
1132
1133 --let $commands= B NeT-trig T C
1134 --source suite/rpl/include/rpl_mixing_engines.inc
1135
1136 --let $commands= B NeT-func T C
1137 --source suite/rpl/include/rpl_mixing_engines.inc
1138
1139 --let $commands= B TeN-trig T C
1140 --source suite/rpl/include/rpl_mixing_engines.inc
1141
1142 --let $commands= B TeN-func T C
1143 --source suite/rpl/include/rpl_mixing_engines.inc
1144
1145
1146 --echo
1147 --echo
1148 --echo
1149 --echo
1150 --echo #
1151 --echo #13) "B M T R" generates in the binlog:
1152 --echo # --> STMT "B M C B T R" entries if in M only N-Table is changed, format S.
1153 --echo # --> STMT "B M T R" entries, format S.
1154 --echo # --> ROW "B N C" entry, format R.
1155 --echo # --> MIXED "B N C" entry, format R.
1156 --echo #
1157 --let $commands= B tN T R
1158 --source suite/rpl/include/rpl_mixing_engines.inc
1159
1160 --let $commands= B nT T R
1161 --source suite/rpl/include/rpl_mixing_engines.inc
1162
1163 --let $commands= B NT T R
1164 --source suite/rpl/include/rpl_mixing_engines.inc
1165
1166 --let $commands= B NT-trig T R
1167 --source suite/rpl/include/rpl_mixing_engines.inc
1168
1169 --let $commands= B NT-func T R
1170 --source suite/rpl/include/rpl_mixing_engines.inc
1171
1172 --let $commands= B TN T R
1173 --source suite/rpl/include/rpl_mixing_engines.inc
1174
1175 --let $commands= B TN-trig T R
1176 --source suite/rpl/include/rpl_mixing_engines.inc
1177
1178 --let $commands= B TN-func T R
1179 --source suite/rpl/include/rpl_mixing_engines.inc
1180
1181
1182 --echo
1183 --echo
1184 --echo
1185 --echo
1186 --echo #
1187 --echo #13.e) Generates in the binlog what follows if a N-Table is changed:
1188 --echo # --> STMT "B M C B T R" entries if in M only N-Table is changed, format S.
1189 --echo # --> STMT "B M T R" entries, format S.
1190 --echo # --> ROW "B N C" entry, format R.
1191 --echo # --> MIXED "B N C" entry, format R.
1192 --echo #
1193 --let $commands= B tNe T R
1194 --source suite/rpl/include/rpl_mixing_engines.inc
1195
1196 --let $commands= B nTe T R
1197 --source suite/rpl/include/rpl_mixing_engines.inc
1198
1199 --let $commands= B NeT-trig T R
1200 --source suite/rpl/include/rpl_mixing_engines.inc
1201
1202 --let $commands= B NeT-func T R
1203 --source suite/rpl/include/rpl_mixing_engines.inc
1204
1205 --let $commands= B TeN-trig T R
1206 --source suite/rpl/include/rpl_mixing_engines.inc
1207
1208 --let $commands= B TeN-func T R
1209 --source suite/rpl/include/rpl_mixing_engines.inc
1210
1211
1212 --echo
1213 --echo
1214 --echo
1215 --echo
1216 --echo #
1217 --echo #14) Generates in the binlog what follows if a N-Table is changed:
1218 --echo # --> STMT "B T M C" entries, format S.
1219 --echo # --> ROW "B N C B T T C" entries, format R.
1220 --echo # --> MIXED "B N C B T T C" entries, format R in N/T and format S in T.
1221 --echo #
1222 --let $commands= B T tN C
1223 --source suite/rpl/include/rpl_mixing_engines.inc
1224
1225 --let $commands= B T nT C
1226 --source suite/rpl/include/rpl_mixing_engines.inc
1227
1228 --let $commands= B T NT C
1229 --source suite/rpl/include/rpl_mixing_engines.inc
1230
1231 --let $commands= B T NT-trig C
1232 --source suite/rpl/include/rpl_mixing_engines.inc
1233
1234 --let $commands= B T NT-func C
1235 --source suite/rpl/include/rpl_mixing_engines.inc
1236
1237 --let $commands= B T TN C
1238 --source suite/rpl/include/rpl_mixing_engines.inc
1239
1240 --let $commands= B T TN-trig C
1241 --source suite/rpl/include/rpl_mixing_engines.inc
1242
1243 --let $commands= B T TN-func C
1244 --source suite/rpl/include/rpl_mixing_engines.inc
1245
1246
1247 --echo
1248 --echo
1249 --echo
1250 --echo
1251 --echo #
1252 --echo #14.e) Generates in the binlog what follows if a N-Table is changed:
1253 --echo # --> STMT "B T M C" entries, format S.
1254 --echo # --> ROW "B N C B T C" entry, format R.
1255 --echo # --> MIXED "B N C B T C" entry, format R.
1256 --echo #
1257 --let $commands= B T tNe C
1258 --source suite/rpl/include/rpl_mixing_engines.inc
1259
1260 --let $commands= B T nTe C
1261 --source suite/rpl/include/rpl_mixing_engines.inc
1262
1263 --let $commands= B T NeT-trig C
1264 --source suite/rpl/include/rpl_mixing_engines.inc
1265
1266 --let $commands= B T NeT-func C
1267 --source suite/rpl/include/rpl_mixing_engines.inc
1268
1269 --let $commands= B T TeN-trig C
1270 --source suite/rpl/include/rpl_mixing_engines.inc
1271
1272 --let $commands= B T TeN-func C
1273 --source suite/rpl/include/rpl_mixing_engines.inc
1274
1275 --echo
1276 --echo
1277 --echo
1278 --echo
1279 --echo #
1280 --echo #15) Generates in the binlog what follows if a N-Table is changed:
1281 --echo # --> STMT "B T M R" entries, format S.
1282 --echo # --> ROW "B N C" entry, format R.
1283 --echo # --> MIXED "B N C" entry, format R.
1284 --echo #
1285 --let $commands= B T tN R
1286 --source suite/rpl/include/rpl_mixing_engines.inc
1287
1288 --let $commands= B T nT R
1289 --source suite/rpl/include/rpl_mixing_engines.inc
1290
1291 --let $commands= B T NT R
1292 --source suite/rpl/include/rpl_mixing_engines.inc
1293
1294 --let $commands= B T NT-trig R
1295 --source suite/rpl/include/rpl_mixing_engines.inc
1296
1297 --let $commands= B T NT-func R
1298 --source suite/rpl/include/rpl_mixing_engines.inc
1299
1300 --let $commands= B T TN R
1301 --source suite/rpl/include/rpl_mixing_engines.inc
1302
1303 --let $commands= B T TN-trig R
1304 --source suite/rpl/include/rpl_mixing_engines.inc
1305
1306 --let $commands= B T TN-func R
1307 --source suite/rpl/include/rpl_mixing_engines.inc
1308
1309
1310 --echo
1311 --echo
1312 --echo
1313 --echo
1314 --echo #
1315 --echo #15.e) Generates in the binlog what follows if a N-Table is changed:
1316 --echo # --> STMT "B T M R" entries, format S.
1317 --echo # --> ROW "B N C" entry, format R.
1318 --echo # --> MIXED "B N C" entry, format R.
1319 --echo #
1320 --let $commands= B T tNe R
1321 --source suite/rpl/include/rpl_mixing_engines.inc
1322
1323 --let $commands= B T nTe R
1324 --source suite/rpl/include/rpl_mixing_engines.inc
1325
1326 --let $commands= B T NeT-trig R
1327 --source suite/rpl/include/rpl_mixing_engines.inc
1328
1329 --let $commands= B T NeT-func R
1330 --source suite/rpl/include/rpl_mixing_engines.inc
1331
1332 --let $commands= B T TeN-trig R
1333 --source suite/rpl/include/rpl_mixing_engines.inc
1334
1335 --let $commands= B T TeN-func R
1336 --source suite/rpl/include/rpl_mixing_engines.inc
1337
1338
1339 --echo
1340 --echo
1341 --echo
1342 --echo
1343 --echo #
1344 --echo #16) Generates in the binlog what follows if a N-Table is changed:
1345 --echo # --> STMT "B M C B N C" entries if in M only N-Table is changed, format S.
1346 --echo # --> STMT "B M N C" entries, format S.
1347 --echo # --> ROW "B N C B N C B T C" entries, format R.
1348 --echo # --> MIXED "B M C B N C" entries if in M only N-Table is changed, format S.
1349 --echo # --> MIXED "B N C B N C B T C" entries, format R.
1350 --echo #
1351 --let $commands= B tN N C
1352 --source suite/rpl/include/rpl_mixing_engines.inc
1353
1354 --let $commands= B nT N C
1355 --source suite/rpl/include/rpl_mixing_engines.inc
1356
1357 --let $commands= B NT N C
1358 --source suite/rpl/include/rpl_mixing_engines.inc
1359
1360 --let $commands= B NT-trig N C
1361 --source suite/rpl/include/rpl_mixing_engines.inc
1362
1363 --let $commands= B NT-func N C
1364 --source suite/rpl/include/rpl_mixing_engines.inc
1365
1366 --let $commands= B TN N C
1367 --source suite/rpl/include/rpl_mixing_engines.inc
1368
1369 --let $commands= B TN-trig N C
1370 --source suite/rpl/include/rpl_mixing_engines.inc
1371
1372 --let $commands= B TN-func N C
1373 --source suite/rpl/include/rpl_mixing_engines.inc
1374
1375
1376 --echo
1377 --echo
1378 --echo
1379 --echo
1380 --echo #
1381 --echo #16.e) Generates in the binlog what follows if a N-Table is changed:
1382 --echo # --> STMT "B M C B N C" entries if in M only N-Table is changed, format S.
1383 --echo # --> STMT "B M N C" entries, format S.
1384 --echo # --> ROW "B N C B N C B T C" entries, format R.
1385 --echo # --> MIXED "B M C B N C" entries if in M only N-Table is changed, format S.
1386 --echo # --> MIXED "B N C B N C B T C" entries, format R.
1387 --echo #
1388 --let $commands= B tNe N C
1389 --source suite/rpl/include/rpl_mixing_engines.inc
1390
1391 --let $commands= B nTe N C
1392 --source suite/rpl/include/rpl_mixing_engines.inc
1393
1394 --let $commands= B NeT-trig N C
1395 --source suite/rpl/include/rpl_mixing_engines.inc
1396
1397 --let $commands= B NeT-func N C
1398 --source suite/rpl/include/rpl_mixing_engines.inc
1399
1400 --let $commands= B TeN-trig N C
1401 --source suite/rpl/include/rpl_mixing_engines.inc
1402
1403 --let $commands= B TeN-func N C
1404 --source suite/rpl/include/rpl_mixing_engines.inc
1405
1406 --echo
1407 --echo
1408 --echo
1409 --echo
1410 --echo #
1411 --echo #17) Generates in the binlog what follows if a N-Table is changed:
1412 --echo # --> STMT "B M C B N C" entries if in M only N-Table is changed, format S.
1413 --echo # --> STMT "B M N R" entries, format S.
1414 --echo # --> ROW "B N C B N C" entries, format R.
1415 --echo # --> MIXED "B M C B N C" entries if in M only N-Table is changed, format S.
1416 --echo # --> MIXED "B N C B N C" entries, format R.
1417 --echo #
1418 --let $commands= B tN N R
1419 --source suite/rpl/include/rpl_mixing_engines.inc
1420
1421 --let $commands= B nT N R
1422 --source suite/rpl/include/rpl_mixing_engines.inc
1423
1424 --let $commands= B NT N R
1425 --source suite/rpl/include/rpl_mixing_engines.inc
1426
1427 --let $commands= B NT-trig N R
1428 --source suite/rpl/include/rpl_mixing_engines.inc
1429
1430 --let $commands= B NT-func N R
1431 --source suite/rpl/include/rpl_mixing_engines.inc
1432
1433 --let $commands= B TN N R
1434 --source suite/rpl/include/rpl_mixing_engines.inc
1435
1436 --let $commands= B TN-trig N R
1437 --source suite/rpl/include/rpl_mixing_engines.inc
1438
1439 --let $commands= B TN-func N R
1440 --source suite/rpl/include/rpl_mixing_engines.inc
1441
1442
1443 --echo
1444 --echo
1445 --echo
1446 --echo
1447 --echo #
1448 --echo #17.e) Generates in the binlog what follows if a N-Table is changed:
1449 --echo # --> STMT "B M C B N C" entries if in M only N-Table is changed, format S.
1450 --echo # --> STMT "B M N R" entries, format S.
1451 --echo # --> ROW "B N C B N C" entries, format R.
1452 --echo # --> MIXED "B M C B N C" entries if in M only N-Table is changed, format S.
1453 --echo # --> MIXED "B N C B N C" entries, format R.
1454 --echo #
1455 --let $commands= B tNe N R
1456 --source suite/rpl/include/rpl_mixing_engines.inc
1457
1458 --let $commands= B nTe N R
1459 --source suite/rpl/include/rpl_mixing_engines.inc
1460
1461 --let $commands= B NeT-trig N R
1462 --source suite/rpl/include/rpl_mixing_engines.inc
1463
1464 --let $commands= B NeT-func N R
1465 --source suite/rpl/include/rpl_mixing_engines.inc
1466
1467 --let $commands= B TeN-trig N R
1468 --source suite/rpl/include/rpl_mixing_engines.inc
1469
1470 --let $commands= B TeN-func N R
1471 --source suite/rpl/include/rpl_mixing_engines.inc
1472
1473
1474 --echo
1475 --echo
1476 --echo
1477 --echo
1478 --echo #
1479 --echo #18) Generates in the binlog what follows if a N-Table is changed:
1480 --echo # --> STMT "B N C B M C" entries if in M only N-Table is changed, format S.
1481 --echo # --> STMT "B N C B M C" entries, format S.
1482 --echo # --> ROW "B N C B N C B T C" entries, format R.
1483 --echo # --> MIXED "B N C B N C B T C" entries, format S in first N and format R in the other.
1484 --echo #
1485
1486 --let $commands= B N tN C
1487 --source suite/rpl/include/rpl_mixing_engines.inc
1488
1489 --let $commands= B N nT C
1490 --source suite/rpl/include/rpl_mixing_engines.inc
1491
1492 --let $commands= B N NT C
1493 --source suite/rpl/include/rpl_mixing_engines.inc
1494
1495 --let $commands= B N NT-trig C
1496 --source suite/rpl/include/rpl_mixing_engines.inc
1497
1498 --let $commands= B N NT-func C
1499 --source suite/rpl/include/rpl_mixing_engines.inc
1500
1501 --let $commands= B N TN C
1502 --source suite/rpl/include/rpl_mixing_engines.inc
1503
1504 --let $commands= B N TN-trig C
1505 --source suite/rpl/include/rpl_mixing_engines.inc
1506
1507 --let $commands= B N TN-func C
1508 --source suite/rpl/include/rpl_mixing_engines.inc
1509
1510
1511
1512 --echo
1513 --echo
1514 --echo
1515 --echo
1516 --echo #
1517 --echo #18.e) Generates in the binlog what follows if a N-Table is changed:
1518 --echo # --> STMT "B N C B M C" entries if in M only N-Table is changed, format S.
1519 --echo # --> STMT "B N C B M C" entries, format S.
1520 --echo # --> ROW "B N C B N C" entries, format R.
1521 --echo # --> MIXED "B N C B N C" entries, format S in first N and format R in the other.
1522 --echo #
1523 --let $commands= B N tNe C
1524 --source suite/rpl/include/rpl_mixing_engines.inc
1525
1526 --let $commands= B N nTe C
1527 --source suite/rpl/include/rpl_mixing_engines.inc
1528
1529 --let $commands= B N NeT-trig C
1530 --source suite/rpl/include/rpl_mixing_engines.inc
1531
1532 --let $commands= B N NeT-func C
1533 --source suite/rpl/include/rpl_mixing_engines.inc
1534
1535 --let $commands= B N TeN-trig C
1536 --source suite/rpl/include/rpl_mixing_engines.inc
1537
1538 --let $commands= B N TeN-func C
1539 --source suite/rpl/include/rpl_mixing_engines.inc
1540
1541
1542 --echo
1543 --echo
1544 --echo
1545 --echo
1546 --echo #
1547 --echo #19) Generates in the binlog what follows if a N-Table is changed:
1548 --echo # --> STMT "B N C B M C" entries if in M only N-Table is changed, format S.
1549 --echo # --> STMT "B N C B M R" entries, format S.
1550 --echo # --> ROW "B N C B N C" entries, format R.
1551 --echo # --> MIXED "B N C B N C" entries, format S in first N and format R in the other.
1552 --echo #
1553
1554 --let $commands= B N tN R
1555 --source suite/rpl/include/rpl_mixing_engines.inc
1556
1557 --let $commands= B N nT R
1558 --source suite/rpl/include/rpl_mixing_engines.inc
1559
1560 --let $commands= B N NT R
1561 --source suite/rpl/include/rpl_mixing_engines.inc
1562
1563 --let $commands= B N NT-trig R
1564 --source suite/rpl/include/rpl_mixing_engines.inc
1565
1566 --let $commands= B N NT-func R
1567 --source suite/rpl/include/rpl_mixing_engines.inc
1568
1569 --let $commands= B N TN R
1570 --source suite/rpl/include/rpl_mixing_engines.inc
1571
1572 --let $commands= B N TN-trig R
1573 --source suite/rpl/include/rpl_mixing_engines.inc
1574
1575 --let $commands= B N TN-func R
1576 --source suite/rpl/include/rpl_mixing_engines.inc
1577
1578
1579 --echo
1580 --echo
1581 --echo
1582 --echo
1583 --echo #
1584 --echo #19.e) Generates in the binlog what follows if a N-Table is changed:
1585 --echo # --> STMT "B N C B M C" entries if in M only N-Table is changed, format S.
1586 --echo # --> STMT "B N C B M R" entries, format S.
1587 --echo # --> ROW "B N C B N C" entries, format R.
1588 --echo # --> MIXED "B N C B N C" entries, format S in first N and format R in the other.
1589 --echo #
1590 --let $commands= B N tNe R
1591 --source suite/rpl/include/rpl_mixing_engines.inc
1592
1593 --let $commands= B N nTe R
1594 --source suite/rpl/include/rpl_mixing_engines.inc
1595
1596 --let $commands= B N NeT-trig R
1597 --source suite/rpl/include/rpl_mixing_engines.inc
1598
1599 --let $commands= B N NeT-func R
1600 --source suite/rpl/include/rpl_mixing_engines.inc
1601
1602 --let $commands= B N TeN-trig R
1603 --source suite/rpl/include/rpl_mixing_engines.inc
1604
1605 --let $commands= B N TeN-func R
1606 --source suite/rpl/include/rpl_mixing_engines.inc
1607
1608 --echo ###################################################################################
1609 --echo # 2 - SAVEPOINT
1610 --echo ###################################################################################
1611 --let $commands= B T Sn T Rn C
1612 --source suite/rpl/include/rpl_mixing_engines.inc
1613
1614 --let $commands= B N T Sn T Rn C
1615 --source suite/rpl/include/rpl_mixing_engines.inc
1616
1617 --let $commands= B T N Sn T Rn C
1618 --source suite/rpl/include/rpl_mixing_engines.inc
1619
1620 --let $commands= B T Sn N T Rn C
1621 --source suite/rpl/include/rpl_mixing_engines.inc
1622
1623 --echo ###################################################################################
1624 --echo # 3 - CREATE TABLE...SELECT
1625 --echo ###################################################################################
1626 --let $commands= CSe-T->T CS-T->T drop-CS
1627 --source suite/rpl/include/rpl_mixing_engines.inc
1628
1629 --let $commands= CSe-N->N CS-N->N drop-CS
1630 --source suite/rpl/include/rpl_mixing_engines.inc
1631
1632 --let $commands= CSe-T->N CS-T->N drop-CS
1633 --source suite/rpl/include/rpl_mixing_engines.inc
1634
1635 --let $commands= CSe-N->T CS-N->T drop-CS
1636 --source suite/rpl/include/rpl_mixing_engines.inc
1637
1638 --let $commands= CSe-N->T CS-N->T drop-CS
1639 --source suite/rpl/include/rpl_mixing_engines.inc
1640
1641 --let $commands= CSe-N->T CS-N->T drop-CS
1642 --source suite/rpl/include/rpl_mixing_engines.inc
1643
1644
1645 --echo ###################################################################################
1646 --echo # 4 - INSERT TABLE...SELECT
1647 --echo ###################################################################################
1648
1649 --let $commands= CS-T->T
1650 --source suite/rpl/include/rpl_mixing_engines.inc
1651
1652 --let $commands= trunc-CS-T B T IS-T<-N T C
1653 --source suite/rpl/include/rpl_mixing_engines.inc
1654
1655 --let $commands= trunc-CS-T B T ISe-T<-N T C
1656 --source suite/rpl/include/rpl_mixing_engines.inc
1657
1658 --let $commands= trunc-CS-T B IS-T<-N T C
1659 --source suite/rpl/include/rpl_mixing_engines.inc
1660
1661 --let $commands= trunc-CS-T B ISe-T<-N T C
1662 --source suite/rpl/include/rpl_mixing_engines.inc
1663
1664 --let $commands= drop-CS
1665 --source suite/rpl/include/rpl_mixing_engines.inc
1666
1667 --let $commands= CS-T->T
1668 --source suite/rpl/include/rpl_mixing_engines.inc
1669
1670 --let $commands= trunc-CS-T B T IS-T<-T T C
1671 --source suite/rpl/include/rpl_mixing_engines.inc
1672
1673 --let $commands= trunc-CS-T B T ISe-T<-T T C
1674 --source suite/rpl/include/rpl_mixing_engines.inc
1675
1676 --let $commands= trunc-CS-T B IS-T<-T T C
1677 --source suite/rpl/include/rpl_mixing_engines.inc
1678
1679 --let $commands= trunc-CS-T B ISe-T<-T T C
1680 --source suite/rpl/include/rpl_mixing_engines.inc
1681
1682 --let $commands= drop-CS
1683 --source suite/rpl/include/rpl_mixing_engines.inc
1684
1685 --let $commands= CS-N->N
1686 --source suite/rpl/include/rpl_mixing_engines.inc
1687
1688 --let $commands= trunc-CS-N B T IS-N<-T T C
1689 --source suite/rpl/include/rpl_mixing_engines.inc
1690
1691 --let $commands= trunc-CS-N B T ISe-N<-T T C
1692 --source suite/rpl/include/rpl_mixing_engines.inc
1693
1694 --let $commands= trunc-CS-N B IS-N<-T T C
1695 --source suite/rpl/include/rpl_mixing_engines.inc
1696
1697 --let $commands= trunc-CS-N B ISe-N<-T T C
1698 --source suite/rpl/include/rpl_mixing_engines.inc
1699
1700 --let $commands= drop-CS
1701 --source suite/rpl/include/rpl_mixing_engines.inc
1702
1703 --let $commands= CS-N->N
1704 --source suite/rpl/include/rpl_mixing_engines.inc
1705
1706 --let $commands= trunc-CS-N B T IS-N<-N T C
1707 --source suite/rpl/include/rpl_mixing_engines.inc
1708
1709 --let $commands= trunc-CS-N B T ISe-N<-N T C
1710 --source suite/rpl/include/rpl_mixing_engines.inc
1711
1712 --let $commands= trunc-CS-N B IS-N<-N T C
1713 --source suite/rpl/include/rpl_mixing_engines.inc
1714
1715 --let $commands= trunc-CS-N B ISe-N<-N T C
1716 --source suite/rpl/include/rpl_mixing_engines.inc
1717
1718 --let $commands= drop-CS
1719 --source suite/rpl/include/rpl_mixing_engines.inc
1720
1721
1722 --echo ###################################################################################
1723 --echo # 5 - ROLLBACK TEMPORARY TABLE
1724 --echo ###################################################################################
1725 --let $commands= B T CT R
1726 --source suite/rpl/include/rpl_mixing_engines.inc
1727
1728 --let $commands= drop-CT
1729 --source suite/rpl/include/rpl_mixing_engines.inc
1730
1731 --let $commands= B T Sn T CT Rn R
1732 --source suite/rpl/include/rpl_mixing_engines.inc
1733
1734 --let $commands= drop-CT
1735 --source suite/rpl/include/rpl_mixing_engines.inc
1736
1737 --let $commands= B T CT T R
1738 --source suite/rpl/include/rpl_mixing_engines.inc
1739
1740 --let $commands= drop-CT
1741 --source suite/rpl/include/rpl_mixing_engines.inc
1742
1743 --let $commands= B tN CT T R
1744 --source suite/rpl/include/rpl_mixing_engines.inc
1745
1746 --let $commands= drop-CT
1747 --source suite/rpl/include/rpl_mixing_engines.inc
1748
1749 --let $commands= B CT T R
1750 --source suite/rpl/include/rpl_mixing_engines.inc
1751
1752 --let $commands= drop-CT
1753 --source suite/rpl/include/rpl_mixing_engines.inc
1754
1755 --let $commands= B N CT T R
1756 --source suite/rpl/include/rpl_mixing_engines.inc
1757
1758 --let $commands= drop-CT
1759 --source suite/rpl/include/rpl_mixing_engines.inc
1760
1761
1762 --echo ###################################################################################
1763 --echo # 5 - SET WITH ROW CHANGES
1764 --echo ###################################################################################
1765 --let $commands= set-T
1766 --source suite/rpl/include/rpl_mixing_engines.inc
1767
1768 --let $commands= set-N
1769 --source suite/rpl/include/rpl_mixing_engines.inc
1770
1771 --let $commands= set-NT
1772 --source suite/rpl/include/rpl_mixing_engines.inc
1773
1774 --let $commands= B set-N set-T C
1775 --source suite/rpl/include/rpl_mixing_engines.inc
1776
1777 --let $commands= B set-T set-N C
1778 --source suite/rpl/include/rpl_mixing_engines.inc
1779
1780 --let $commands= B set-N set-T R
1781 --source suite/rpl/include/rpl_mixing_engines.inc
1782
1783 --let $commands= B set-T set-N R
1784 --source suite/rpl/include/rpl_mixing_engines.inc
1785
1786 --let $commands= B set-NT set-T C
1787 --source suite/rpl/include/rpl_mixing_engines.inc
1788
1789 --let $commands= B set-T set-NT C
1790 --source suite/rpl/include/rpl_mixing_engines.inc
1791
1792 --let $commands= B set-NT set-T R
1793 --source suite/rpl/include/rpl_mixing_engines.inc
1794
1795 --let $commands= B set-T set-NT R
1796 --source suite/rpl/include/rpl_mixing_engines.inc
1797
1798
1799 --echo ###################################################################################
1800 --echo # CHECK CONSISTENCY
1801 --echo ###################################################################################
1802 connection master;
1803 sync_slave_with_master;
1804
1805 --exec $MYSQL_DUMP --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLTEST_VARDIR/tmp/test-nmt-master.sql
1806 --exec $MYSQL_DUMP_SLAVE --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLTEST_VARDIR/tmp/test-nmt-slave.sql
1807 if (`select @@session.binlog_direct_non_transactional_updates = 0 || @@session.binlog_format != 'STATEMENT'`)
1808 {
1809 --diff_files $MYSQLTEST_VARDIR/tmp/test-nmt-master.sql $MYSQLTEST_VARDIR/tmp/test-nmt-slave.sql
1810 }
1811
1812 --echo ###################################################################################
1813 --echo # CLEAN
1814 --echo ###################################################################################
1815 --let $commands= clean
1816 --source suite/rpl/include/rpl_mixing_engines.inc