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