Debian Codegraph @

mysql-test/suite/group_replication/t/gr_blob.test

raw
1 ################################################################################
2 # Test to see the behavior of the BLOB FIELDS in Group Replication
3 #
4 # Test:
5 # 0. The test requires two servers: M1 and M2.
6 # 1. Pre test clean up section.
7 # 2. With both the members ONLINE. Start test section:
8 # a) Create table t1.
9 # b) Insert data in table t1.
10 # c) Data validation on M1.
11 # d) Data validation on M2.
12 # e) Update data in table t1.
13 # f) Data validation on M1.
14 # g) Data validation on M2.
15 # h) Create table t2.
16 # i) Setup values for t2.
17 # j) Insert data in table t2.
18 # k) Data validation on M1.
19 # l) Data validation on M2.
20 # m) Update data in table t2.
21 # n) Data validation on M1.
22 # o) Data validation on M2.
23 # 3. Post test clean up section.
24 ################################################################################
25 --source include/have_group_replication_plugin.inc
26 --source include/not_ndb_default.inc
27 --source include/group_replication.inc
28 # Pre test clean up section
29 --connection server1
30 --disable_warnings
31 DROP TABLE IF EXISTS test.t1;
32 DROP TABLE IF EXISTS test.t2;
33 --enable_warnings
34
35 # Start test section
36 --echo ***** Table Create Section ****
37 --echo
38 --disable_warnings
39 --eval CREATE TABLE test.t1 (c1 int not null auto_increment, data LONGBLOB, PRIMARY KEY(c1))ENGINE=innodb
40 --enable_warnings
41
42 --echo
43 --echo **** Data Insert Section test.t1 *****
44 --echo
45 INSERT INTO test.t1 VALUES (NULL, NULL);
46 INSERT INTO test.t1 VALUES (NULL, repeat('a',1*1024));
47 INSERT INTO test.t1 VALUES (NULL, repeat('b',16*1024));
48 --echo
49
50 --echo **** Data Insert Validation Member 1 Section test.t1 ****
51 --echo
52 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
53 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 8;
54 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 15;
55 --source include/rpl_sync.inc
56
57 --echo
58 --echo **** Data Insert Validation Member 2 Section test.t1 ****
59 --echo
60 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
61 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 8;
62 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 15;
63 --connection server1
64 --echo
65
66 --echo **** Data Update Section test.t1 ****
67 --echo
68 UPDATE test.t1 set data=repeat('a',18*1024) where c1 = 1;
69 UPDATE t1 set data=repeat('c',17*1024) where c1 = 8;
70 --echo
71
72 --echo **** Data Update Validation Member 1 Section test.t1 ****
73 --echo
74 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
75 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 8;
76 --source include/rpl_sync.inc
77 --echo
78 --echo **** Data Update Validation Member 2 Section test.t1 ****
79 --echo
80 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
81 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 8;
82 --connection server1
83
84 --echo
85 --echo **** End Test Section test.t1 ****
86 --echo
87
88 --echo **** Create Table test.t2 ****
89 --echo
90 --disable_warnings
91 --eval CREATE TABLE test.t2 (c1 INT NOT NULL PRIMARY KEY, c2 TEXT, c3 INT, c4 LONGBLOB, KEY(c3))ENGINE=innodb
92 --enable_warnings
93 --echo
94
95 --echo *** Setup Values For test.t2 ***
96 # x0 size 256 (current inline size)
97 set @x0 = '01234567012345670123456701234567';
98 set @x0 = concat(@x0,@x0,@x0,@x0,@x0,@x0,@x0,@x0);
99
100 # b1 length 2000+256 (blob part aligned)
101 set @b1 = 'b1';
102 set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1);
103 set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1);
104 set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1);
105 set @b1 = concat(@b1,@x0);
106
107 # d1 length 3000
108 set @d1 = 'dd1';
109 set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1);
110 set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1);
111 set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1);
112
113 # b2 length 20000
114 set @b2 = 'b2';
115 set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
116 set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
117 set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
118 set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
119
120 # d2 length 30000
121 set @d2 = 'dd2';
122 set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
123 set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
124 set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
125 set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
126 --echo
127
128 --echo **** Data Insert Section test.t2 *****
129 --echo
130 INSERT INTO test.t2 VALUES(1,@b1,111,@d1);
131 INSERT INTO test.t2 VALUES(2,@b2,222,@d2);
132 --echo
133
134 --echo **** Data Insert Validation Member 1 Section test.t2 ****
135 --echo
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=1;
138 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
139 FROM test.t2 WHERE c1=2;
140 --source include/rpl_sync.inc
141
142 --echo
143 --echo **** Data Insert Validation Member 2 Section test.t2 ****
144 --echo
145
146 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
147 FROM test.t2 WHERE c1=1;
148 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
149 FROM test.t2 WHERE c1=2;
150 --connection server1
151 --echo
152
153 --echo **** Data Update Section test.t2 ****
154 --echo
155 UPDATE test.t2 SET c2=@b2, c4=@d2 WHERE c1=1;
156 UPDATE test.t2 SET c2=@b1, c4=@d1 WHERE c1=2;
157 --echo
158
159 --echo **** Data Update Validation Member 1 Section test.t2 ****
160 --echo
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=1;
163 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
164 FROM test.t2 WHERE c1=2;
165 --source include/rpl_sync.inc
166
167 --echo
168 --echo **** Data Update Validation Member 2 Section test.t2 ****
169 --echo
170 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
171 FROM test.t2 WHERE c1=1;
172 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
173 FROM test.t2 WHERE c1=2;
174 --connection server1
175 --echo
176
177 # Post test clean up section
178
179 --let $diff_tables= server1:t1, server2:t1
180 --source include/diff_tables.inc
181
182 DROP TABLE IF EXISTS test.t1;
183 DROP TABLE IF EXISTS test.t2;
184
185 --source include/rpl_sync.inc
186 --source include/group_replication_end.inc