Debian Codegraph @

mysql-test/suite/group_replication/r/gr_blob.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6 DROP TABLE IF EXISTS test.t1;
7 DROP TABLE IF EXISTS test.t2;
8 ***** Table Create Section ****
9
10 CREATE TABLE test.t1 (c1 int not null auto_increment, data LONGBLOB, PRIMARY KEY(c1))ENGINE=innodb;
11
12 **** Data Insert Section test.t1 *****
13
14 INSERT INTO test.t1 VALUES (NULL, NULL);
15 INSERT INTO test.t1 VALUES (NULL, repeat('a',1*1024));
16 INSERT INTO test.t1 VALUES (NULL, repeat('b',16*1024));
17
18 **** Data Insert Validation Member 1 Section test.t1 ****
19
20 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
21 LENGTH(data)
22 NULL
23 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 8;
24 LENGTH(data)
25 1024
26 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 15;
27 LENGTH(data)
28 16384
29 include/rpl_sync.inc
30
31 **** Data Insert Validation Member 2 Section test.t1 ****
32
33 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
34 LENGTH(data)
35 NULL
36 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 8;
37 LENGTH(data)
38 1024
39 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 15;
40 LENGTH(data)
41 16384
42
43 **** Data Update Section test.t1 ****
44
45 UPDATE test.t1 set data=repeat('a',18*1024) where c1 = 1;
46 UPDATE t1 set data=repeat('c',17*1024) where c1 = 8;
47
48 **** Data Update Validation Member 1 Section test.t1 ****
49
50 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
51 LENGTH(data)
52 18432
53 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 8;
54 LENGTH(data)
55 17408
56 include/rpl_sync.inc
57
58 **** Data Update Validation Member 2 Section test.t1 ****
59
60 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
61 LENGTH(data)
62 18432
63 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 8;
64 LENGTH(data)
65 17408
66
67 **** End Test Section test.t1 ****
68
69 **** Create Table test.t2 ****
70
71 CREATE TABLE test.t2 (c1 INT NOT NULL PRIMARY KEY, c2 TEXT, c3 INT, c4 LONGBLOB, KEY(c3))ENGINE=innodb;
72
73 *** Setup Values For test.t2 ***
74 set @x0 = '01234567012345670123456701234567';
75 set @x0 = concat(@x0,@x0,@x0,@x0,@x0,@x0,@x0,@x0);
76 set @b1 = 'b1';
77 set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1);
78 set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1);
79 set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1);
80 set @b1 = concat(@b1,@x0);
81 set @d1 = 'dd1';
82 set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1);
83 set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1);
84 set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1);
85 set @b2 = 'b2';
86 set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
87 set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
88 set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
89 set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
90 set @d2 = 'dd2';
91 set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
92 set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
93 set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
94 set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
95
96 **** Data Insert Section test.t2 *****
97
98 INSERT INTO test.t2 VALUES(1,@b1,111,@d1);
99 INSERT INTO test.t2 VALUES(2,@b2,222,@d2);
100
101 **** Data Insert Validation Member 1 Section test.t2 ****
102
103 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
104 FROM test.t2 WHERE c1=1;
105 c1 LENGTH(c2) SUBSTR(c2,1+2*900,2) LENGTH(c4) SUBSTR(c4,1+3*900,3)
106 1 2256 b1 3000 dd1
107 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
108 FROM test.t2 WHERE c1=2;
109 c1 LENGTH(c2) SUBSTR(c2,1+2*900,2) LENGTH(c4) SUBSTR(c4,1+3*900,3)
110 2 20000 b2 30000 dd2
111 include/rpl_sync.inc
112
113 **** Data Insert Validation Member 2 Section test.t2 ****
114
115 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
116 FROM test.t2 WHERE c1=1;
117 c1 LENGTH(c2) SUBSTR(c2,1+2*900,2) LENGTH(c4) SUBSTR(c4,1+3*900,3)
118 1 2256 b1 3000 dd1
119 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
120 FROM test.t2 WHERE c1=2;
121 c1 LENGTH(c2) SUBSTR(c2,1+2*900,2) LENGTH(c4) SUBSTR(c4,1+3*900,3)
122 2 20000 b2 30000 dd2
123
124 **** Data Update Section test.t2 ****
125
126 UPDATE test.t2 SET c2=@b2, c4=@d2 WHERE c1=1;
127 UPDATE test.t2 SET c2=@b1, c4=@d1 WHERE c1=2;
128
129 **** Data Update Validation Member 1 Section test.t2 ****
130
131 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
132 FROM test.t2 WHERE c1=1;
133 c1 LENGTH(c2) SUBSTR(c2,1+2*900,2) LENGTH(c4) SUBSTR(c4,1+3*900,3)
134 1 20000 b2 30000 dd2
135 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
136 FROM test.t2 WHERE c1=2;
137 c1 LENGTH(c2) SUBSTR(c2,1+2*900,2) LENGTH(c4) SUBSTR(c4,1+3*900,3)
138 2 2256 b1 3000 dd1
139 include/rpl_sync.inc
140
141 **** Data Update Validation Member 2 Section test.t2 ****
142
143 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
144 FROM test.t2 WHERE c1=1;
145 c1 LENGTH(c2) SUBSTR(c2,1+2*900,2) LENGTH(c4) SUBSTR(c4,1+3*900,3)
146 1 20000 b2 30000 dd2
147 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
148 FROM test.t2 WHERE c1=2;
149 c1 LENGTH(c2) SUBSTR(c2,1+2*900,2) LENGTH(c4) SUBSTR(c4,1+3*900,3)
150 2 2256 b1 3000 dd1
151
152 include/diff_tables.inc [server1:t1, server2:t1]
153 DROP TABLE IF EXISTS test.t1;
154 DROP TABLE IF EXISTS test.t2;
155 include/rpl_sync.inc
156 include/group_replication_end.inc