Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 set @old_log_bin_compress=@@log_bin_compress;
4 set @old_log_bin_compress_min_len=@@log_bin_compress_min_len;
5 set @old_binlog_format=@@binlog_format;
6 set @old_binlog_row_image=@@binlog_row_image;
7 set global log_bin_compress=on;
8 set global log_bin_compress_min_len=10;
9 drop table if exists t1;
10 Warnings:
11 Note 1051 Unknown table 'test.t1'
12 CREATE TABLE t1 (pr_id int(10) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, pr_page int(11) NOT NULL, pr_type varbinary(60) NOT NULL, test int, UNIQUE KEY pr_pagetype (pr_page,pr_type)) ENGINE=myisam AUTO_INCREMENT=136;
13 set binlog_format=statement;
14 insert into t1 (pr_page, pr_type, test) values(1,"one",0),(2,"two",0);
15 replace into t1 (pr_page, pr_type,test) values(1,"one",2);
16 update t1 set test=test+1 where pr_page > 1;
17 delete from t1 where test=1;
18 select * from t1;
19 pr_id pr_page pr_type test
20 138 1 one 2
21 connection slave;
22 connection slave;
23 select * from t1;
24 pr_id pr_page pr_type test
25 138 1 one 2
26 connection master;
27 set binlog_format=row;
28 insert into t1 (pr_page, pr_type, test) values(3,"three",0),(4,"four",4),(5, "five", 0);
29 replace into t1 (pr_page, pr_type,test) values(3,"one",2);
30 update t1 set test=test+1 where pr_page > 3;
31 delete from t1 where test=1;
32 select * from t1;
33 pr_id pr_page pr_type test
34 138 1 one 2
35 140 4 four 5
36 139 3 three 0
37 142 3 one 2
38 connection slave;
39 connection slave;
40 select * from t1;
41 pr_id pr_page pr_type test
42 138 1 one 2
43 140 4 four 5
44 139 3 three 0
45 142 3 one 2
46 connection master;
47 set binlog_row_image=minimal;
48 insert into t1 (pr_page, pr_type, test) values(6,"six",0),(7,"seven",7),(8, "eight", 0);
49 replace into t1 (pr_page, pr_type,test) values(6,"six",2);
50 update t1 set test=test+1 where pr_page > 6;
51 delete from t1 where test=1;
52 select * from t1;
53 pr_id pr_page pr_type test
54 138 1 one 2
55 140 4 four 5
56 139 3 three 0
57 144 7 seven 8
58 142 3 one 2
59 146 6 six 2
60 connection slave;
61 connection slave;
62 select * from t1;
63 pr_id pr_page pr_type test
64 138 1 one 2
65 140 4 four 5
66 139 3 three 0
67 144 7 seven 8
68 142 3 one 2
69 146 6 six 2
70 connection master;
71 drop table t1;
72 set global log_bin_compress=@old_log_bin_compress;
73 set global log_bin_compress_min_len=@old_log_bin_compress_min_len;
74 set binlog_format=@old_binlog_format;
75 set binlog_row_image=@old_binlog_row_image;
76 include/rpl_end.inc