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