Debian Codegraph @

mysql-test/suite/rpl/include/rpl_row_blob.test

raw
1 #################################################
2 # Author: JBM
3 # Date: 2006-01-06
4 # Purpose: Test test that BLOBs are replicated
5 # correctly.
6 ################################################
7
8 # Pre test clean up section
9 connection master;
10 --disable_warnings
11 DROP TABLE IF EXISTS test.t1;
12 DROP TABLE IF EXISTS test.t2;
13 --enable_warnings
14
15 # Start test section
16 --echo ***** Table Create Section ****
17 --echo
18 --disable_warnings
19 --replace_result $engine_type #
20 eval CREATE TABLE test.t1 (c1 int not null auto_increment,
21 data LONGBLOB, PRIMARY KEY(c1))ENGINE=$engine_type;
22 --enable_warnings
23 --echo
24 --echo **** Data Insert Section test.t1 *****
25 --echo
26 INSERT INTO test.t1 VALUES (NULL, NULL);
27 INSERT INTO test.t1 VALUES (NULL, repeat('a',1*1024));
28 INSERT INTO test.t1 VALUES (NULL, repeat('b',16*1024));
29 --echo
30
31 --echo **** Data Insert Validation Master Section test.t1 ****
32 --echo
33 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
34 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 2;
35 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 3;
36 save_master_pos;
37 connection slave;
38 sync_with_master;
39 --echo
40 --echo **** Data Insert Validation Slave Section test.t1 ****
41 --echo
42 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
43 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 2;
44 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 3;
45 connection master;
46 --echo
47
48 --echo **** Data Update Section test.t1 ****
49 --echo
50 UPDATE test.t1 set data=repeat('a',18*1024) where c1 = 1;
51 UPDATE t1 set data=repeat('c',17*1024) where c1 = 2;
52 --echo
53
54 --echo **** Data Update Validation Master Section test.t1 ****
55 --echo
56 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
57 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 2;
58 save_master_pos;
59 connection slave;
60 sync_with_master;
61 --echo
62 --echo **** Data Update Validation Slave Section test.t1 ****
63 --echo
64 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
65 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 2;
66 connection master;
67 --echo
68 --echo **** End Test Section test.t1 ****
69 --echo
70
71 --echo **** Create Table test.t2 ****
72 --echo
73 --disable_warnings
74 --replace_result $engine_type #
75 eval CREATE TABLE test.t2 (
76 c1 INT NOT NULL PRIMARY KEY,
77 c2 TEXT,
78 c3 INT,
79 c4 LONGBLOB,
80 KEY(c3))ENGINE=$engine_type;
81 --enable_warnings
82 --echo
83
84 --echo *** Setup Values For test.t2 ***
85 # x0 size 256 (current inline size)
86 set @x0 = '01234567012345670123456701234567';
87 set @x0 = concat(@x0,@x0,@x0,@x0,@x0,@x0,@x0,@x0);
88
89 # b1 length 2000+256 (blob part aligned)
90 set @b1 = 'b1';
91 set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1);
92 set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1);
93 set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1);
94 set @b1 = concat(@b1,@x0);
95 # d1 length 3000
96 set @d1 = 'dd1';
97 set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1);
98 set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1);
99 set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1);
100
101 # b2 length 20000
102 set @b2 = 'b2';
103 set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
104 set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
105 set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
106 set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
107
108 # d2 length 30000
109 set @d2 = 'dd2';
110 set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
111 set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
112 set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
113 set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
114 --echo
115
116 --echo **** Data Insert Section test.t2 *****
117 --echo
118 INSERT INTO test.t2 VALUES(1,@b1,111,@d1);
119 INSERT INTO test.t2 VALUES(2,@b2,222,@d2);
120 --echo
121
122 --echo **** Data Insert Validation Master Section test.t2 ****
123 --echo
124 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
125 FROM test.t2 WHERE c1=1;
126 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
127 FROM test.t2 WHERE c1=2;
128 save_master_pos;
129 connection slave;
130 sync_with_master;
131 --echo
132 --echo **** Data Insert Validation Slave Section test.t2 ****
133 --echo
134 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
135 FROM test.t2 WHERE c1=1;
136 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
137 FROM test.t2 WHERE c1=2;
138 connection master;
139 --echo
140
141 --echo **** Data Update Section test.t2 ****
142 --echo
143 UPDATE test.t2 SET c2=@b2, c4=@d2 WHERE c1=1;
144 UPDATE test.t2 SET c2=@b1, c4=@d1 WHERE c1=2;
145 --echo
146
147 --echo **** Data Update Validation Master Section test.t2 ****
148 --echo
149 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
150 FROM test.t2 WHERE c1=1;
151 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
152 FROM test.t2 WHERE c1=2;
153 save_master_pos;
154 connection slave;
155 sync_with_master;
156 --echo
157 --echo **** Data Update Validation Slave Section test.t2 ****
158 --echo
159 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
160 FROM test.t2 WHERE c1=1;
161 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
162 FROM test.t2 WHERE c1=2;
163 connection master;
164 --echo
165
166 # Post test clean up section
167 --exec $MYSQL_DUMP --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLTEST_VARDIR/tmp/rpl_row_blob_master.sql
168 --exec $MYSQL_DUMP_SLAVE --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLTEST_VARDIR/tmp/rpl_row_blob_slave.sql
169
170 diff_files $MYSQLTEST_VARDIR/tmp/rpl_row_blob_master.sql $MYSQLTEST_VARDIR/tmp/rpl_row_blob_slave.sql;
171
172 DROP TABLE IF EXISTS test.t1;
173 DROP TABLE IF EXISTS test.t2;
174 # ensure cleanup on slave as well:
175 --sync_slave_with_master
176
177 --echo #
178 --echo # MDEV-30985 Replica stops with error on ALTER ONLINE with Geometry Types
179 --echo #
180 --connection master
181 CREATE TABLE t(txt TEXT DEFAULT '111111111', blb LONGBLOB AS (txt));
182 INSERT INTO t () VALUES (),(),();
183 DELETE FROM t;
184
185 DROP TABLE t;
186 --sync_slave_with_master
187 --connection master
188 CREATE TABLE t(txt TEXT DEFAULT '111111111', blb LONGBLOB AS (txt) STORED);
189 INSERT INTO t () VALUES (),(),();
190 DELETE FROM t;
191
192 DROP TABLE t;
193 --sync_slave_with_master