Debian Codegraph @

mysql-test/suite/ndb_binlog/r/ndb_binlog_log_reads.result

raw
1 create table test.t1 (
2 a int primary key,
3 b varchar(2000),
4 c int not null unique,
5 d int,
6 key(d)) engine=ndb;
7 insert into test.t1 values
8 (1, "Initial data 1", 1, 1),
9 (2, "Initial data 2", 2, 2),
10 (3, "Initial data 3", 3, 3),
11 (4, "Initial data 4", 4, 4),
12 (5, "Initial data 5", 5, 5),
13 (6, "Initial data 6", 6, 6),
14 (7, "Initial data 7", 7, 7),
15 (8, "Initial data 8", 8, 8),
16 (9, "Initial data 9", 9, 9),
17 (10, "Initial data 10", 10, 10);
18 create table test.synch(x int primary key) engine=ndb;
19 Test 1: Testing logging of pk reads
20 reset master;
21 show create table test.synch;
22 reset master;
23 show create table test.synch;
24 reset master;
25 show create table test.synch;
26 reset master;
27 SET ndb_log_exclusive_reads= 1;
28 select * from test.t1 where a = 7 order by a for update;
29 a b c d
30 7 Initial data 7 7 7
31 "Check that the binlog contains the AnyValue bit set in extra row data for a WRITE_ROW since ndb-log-update-as-write=1"
32 mysqld1: txt
33 mysqld1: ### Extra row ndb info: data_format: 0, len: 4, data: 0x02000400
34 mysqld1: ### INSERT INTO `test`.`t1`
35 "Check that the binlog contains the AnyValue bit set in extra row data for a WRITE_ROW since ndb-log-update-as-write=1"
36 mysqld2: txt
37 mysqld2: ### Extra row ndb info: data_format: 0, len: 4, data: 0x02000400
38 mysqld2: ### INSERT INTO `test`.`t1`
39 "Check that the binlog contains the AnyValue bit set in extra row data for a UPDATE_ROW since ndb-log-update-as-write=0"
40 mysqld3: txt
41 mysqld3: ### Extra row ndb info: data_format: 0, len: 4, data: 0x02000400
42 mysqld3: ### UPDATE `test`.`t1`
43 "Check that the binlog contains the AnyValue bit set in extra row data for a UPDATE_ROW since ndb-log-update-as-write=0"
44 mysqld4: txt
45 mysqld4: ### Extra row ndb info: data_format: 0, len: 4, data: 0x02000400
46 mysqld4: ### UPDATE `test`.`t1`
47 SET ndb_log_exclusive_reads= 0;
48 Test 2: Testing logging of unique index reads
49 reset master;
50 delete from test.synch;
51 show create table test.synch;
52 reset master;
53 show create table test.synch;
54 reset master;
55 show create table test.synch;
56 reset master;
57 SET ndb_log_exclusive_reads= 1;
58 select * from test.t1 where c = 7 order by a for update;
59 a b c d
60 7 Initial data 7 7 7
61 "Check that the binlog contains the AnyValue bit set in extra row data for a WRITE_ROW since ndb-log-update-as-write=1"
62 mysqld1: txt
63 mysqld1: ### Extra row ndb info: data_format: 0, len: 4, data: 0x02000400
64 mysqld1: ### INSERT INTO `test`.`t1`
65 "Check that the binlog contains the AnyValue bit set in extra row data for a WRITE_ROW since ndb-log-update-as-write=1"
66 mysqld2: txt
67 mysqld2: ### Extra row ndb info: data_format: 0, len: 4, data: 0x02000400
68 mysqld2: ### INSERT INTO `test`.`t1`
69 "Check that the binlog contains the AnyValue bit set in extra row data for a UPDATE_ROW since ndb-log-update-as-write=0"
70 mysqld3: txt
71 mysqld3: ### Extra row ndb info: data_format: 0, len: 4, data: 0x02000400
72 mysqld3: ### UPDATE `test`.`t1`
73 "Check that the binlog contains the AnyValue bit set in extra row data for a UPDATE_ROW since ndb-log-update-as-write=0"
74 mysqld4: txt
75 mysqld4: ### Extra row ndb info: data_format: 0, len: 4, data: 0x02000400
76 mysqld4: ### UPDATE `test`.`t1`
77 SET ndb_log_exclusive_reads= 0;
78 Test 3: Testing logging of ordered index scans
79 reset master;
80 delete from test.synch;
81 show create table test.synch;
82 reset master;
83 show create table test.synch;
84 reset master;
85 show create table test.synch;
86 reset master;
87 SET ndb_log_exclusive_reads= 1;
88 select * from test.t1 where d = 7 order by a for update;
89 a b c d
90 7 Initial data 7 7 7
91 "Check that the binlog contains the AnyValue bit set in extra row data for a WRITE_ROW since ndb-log-update-as-write=1"
92 mysqld1: txt
93 mysqld1: ### Extra row ndb info: data_format: 0, len: 4, data: 0x02000400
94 mysqld1: ### INSERT INTO `test`.`t1`
95 "Check that the binlog contains the AnyValue bit set in extra row data for a WRITE_ROW since ndb-log-update-as-write=1"
96 mysqld2: txt
97 mysqld2: ### Extra row ndb info: data_format: 0, len: 4, data: 0x02000400
98 mysqld2: ### INSERT INTO `test`.`t1`
99 "Check that the binlog contains the AnyValue bit set in extra row data for a UPDATE_ROW since ndb-log-update-as-write=0"
100 mysqld3: txt
101 mysqld3: ### Extra row ndb info: data_format: 0, len: 4, data: 0x02000400
102 mysqld3: ### UPDATE `test`.`t1`
103 "Check that the binlog contains the AnyValue bit set in extra row data for a UPDATE_ROW since ndb-log-update-as-write=0"
104 mysqld4: txt
105 mysqld4: ### Extra row ndb info: data_format: 0, len: 4, data: 0x02000400
106 mysqld4: ### UPDATE `test`.`t1`
107 SET ndb_log_exclusive_reads= 0;
108 Test 4: Testing logging of table scans
109 reset master;
110 delete from test.synch;
111 show create table test.synch;
112 reset master;
113 show create table test.synch;
114 reset master;
115 show create table test.synch;
116 reset master;
117 SET ndb_log_exclusive_reads= 1;
118 select * from test.t1 where b like "Initial data 7" order by a for update;
119 a b c d
120 7 Initial data 7 7 7
121 "Check that the binlog contains the AnyValue bit set in extra row data for a WRITE_ROW since ndb-log-update-as-write=1"
122 mysqld1: txt
123 mysqld1: ### Extra row ndb info: data_format: 0, len: 4, data: 0x02000400
124 mysqld1: ### INSERT INTO `test`.`t1`
125 "Check that the binlog contains the AnyValue bit set in extra row data for a WRITE_ROW since ndb-log-update-as-write=1"
126 mysqld2: txt
127 mysqld2: ### Extra row ndb info: data_format: 0, len: 4, data: 0x02000400
128 mysqld2: ### INSERT INTO `test`.`t1`
129 "Check that the binlog contains the AnyValue bit set in extra row data for a UPDATE_ROW since ndb-log-update-as-write=0"
130 mysqld3: txt
131 mysqld3: ### Extra row ndb info: data_format: 0, len: 4, data: 0x02000400
132 mysqld3: ### UPDATE `test`.`t1`
133 "Check that the binlog contains the AnyValue bit set in extra row data for a UPDATE_ROW since ndb-log-update-as-write=0"
134 mysqld4: txt
135 mysqld4: ### Extra row ndb info: data_format: 0, len: 4, data: 0x02000400
136 mysqld4: ### UPDATE `test`.`t1`
137 SET ndb_log_exclusive_reads= 0;
138 drop table test.synch, test.t1;