Debian Codegraph @

mysql-test/suite/binlog/include/row_img.test

raw
1 # Auxaliary script for test binlog_row_image
2 #
3 CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 varchar(100),
4 c3 INT DEFAULT 1000, c4 TEXT);
5 CREATE TABLE t2 (c1 INT, c2 char(100), c3 INT DEFAULT 1000, c4 TEXT);
6
7 FLUSH BINARY LOGS;
8 --let $binlog= query_get_value(SHOW MASTER STATUS, File, 1)
9 --let $datadir= `SELECT @@datadir`
10
11 --let $img_mode= `SELECT @@binlog_row_image`
12 --echo
13 --echo #########################################################################
14 --echo # binlog_row_image = $img_mode
15 --echo #########################################################################
16 --echo
17 INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
18 (2, "insert_to_t1", 2, repeat('a', 20)),
19 (3, "insert_to_t1", 3, repeat('a', 20));
20 INSERT INTO t1(c1) VALUES(4);
21 UPDATE t1 SET c2 = "only_c2_changed";
22 UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed";
23 DELETE FROM t1 WHERE c1 = 1;
24
25 --echo
26 --echo # Verify that rows events are binlogged as expeced.
27 --echo
28 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
29 --replace_regex /^\# at .*// /.*SET (@@|TIMESTAMP).*// /.* end_log_pos .*// /xid=\d*/xid=<xid>/
30 --exec $MYSQL_BINLOG --force-if-open --verbose --verbose --base64-output=DECODE-ROWS $datadir/$binlog
31
32 FLUSH BINARY LOGS;
33 --let $binlog= query_get_value(SHOW MASTER STATUS, File, 1)
34 --let $datadir= `SELECT @@datadir`
35
36 --echo
37 --echo # t2 has no primary key.
38 --echo # It will binlog full before and after image for all modes if the
39 --echo # table has no primary key. FULL_NODUP follows the behavior.
40 --echo
41 INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
42 (2, "insert_to_t2", 2, repeat('a', 20)),
43 (3, "insert_to_t2", 3, repeat('a', 20));
44 INSERT INTO t2(c1) VALUES(4);
45 UPDATE t2 SET c2 = "only_c2_changed";
46 UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed";
47 DELETE FROM t2 WHERE c1 > 2;
48
49 --echo
50 --echo # Verify that rows events are binlogged as expeced.
51 --echo
52 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
53 --replace_regex /^\# at .*// /.*SET (@@|TIMESTAMP).*// /.* end_log_pos .*// /xid=\d*/xid=<xid>/
54 --exec $MYSQL_BINLOG --force-if-open --verbose --verbose --base64-output=DECODE-ROWS $datadir/$binlog
55
56 DROP TABLE t1, t2;