1include/master-slave.inc
2[connection master]
3connection master;
4DROP TABLE IF EXISTS test.t1;
5DROP TABLE IF EXISTS test.t2;
6*****  Table Create Section ****
7
8CREATE TABLE test.t1 (c1 int not null auto_increment,
9data LONGBLOB, PRIMARY KEY(c1))ENGINE=#;
10
11**** Data Insert Section test.t1 *****
12
13INSERT INTO test.t1 VALUES (NULL, NULL);
14INSERT INTO test.t1 VALUES (NULL, repeat('a',1*1024));
15INSERT INTO test.t1 VALUES (NULL, repeat('b',16*1024));
16
17**** Data Insert Validation Master Section test.t1 ****
18
19SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
20LENGTH(data)
21NULL
22SELECT LENGTH(data) FROM test.t1 WHERE c1 = 2;
23LENGTH(data)
241024
25SELECT LENGTH(data) FROM test.t1 WHERE c1 = 3;
26LENGTH(data)
2716384
28connection slave;
29
30**** Data Insert Validation Slave Section test.t1 ****
31
32SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
33LENGTH(data)
34NULL
35SELECT LENGTH(data) FROM test.t1 WHERE c1 = 2;
36LENGTH(data)
371024
38SELECT LENGTH(data) FROM test.t1 WHERE c1 = 3;
39LENGTH(data)
4016384
41connection master;
42
43**** Data Update Section test.t1 ****
44
45UPDATE test.t1 set data=repeat('a',18*1024) where c1 = 1;
46UPDATE t1 set data=repeat('c',17*1024) where c1 = 2;
47
48**** Data Update Validation Master Section test.t1 ****
49
50SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
51LENGTH(data)
5218432
53SELECT LENGTH(data) FROM test.t1 WHERE c1 = 2;
54LENGTH(data)
5517408
56connection slave;
57
58**** Data Update Validation Slave Section test.t1 ****
59
60SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
61LENGTH(data)
6218432
63SELECT LENGTH(data) FROM test.t1 WHERE c1 = 2;
64LENGTH(data)
6517408
66connection master;
67
68**** End Test Section test.t1 ****
69
70**** Create Table test.t2 ****
71
72CREATE TABLE test.t2 (
73c1 INT NOT NULL PRIMARY KEY,
74c2 TEXT,
75c3 INT,
76c4 LONGBLOB,
77KEY(c3))ENGINE=#;
78
79*** Setup Values For test.t2 ***
80set @x0 = '01234567012345670123456701234567';
81set @x0 = concat(@x0,@x0,@x0,@x0,@x0,@x0,@x0,@x0);
82set @b1 = 'b1';
83set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1);
84set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1);
85set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1);
86set @b1 = concat(@b1,@x0);
87set @d1 = 'dd1';
88set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1);
89set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1);
90set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1);
91set @b2 = 'b2';
92set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
93set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
94set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
95set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
96set @d2 = 'dd2';
97set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
98set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
99set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
100set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
101
102**** Data Insert Section test.t2 *****
103
104INSERT INTO test.t2 VALUES(1,@b1,111,@d1);
105INSERT INTO test.t2 VALUES(2,@b2,222,@d2);
106
107**** Data Insert Validation Master Section test.t2 ****
108
109SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
110FROM test.t2 WHERE c1=1;
111c1	LENGTH(c2)	SUBSTR(c2,1+2*900,2)	LENGTH(c4)	SUBSTR(c4,1+3*900,3)
1121	2256	b1	3000	dd1
113SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
114FROM test.t2 WHERE c1=2;
115c1	LENGTH(c2)	SUBSTR(c2,1+2*900,2)	LENGTH(c4)	SUBSTR(c4,1+3*900,3)
1162	20000	b2	30000	dd2
117connection slave;
118
119**** Data Insert Validation Slave Section test.t2 ****
120
121SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
122FROM test.t2 WHERE c1=1;
123c1	LENGTH(c2)	SUBSTR(c2,1+2*900,2)	LENGTH(c4)	SUBSTR(c4,1+3*900,3)
1241	2256	b1	3000	dd1
125SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
126FROM test.t2 WHERE c1=2;
127c1	LENGTH(c2)	SUBSTR(c2,1+2*900,2)	LENGTH(c4)	SUBSTR(c4,1+3*900,3)
1282	20000	b2	30000	dd2
129connection master;
130
131**** Data Update Section test.t2 ****
132
133UPDATE test.t2 SET c2=@b2, c4=@d2 WHERE c1=1;
134UPDATE test.t2 SET c2=@b1, c4=@d1 WHERE c1=2;
135
136**** Data Update Validation Master Section test.t2 ****
137
138SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
139FROM test.t2 WHERE c1=1;
140c1	LENGTH(c2)	SUBSTR(c2,1+2*900,2)	LENGTH(c4)	SUBSTR(c4,1+3*900,3)
1411	20000	b2	30000	dd2
142SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
143FROM test.t2 WHERE c1=2;
144c1	LENGTH(c2)	SUBSTR(c2,1+2*900,2)	LENGTH(c4)	SUBSTR(c4,1+3*900,3)
1452	2256	b1	3000	dd1
146connection slave;
147
148**** Data Update Validation Slave Section test.t2 ****
149
150SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
151FROM test.t2 WHERE c1=1;
152c1	LENGTH(c2)	SUBSTR(c2,1+2*900,2)	LENGTH(c4)	SUBSTR(c4,1+3*900,3)
1531	20000	b2	30000	dd2
154SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
155FROM test.t2 WHERE c1=2;
156c1	LENGTH(c2)	SUBSTR(c2,1+2*900,2)	LENGTH(c4)	SUBSTR(c4,1+3*900,3)
1572	2256	b1	3000	dd1
158connection master;
159
160DROP TABLE IF EXISTS test.t1;
161DROP TABLE IF EXISTS test.t2;
162connection slave;
163include/rpl_end.inc
164