Debian Codegraph @

mysql-test/suite/rpl/t/rpl_row_colSize.test

raw
1 ##################################################################
2 # rpl_colSize #
3 # #
4 # This test is designed to test the changes included in WL#3228. #
5 # The changes include the ability to replicate with the master #
6 # having columns that are smaller (shorter) than the slave. #
7 ##################################################################
8 -- source include/not_group_replication_plugin.inc
9 -- source include/have_binlog_format_row.inc
10 -- source include/master-slave.inc
11
12
13 --echo **** Testing WL#3228 changes. ****
14 --echo *** Create "wider" table on slave ***
15 --source include/sync_slave_sql_with_master.inc
16
17 #
18 # Check each column type to verify error 1532 fires (BUG#22086)
19 # This check covers only those fields that require additional
20 # metadata from the master to be replicated to the slave. These
21 # field types are:
22 # MYSQL_TYPE_NEWDECIMAL:
23 # MYSQL_TYPE_FLOAT:
24 # MYSQL_TYPE_BIT:
25 # MYSQL_TYPE_SET:
26 # MYSQL_TYPE_STRING:
27 # MYSQL_TYPE_ENUM:
28 # MYSQL_TYPE_VARCHAR:
29 # MYSQL_TYPE_BLOB:
30
31 #
32 # Test: Checking MYSQL_TYPE_NEWDECIMAL fields
33 #
34 --echo Checking MYSQL_TYPE_NEWDECIMAL fields
35 let $test_table_master = CREATE TABLE t1 (a DECIMAL(20, 10));
36 let $test_table_slave = CREATE TABLE t1 (a DECIMAL(5,2));
37 let $test_insert = INSERT INTO t1 VALUES (901251.90125);
38 source include/test_fieldsize.inc;
39
40 let $test_table_master = CREATE TABLE t1 (a DECIMAL(27, 18));
41 let $test_table_slave = CREATE TABLE t1 (a DECIMAL(27, 9));
42 let $test_insert = INSERT INTO t1 VALUES (901251.90125);
43 source include/test_fieldsize.inc;
44
45 let $test_table_master = CREATE TABLE t1 (a NUMERIC(20, 10));
46 let $test_table_slave = CREATE TABLE t1 (a NUMERIC(5,2));
47 let $test_insert = INSERT INTO t1 VALUES (901251.90125);
48 source include/test_fieldsize.inc;
49
50 #
51 # Test: Checking MYSQL_TYPE_FLOAT fields
52 #
53 --echo Checking MYSQL_TYPE_FLOAT fields
54 let $test_table_master = CREATE TABLE t1 (a FLOAT(47));
55 let $test_table_slave = CREATE TABLE t1 (a FLOAT(20));
56 let $test_insert = INSERT INTO t1 VALUES (901251.90125);
57 source include/test_fieldsize.inc;
58
59 #
60 # Test: Checking MYSQL_TYPE_BIT fields
61 #
62 --echo Checking MYSQL_TYPE_BIT fields
63 let $test_table_master = CREATE TABLE t1 (a BIT(64));
64 let $test_table_slave = CREATE TABLE t1 (a BIT(5));
65 let $test_insert = INSERT INTO t1 VALUES (B'10101');
66 source include/test_fieldsize.inc;
67
68 let $test_table_master = CREATE TABLE t1 (a BIT(12));
69 let $test_table_slave = CREATE TABLE t1 (a BIT(11));
70 let $test_insert = INSERT INTO t1 VALUES (B'10101');
71 source include/test_fieldsize.inc;
72
73 #
74 # Test: Checking MYSQL_TYPE_SET fields
75 #
76 --echo Checking MYSQL_TYPE_SET fields
77 let $test_table_master = CREATE TABLE t1 (a SET('1','2','3','4','5','6','7','8','9'));
78 let $test_table_slave = CREATE TABLE t1 (a SET('4'));
79 let $test_insert = INSERT INTO t1 VALUES ('4');
80 source include/test_fieldsize.inc;
81
82 #
83 # Test: Checking MYSQL_TYPE_STRING fields
84 #
85 --echo Checking MYSQL_TYPE_STRING fields
86 let $test_table_master = CREATE TABLE t1 (a CHAR(20));
87 let $test_table_slave = CREATE TABLE t1 (a CHAR(10));
88 let $test_insert = INSERT INTO t1 VALUES ('This is a test.');
89 source include/test_fieldsize.inc;
90
91 #
92 # Test: Checking MYSQL_TYPE_ENUM fields
93 #
94 --echo Checking MYSQL_TYPE_ENUM fields
95 let $test_table_master = CREATE TABLE t1 (a ENUM(
96 '01','02','03','04','05','06','07','08','09',
97 '11','12','13','14','15','16','17','18','19',
98 '21','22','23','24','25','26','27','28','29',
99 '31','32','33','34','35','36','37','38','39',
100 '41','42','43','44','45','46','47','48','49',
101 '51','52','53','54','55','56','57','58','59',
102 '61','62','63','64','65','66','67','68','69',
103 '71','72','73','74','75','76','77','78','79',
104 '81','82','83','84','85','86','87','88','89',
105 '91','92','93','94','95','96','97','98','99',
106 '101','102','103','104','105','106','107','108','109',
107 '111','112','113','114','115','116','117','118','119',
108 '121','122','123','124','125','126','127','128','129',
109 '131','132','133','134','135','136','137','138','139',
110 '141','142','143','144','145','146','147','148','149',
111 '151','152','153','154','155','156','157','158','159',
112 '161','162','163','164','165','166','167','168','169',
113 '171','172','173','174','175','176','177','178','179',
114 '181','182','183','184','185','186','187','188','189',
115 '191','192','193','194','195','196','197','198','199',
116 '201','202','203','204','205','206','207','208','209',
117 '211','212','213','214','215','216','217','218','219',
118 '221','222','223','224','225','226','227','228','229',
119 '231','232','233','234','235','236','237','238','239',
120 '241','242','243','244','245','246','247','248','249',
121 '251','252','253','254','255','256','257','258','259',
122 '261','262','263','264','265','266','267','268','269',
123 '271','272','273','274','275','276','277','278','279',
124 '281','282','283','284','285','286','287','288','289',
125 '291','292','293','294','295','296','297','298','299'
126 ));
127 let $test_table_slave = CREATE TABLE t1 (a ENUM('44','54'));
128 let $test_insert = INSERT INTO t1 VALUES ('44');
129 source include/test_fieldsize.inc;
130
131 #
132 # Test: Checking MYSQL_TYPE_VARCHAR fields
133 #
134 --echo Checking MYSQL_TYPE_VARCHAR fields
135 let $test_table_master = CREATE TABLE t1 (a VARCHAR(2000));
136 let $test_table_slave = CREATE TABLE t1 (a VARCHAR(100));
137 let $test_insert = INSERT INTO t1 VALUES ('This is a test.');
138 source include/test_fieldsize.inc;
139
140 let $test_table_master = CREATE TABLE t1 (a VARCHAR(200));
141 let $test_table_slave = CREATE TABLE t1 (a VARCHAR(10));
142 let $test_insert = INSERT INTO t1 VALUES ('This is a test.');
143 source include/test_fieldsize.inc;
144
145 let $test_table_master = CREATE TABLE t1 (a VARCHAR(2000));
146 let $test_table_slave = CREATE TABLE t1 (a VARCHAR(1000));
147 let $test_insert = INSERT INTO t1 VALUES ('This is a test.');
148 source include/test_fieldsize.inc;
149
150 #
151 # Test: Checking MYSQL_TYPE_BLOB fields
152 #
153 --echo Checking MYSQL_TYPE_BLOB fields
154 let $test_table_master = CREATE TABLE t1 (a LONGBLOB);
155 let $test_table_slave = CREATE TABLE t1 (a TINYBLOB);
156 let $test_insert = INSERT INTO t1 VALUES ('This is a test.');
157 source include/test_fieldsize.inc;
158
159 connection slave;
160 call mtr.add_suppression("Replica SQL.*Table definition on source and replica does not match: Column 0 ...e mismatch.* Error_code: MY-001535");
161 call mtr.add_suppression("Replica SQL.*Column 0 of table .test.t1. cannot be converted from type.* Error_code: MY-013146");
162 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
163
164 --echo *** Cleanup ***
165 connection master;
166 DROP TABLE IF EXISTS t1;
167 --source include/sync_slave_sql_with_master.inc
168 # END 5.1 Test Case
169
170 --source include/rpl_end.inc