Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 DROP TABLE IF EXISTS t1;
4 **** Testing WL#3228 changes. ****
5 *** Create "wider" table on slave ***
6 connection slave;
7 STOP SLAVE;
8 include/wait_for_slave_to_stop.inc
9 include/reset_slave.inc
10 SET @saved_slave_type_conversions = @@slave_type_conversions;
11 SET GLOBAL SLAVE_TYPE_CONVERSIONS = 'ALL_NON_LOSSY';
12 CREATE TABLE t1 (
13 a float (47),
14 b double (143,9),
15 c decimal (65,30),
16 d numeric (4,0),
17 e bit (32),
18 f char (21),
19 g varchar (1300),
20 h binary (33),
21 j varbinary (200),
22 k enum ('5','6','7', '8','9','0'),
23 l set ('1','2','3','4','5','6','7','8','9','0','11','12','13','14','15','16','17','18','19','21','22','23','24','25','26','27','28','29'),
24 m TINYBLOB,
25 n BLOB,
26 o MEDIUMBLOB,
27 p LONGBLOB,
28 q TINYTEXT,
29 r TEXT,
30 s MEDIUMTEXT,
31 t LONGTEXT
32 );
33 *** Create same table on master but with narrow columns ***
34 connection master;
35 CREATE TABLE t1 (
36 a float (44),
37 b double (10,3),
38 c decimal (10,2),
39 d numeric (3,0),
40 e bit (16),
41 f char (10),
42 g varchar (100),
43 h binary (20),
44 j varbinary (20),
45 k enum ('5','6','7'),
46 l set ('1','2','3','4','5','6','7','8','9','0'),
47 m TINYBLOB,
48 n BLOB,
49 o MEDIUMBLOB,
50 p LONGBLOB,
51 q TINYTEXT,
52 r TEXT,
53 s MEDIUMTEXT,
54 t LONGTEXT
55 );
56 RESET MASTER;
57 *** Start replication ***
58 connection slave;
59 START SLAVE;
60 include/wait_for_slave_to_start.inc
61 *** Insert data on master and display it. ***
62 connection master;
63 INSERT INTO t1 () VALUES (
64 17.567,
65 2.123,
66 10.20,
67 125,
68 hex(64),
69 'TEST',
70 'This is a test',
71 'binary data',
72 'more binary data',
73 '6',
74 '7',
75 "blob 1",
76 "blob 2",
77 "blob 3",
78 "blob 4",
79 "text 1",
80 "text 2",
81 "text 3",
82 "text 4");
83 SELECT * FROM t1 ORDER BY a;
84 a b c d e f g h j k l m n o p q r s t
85 17.567 2.123 10.20 125 # TEST This is a test # more binary data 6 7 blob 1 blob 2 blob 3 blob 4 text 1 text 2 text 3 text 4
86 *** Select data from slave to compare ***
87 connection slave;
88 connection slave;
89 SELECT * FROM t1 ORDER BY a;
90 a b c d e f g h j k l m n o p q r s t
91 17.567 2.123000000 10.200000000000000000000000000000 125 # TEST This is a test # more binary data 6 7 blob 1 blob 2 blob 3 blob 4 text 1 text 2 text 3 text 4
92 connection master;
93 DROP TABLE t1;
94 Create varchar table on master
95 CREATE TABLE t1 (
96 a VARCHAR(50),
97 b VARCHAR(100),
98 c VARCHAR(300),
99 d CHAR(5)
100 );
101 connection slave;
102 Alter varchar table on slave
103 ALTER TABLE t1 CHANGE COLUMN a a VARCHAR(100);
104 ALTER TABLE t1 CHANGE COLUMN b b VARCHAR(400);
105 ALTER TABLE t1 CHANGE COLUMN c c VARCHAR(500);
106 ALTER TABLE t1 CHANGE COLUMN d d CHAR(100);
107 connection master;
108 Insert some values and select them on master
109 INSERT INTO t1 VALUES ("This is a test of col a.",
110 "This is another test of col b.",
111 "This is a test of the large col c.",
112 "Col d");
113 SELECT * FROM t1;
114 a b c d
115 This is a test of col a. This is another test of col b. This is a test of the large col c. Col d
116 SHOW CREATE TABLE t1;
117 Table Create Table
118 t1 CREATE TABLE `t1` (
119 `a` varchar(50) DEFAULT NULL,
120 `b` varchar(100) DEFAULT NULL,
121 `c` varchar(300) DEFAULT NULL,
122 `d` char(5) DEFAULT NULL
123 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
124 connection slave;
125 Insert some values and select them on slave
126 SELECT * FROM t1;
127 a b c d
128 This is a test of col a. This is another test of col b. This is a test of the large col c. Col d
129 SHOW CREATE TABLE t1;
130 Table Create Table
131 t1 CREATE TABLE `t1` (
132 `a` varchar(100) DEFAULT NULL,
133 `b` varchar(400) DEFAULT NULL,
134 `c` varchar(500) DEFAULT NULL,
135 `d` char(100) DEFAULT NULL
136 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
137 connection master;
138 DROP TABLE t1;
139 Create bit table on master
140 CREATE TABLE t1 (
141 a BIT(7),
142 b BIT(8),
143 c BIT(21),
144 d BIT(11),
145 e BIT(11)
146 );
147 connection slave;
148 Create bit table on slave
149 DROP TABLE t1;
150 CREATE TABLE t1 (
151 a BIT(16),
152 b BIT(22),
153 c BIT(54),
154 d BIT(25),
155 e BIT(13)
156 );
157 connection master;
158 Insert some values and select them on master
159 INSERT INTO t1 VALUES (
160 b'1010101',
161 b'10101011',
162 b'101010110101010101111',
163 b'10101010101',
164 b'10101011111'
165 );
166 SELECT BIN(a), BIN(b), BIN(c), BIN(d), BIN(e) FROM t1;
167 BIN(a) BIN(b) BIN(c) BIN(d) BIN(e)
168 1010101 10101011 101010110101010101111 10101010101 10101011111
169 SHOW CREATE TABLE t1;
170 Table Create Table
171 t1 CREATE TABLE `t1` (
172 `a` bit(7) DEFAULT NULL,
173 `b` bit(8) DEFAULT NULL,
174 `c` bit(21) DEFAULT NULL,
175 `d` bit(11) DEFAULT NULL,
176 `e` bit(11) DEFAULT NULL
177 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
178 connection slave;
179 Insert some values and select them on master
180 SELECT BIN(a), BIN(b), BIN(c), BIN(d), BIN(e) FROM t1;
181 BIN(a) BIN(b) BIN(c) BIN(d) BIN(e)
182 1010101 10101011 101010110101010101111 10101010101 10101011111
183 SHOW CREATE TABLE t1;
184 Table Create Table
185 t1 CREATE TABLE `t1` (
186 `a` bit(16) DEFAULT NULL,
187 `b` bit(22) DEFAULT NULL,
188 `c` bit(54) DEFAULT NULL,
189 `d` bit(25) DEFAULT NULL,
190 `e` bit(13) DEFAULT NULL
191 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
192 *** Cleanup ***
193 connection master;
194 DROP TABLE t1;
195 connection slave;
196 SET GLOBAL SLAVE_TYPE_CONVERSIONS = @saved_slave_type_conversions;
197 include/rpl_end.inc