Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_blob_myisam.result

raw
1 include/master-slave.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 master]
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,
11 data LONGBLOB, PRIMARY KEY(c1))ENGINE=#;
12
13 **** Data Insert Section test.t1 *****
14
15 INSERT INTO test.t1 VALUES (NULL, NULL);
16 INSERT INTO test.t1 VALUES (NULL, repeat('a',1*1024));
17 INSERT INTO test.t1 VALUES (NULL, repeat('b',16*1024));
18
19 **** Data Insert Validation Master Section test.t1 ****
20
21 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
22 LENGTH(data)
23 NULL
24 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 2;
25 LENGTH(data)
26 1024
27 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 3;
28 LENGTH(data)
29 16384
30 include/sync_slave_sql_with_master.inc
31
32 **** Data Insert Validation Slave Section test.t1 ****
33
34 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
35 LENGTH(data)
36 NULL
37 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 2;
38 LENGTH(data)
39 1024
40 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 3;
41 LENGTH(data)
42 16384
43
44 **** Data Update Section test.t1 ****
45
46 UPDATE test.t1 set data=repeat('a',18*1024) where c1 = 1;
47 UPDATE t1 set data=repeat('c',17*1024) where c1 = 2;
48
49 **** Data Update Validation Master Section test.t1 ****
50
51 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
52 LENGTH(data)
53 18432
54 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 2;
55 LENGTH(data)
56 17408
57 include/sync_slave_sql_with_master.inc
58
59 **** Data Update Validation Slave Section test.t1 ****
60
61 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 1;
62 LENGTH(data)
63 18432
64 SELECT LENGTH(data) FROM test.t1 WHERE c1 = 2;
65 LENGTH(data)
66 17408
67
68 **** End Test Section test.t1 ****
69
70 **** Create Table test.t2 ****
71
72 CREATE TABLE test.t2 (
73 c1 INT NOT NULL PRIMARY KEY,
74 c2 TEXT,
75 c3 INT,
76 c4 LONGBLOB,
77 KEY(c3))ENGINE=#;
78
79 *** Setup Values For test.t2 ***
80 set @x0 = '01234567012345670123456701234567';
81 set @x0 = concat(@x0,@x0,@x0,@x0,@x0,@x0,@x0,@x0);
82 set @b1 = 'b1';
83 set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1);
84 set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1);
85 set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1);
86 set @b1 = concat(@b1,@x0);
87 set @d1 = 'dd1';
88 set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1);
89 set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1);
90 set @d1 = concat(@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1,@d1);
91 set @b2 = 'b2';
92 set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
93 set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
94 set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
95 set @b2 = concat(@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2,@b2);
96 set @d2 = 'dd2';
97 set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
98 set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
99 set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
100 set @d2 = concat(@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2,@d2);
101
102 **** Data Insert Section test.t2 *****
103
104 INSERT INTO test.t2 VALUES(1,@b1,111,@d1);
105 INSERT INTO test.t2 VALUES(2,@b2,222,@d2);
106
107 **** Data Insert Validation Master Section test.t2 ****
108
109 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
110 FROM test.t2 WHERE c1=1;
111 c1 LENGTH(c2) SUBSTR(c2,1+2*900,2) LENGTH(c4) SUBSTR(c4,1+3*900,3)
112 1 2256 b1 3000 dd1
113 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
114 FROM test.t2 WHERE c1=2;
115 c1 LENGTH(c2) SUBSTR(c2,1+2*900,2) LENGTH(c4) SUBSTR(c4,1+3*900,3)
116 2 20000 b2 30000 dd2
117 include/sync_slave_sql_with_master.inc
118
119 **** Data Insert Validation Slave Section test.t2 ****
120
121 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
122 FROM test.t2 WHERE c1=1;
123 c1 LENGTH(c2) SUBSTR(c2,1+2*900,2) LENGTH(c4) SUBSTR(c4,1+3*900,3)
124 1 2256 b1 3000 dd1
125 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
126 FROM test.t2 WHERE c1=2;
127 c1 LENGTH(c2) SUBSTR(c2,1+2*900,2) LENGTH(c4) SUBSTR(c4,1+3*900,3)
128 2 20000 b2 30000 dd2
129
130 **** Data Update Section test.t2 ****
131
132 UPDATE test.t2 SET c2=@b2, c4=@d2 WHERE c1=1;
133 UPDATE test.t2 SET c2=@b1, c4=@d1 WHERE c1=2;
134
135 **** Data Update Validation Master Section test.t2 ****
136
137 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
138 FROM test.t2 WHERE c1=1;
139 c1 LENGTH(c2) SUBSTR(c2,1+2*900,2) LENGTH(c4) SUBSTR(c4,1+3*900,3)
140 1 20000 b2 30000 dd2
141 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
142 FROM test.t2 WHERE c1=2;
143 c1 LENGTH(c2) SUBSTR(c2,1+2*900,2) LENGTH(c4) SUBSTR(c4,1+3*900,3)
144 2 2256 b1 3000 dd1
145 include/sync_slave_sql_with_master.inc
146
147 **** Data Update Validation Slave Section test.t2 ****
148
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 c1 LENGTH(c2) SUBSTR(c2,1+2*900,2) LENGTH(c4) SUBSTR(c4,1+3*900,3)
152 1 20000 b2 30000 dd2
153 SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
154 FROM test.t2 WHERE c1=2;
155 c1 LENGTH(c2) SUBSTR(c2,1+2*900,2) LENGTH(c4) SUBSTR(c4,1+3*900,3)
156 2 2256 b1 3000 dd1
157
158 DROP TABLE IF EXISTS test.t1;
159 DROP TABLE IF EXISTS test.t2;
160 include/sync_slave_sql_with_master.inc
161 include/rpl_end.inc