diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_extra_col_slave_myisam.result')
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_extra_col_slave_myisam.result | 122 |
1 files changed, 121 insertions, 1 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_extra_col_slave_myisam.result b/mysql-test/suite/rpl/r/rpl_extra_col_slave_myisam.result index a8710f0de5b..548736b9146 100644 --- a/mysql-test/suite/rpl/r/rpl_extra_col_slave_myisam.result +++ b/mysql-test/suite/rpl/r/rpl_extra_col_slave_myisam.result @@ -3,7 +3,7 @@ include/master-slave.inc call mtr.add_suppression("Slave: Unknown table 't6' error.* 1051"); call mtr.add_suppression("Slave SQL.*Column [0-9] of table .test.t[0-9]*. cannot be converted from type.* error.* 1677"); **** Diff Table Def Start **** -*** On Slave *** +connection slave; STOP SLAVE; RESET SLAVE; SET @saved_slave_type_conversions = @@slave_type_conversions; @@ -13,12 +13,15 @@ d FLOAT DEFAULT '2.00', e CHAR(4) DEFAULT 'TEST') ENGINE='MyISAM'; *** Create t1 on Master *** +connection master; CREATE TABLE t1 (a INT PRIMARY KEY, b INT, c CHAR(10) ) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; INSERT INTO t1 () VALUES(1,2,'TEXAS'),(2,1,'AUSTIN'),(3,4,'QA'); SELECT * FROM t1 ORDER BY a; a b c @@ -26,6 +29,7 @@ a b c 2 1 AUSTIN 3 4 QA *** Select from slave *** +connection slave; SELECT * FROM t1 ORDER BY a; a b c d e 1 2 TEXAS 2 TEST @@ -33,7 +37,9 @@ a b c d e 3 4 QA 2 TEST SET GLOBAL SLAVE_TYPE_CONVERSIONS = @saved_slave_type_conversions; *** Drop t1 *** +connection master; DROP TABLE t1; +connection slave; *** Create t2 on slave *** STOP SLAVE; RESET SLAVE; @@ -42,10 +48,12 @@ d FLOAT DEFAULT '2.00', e CHAR(5) DEFAULT 'TEST2') ENGINE='MyISAM'; *** Create t2 on Master *** +connection master; CREATE TABLE t2 (a INT PRIMARY KEY, b INT, c CHAR(10) ) ENGINE='MyISAM'; RESET MASTER; *** Master Data Insert *** +connection master; INSERT INTO t2 () VALUES(1,2,'Kyle, TEX'),(2,1,'JOE AUSTIN'),(3,4,'QA TESTING'); SELECT * FROM t2 ORDER BY a; a b c @@ -53,6 +61,7 @@ a b c 2 1 JOE AUSTIN 3 4 QA TESTING *** Start Slave *** +connection slave; START SLAVE; include/wait_for_slave_sql_error.inc [errno=1677] Last_SQL_Error = 'Column 2 of table 'test.t2' cannot be converted from type 'char(10)' to type 'char(5)'' @@ -60,10 +69,14 @@ STOP SLAVE; RESET SLAVE; SELECT * FROM t2 ORDER BY a; a b c d e +connection master; RESET MASTER; +connection slave; START SLAVE; *** Drop t2 *** +connection master; DROP TABLE t2; +connection slave; *** Create t3 on slave *** STOP SLAVE; RESET SLAVE; @@ -72,22 +85,28 @@ d FLOAT DEFAULT '2.00', e CHAR(5) DEFAULT 'TEST2') ENGINE='MyISAM'; *** Create t3 on Master *** +connection master; CREATE TABLE t3 (a BLOB, b INT PRIMARY KEY, c CHAR(20) ) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; set @b1 = 'b1'; set @b1 = concat(@b1,@b1); INSERT INTO t3 () VALUES(@b1,2,'Kyle, TEX'),(@b1,1,'JOE AUSTIN'),(@b1,4,'QA TESTING'); ******************************************** *** Expect slave to fail with Error 1677 *** ******************************************** +connection slave; include/wait_for_slave_sql_error_and_skip.inc [errno=1677] Last_SQL_Error = 'Column 0 of table 'test.t3' cannot be converted from type 'tinyblob' to type 'int(11)'' *** Drop t3 *** +connection master; DROP TABLE t3; +connection slave; *** Create t4 on slave *** STOP SLAVE; RESET SLAVE; @@ -96,21 +115,27 @@ d FLOAT DEFAULT '2.00', e CHAR(5) DEFAULT 'TEST2') ENGINE='MyISAM'; *** Create t4 on Master *** +connection master; CREATE TABLE t4 (a DECIMAL(8,2), b INT PRIMARY KEY, c CHAR(20) ) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; INSERT INTO t4 () VALUES(100.22,2,'Kyle, TEX'),(200.26,1,'JOE AUSTIN'), (30000.22,4,'QA TESTING'); ******************************************** *** Expect slave to fail with Error 1677 *** ******************************************** +connection slave; include/wait_for_slave_sql_error_and_skip.inc [errno=1677] Last_SQL_Error = 'Column 0 of table 'test.t4' cannot be converted from type 'decimal(8,2)' to type 'int(11)'' *** Drop t4 *** +connection master; DROP TABLE t4; +connection slave; *** Create t5 on slave *** STOP SLAVE; RESET SLAVE; @@ -118,45 +143,57 @@ CREATE TABLE t5 (a INT PRIMARY KEY, b CHAR(5), c FLOAT, d INT, e DOUBLE, f DECIMAL(8,2))ENGINE='MyISAM'; *** Create t5 on Master *** +connection master; CREATE TABLE t5 (a INT PRIMARY KEY, b VARCHAR(6), c DECIMAL(8,2), d BIT, e BLOB, f FLOAT) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; INSERT INTO t5 () VALUES(1,'Kyle',200.23,1,'b1b1',23.00098), (2,'JOE',300.01,0,'b2b2',1.0000009); ******************************************** *** Expect slave to fail with Error 1677 *** ******************************************** +connection slave; include/wait_for_slave_sql_error_and_skip.inc [errno=1677] Last_SQL_Error = 'Column 1 of table 'test.t5' cannot be converted from type 'varchar(6)' to type 'char(5)'' *** Drop t5 *** +connection master; DROP TABLE t5; +connection slave; *** Create t6 on slave *** STOP SLAVE; RESET SLAVE; CREATE TABLE t6 (a INT PRIMARY KEY, b CHAR(5), c FLOAT, d INT)ENGINE='MyISAM'; *** Create t6 on Master *** +connection master; CREATE TABLE t6 (a INT PRIMARY KEY, b VARCHAR(6), c DECIMAL(8,2), d BIT ) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; INSERT INTO t6 () VALUES(1,'Kyle',200.23,1), (2,'JOE',300.01,0); ******************************************** *** Expect slave to fail with Error 1677 *** ******************************************** +connection slave; include/wait_for_slave_sql_error.inc [errno=1677] Last_SQL_Error = 'Column 1 of table 'test.t6' cannot be converted from type 'varchar(6)' to type 'char(5)'' *** Drop t6 *** include/rpl_reset.inc +connection master; DROP TABLE t6; +connection slave; **** Diff Table Def End **** **** Extra Colums Start **** *** Create t7 on slave *** @@ -167,12 +204,15 @@ d TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00', e CHAR(20) DEFAULT 'Extra Column Testing') ENGINE='MyISAM'; *** Create t7 on Master *** +connection master; CREATE TABLE t7 (a INT PRIMARY KEY, b BLOB, c CHAR(5) ) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; set @b1 = 'b1'; set @b1 = concat(@b1,@b1); INSERT INTO t7 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA'); @@ -182,13 +222,16 @@ a b c 2 b1b1 JOE 3 b1b1 QA *** Select from slave *** +connection slave; SELECT * FROM t7 ORDER BY a; a b c d e 1 b1b1 Kyle 0000-00-00 00:00:00 Extra Column Testing 2 b1b1 JOE 0000-00-00 00:00:00 Extra Column Testing 3 b1b1 QA 0000-00-00 00:00:00 Extra Column Testing *** Drop t7 *** +connection master; DROP TABLE t7; +connection slave; *** Create t8 on slave *** STOP SLAVE; RESET SLAVE; @@ -196,17 +239,22 @@ CREATE TABLE t8 (a INT KEY, b BLOB, c CHAR(5), d TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00', e INT)ENGINE='MyISAM'; *** Create t8 on Master *** +connection master; CREATE TABLE t8 (a INT PRIMARY KEY, b BLOB, c CHAR(5) ) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; set @b1 = 'b1b1b1b1'; set @b1 = concat(@b1,@b1); INSERT INTO t8 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA'); *** Drop t8 *** +connection master; DROP TABLE t8; +connection slave; STOP SLAVE; RESET SLAVE; CREATE TABLE t9 (a INT KEY, b BLOB, c CHAR(5), @@ -218,77 +266,98 @@ g text, h blob not null, i blob) ENGINE='MyISAM'; *** Create t9 on Master *** +connection master; CREATE TABLE t9 (a INT PRIMARY KEY, b BLOB, c CHAR(5) ) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; set @b1 = 'b1b1b1b1'; set @b1 = concat(@b1,@b1); INSERT INTO t9 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA'); +connection slave; select * from t9; a b c d e f g h i 1 b1b1b1b1b1b1b1b1 Kyle 0000-00-00 00:00:00 0 NULL NULL 2 b1b1b1b1b1b1b1b1 JOE 0000-00-00 00:00:00 0 NULL NULL 3 b1b1b1b1b1b1b1b1 QA 0000-00-00 00:00:00 0 NULL NULL +connection master; DROP TABLE t9; +connection slave; *** Create t10 on slave *** STOP SLAVE; RESET SLAVE; CREATE TABLE t10 (a INT KEY, b BLOB, f DOUBLE DEFAULT '233', c CHAR(5), e INT DEFAULT '1')ENGINE='MyISAM'; *** Create t10 on Master *** +connection master; CREATE TABLE t10 (a INT PRIMARY KEY, b BLOB, c CHAR(5) ) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; set @b1 = 'b1b1b1b1'; set @b1 = concat(@b1,@b1); INSERT INTO t10 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA'); ******************************************** *** Expect slave to fail with Error 1677 *** ******************************************** +connection slave; include/wait_for_slave_sql_error_and_skip.inc [errno=1677] Last_SQL_Error = 'Column 2 of table 'test.t10' cannot be converted from type 'char(5)' to type 'double'' *** Drop t10 *** +connection master; DROP TABLE t10; +connection slave; *** Create t11 on slave *** STOP SLAVE; RESET SLAVE; CREATE TABLE t11 (a INT KEY, b BLOB, f INT, c CHAR(5) DEFAULT 'test', e INT DEFAULT '1')ENGINE='MyISAM'; *** Create t11 on Master *** +connection master; CREATE TABLE t11 (a INT PRIMARY KEY, b BLOB, c VARCHAR(254) ) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; set @b1 = 'b1b1b1b1'; set @b1 = concat(@b1,@b1); INSERT INTO t11 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA'); ******************************************** *** Expect slave to fail with Error 1677 *** ******************************************** +connection slave; include/wait_for_slave_sql_error_and_skip.inc [errno=1677] Last_SQL_Error = 'Column 2 of table 'test.t11' cannot be converted from type 'varchar(254)' to type 'int(11)'' *** Drop t11 *** +connection master; DROP TABLE t11; +connection slave; *** Create t12 on slave *** STOP SLAVE; RESET SLAVE; CREATE TABLE t12 (a INT KEY, b BLOB, f TEXT, c CHAR(5) DEFAULT 'test', e INT DEFAULT '1')ENGINE='MyISAM'; *** Create t12 on Master *** +connection master; CREATE TABLE t12 (a INT PRIMARY KEY, b BLOB, c BLOB ) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; set @b1 = 'b1b1b1b1'; set @b1 = concat(@b1,@b1); INSERT INTO t12 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA'); @@ -298,13 +367,16 @@ a b c 2 b1b1b1b1b1b1b1b1 JOE 3 b1b1b1b1b1b1b1b1 QA *** Select on Slave *** +connection slave; SELECT * FROM t12 ORDER BY a; a b f c e 1 b1b1b1b1b1b1b1b1 Kyle test 1 2 b1b1b1b1b1b1b1b1 JOE test 1 3 b1b1b1b1b1b1b1b1 QA test 1 *** Drop t12 *** +connection master; DROP TABLE t12; +connection slave; **** Extra Colums End **** *** BUG 22177 Start *** *** Create t13 on slave *** @@ -315,12 +387,15 @@ d INT DEFAULT '1', e TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP )ENGINE='MyISAM'; *** Create t13 on Master *** +connection master; CREATE TABLE t13 (a INT PRIMARY KEY, b BLOB, c CHAR(5) ) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; set @b1 = 'b1b1b1b1'; set @b1 = concat(@b1,@b1); INSERT INTO t13 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA'); @@ -330,13 +405,16 @@ a b c 2 b1b1b1b1b1b1b1b1 JOE 3 b1b1b1b1b1b1b1b1 QA *** Select on Slave **** +connection slave; SELECT * FROM t13 ORDER BY a; a b c d e 1 b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP 2 b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP 3 b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP *** Drop t13 *** +connection master; DROP TABLE t13; +connection slave; *** 22117 END *** *** Alter Master Table Testing Start *** *** Create t14 on slave *** @@ -347,12 +425,15 @@ c6 INT DEFAULT '1', c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP )ENGINE='MyISAM'; *** Create t14 on Master *** +connection master; CREATE TABLE t14 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5) ) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; ALTER TABLE t14 ADD COLUMN c2 DECIMAL(8,2) AFTER c1; ALTER TABLE t14 ADD COLUMN c3 TEXT AFTER c2; set @b1 = 'b1b1b1b1'; @@ -366,6 +447,7 @@ c1 c2 c3 c4 c5 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA *** Select on Slave **** +connection slave; SELECT * FROM t14 ORDER BY c1; c1 c2 c3 c4 c5 c6 c7 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP @@ -379,12 +461,15 @@ c6 INT DEFAULT '1', c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP )ENGINE='MyISAM'; *** Create t14a on Master *** +connection master; CREATE TABLE t14a (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5) ) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; set @b1 = 'b1b1b1b1'; set @b1 = concat(@b1,@b1); INSERT INTO t14a () VALUES(1,@b1,'Kyle'), @@ -396,6 +481,7 @@ c1 c4 c5 2 b1b1b1b1b1b1b1b1 JOE 3 b1b1b1b1b1b1b1b1 QA *** Select on Slave **** +connection slave; SELECT * FROM t14a ORDER BY c1; c1 c4 c5 c6 c7 1 b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP @@ -404,11 +490,14 @@ c1 c4 c5 c6 c7 STOP SLAVE; RESET SLAVE; *** Master Drop c5 *** +connection master; ALTER TABLE t14a DROP COLUMN c5; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; set @b1 = 'b1b1b1b1'; set @b1 = concat(@b1,@b1); INSERT INTO t14a () VALUES(4,@b1), @@ -423,6 +512,7 @@ c1 c4 5 b1b1b1b1b1b1b1b1 6 b1b1b1b1b1b1b1b1 *** Select on Slave **** +connection slave; SELECT * FROM t14a ORDER BY c1; c1 c4 c5 c6 c7 1 b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP @@ -431,8 +521,11 @@ c1 c4 c5 c6 c7 4 b1b1b1b1b1b1b1b1 NULL 1 CURRENT_TIMESTAMP 5 b1b1b1b1b1b1b1b1 NULL 1 CURRENT_TIMESTAMP 6 b1b1b1b1b1b1b1b1 NULL 1 CURRENT_TIMESTAMP +connection master; DROP TABLE t14a; +connection slave; *** connect to master and drop columns *** +connection master; ALTER TABLE t14 DROP COLUMN c2; ALTER TABLE t14 DROP COLUMN c4; *** Select from Master *** @@ -442,13 +535,16 @@ c1 c3 c5 2 This Test Should work JOE 3 If is does not, I will open a bug QA *** Select from Slave *** +connection slave; SELECT * FROM t14 ORDER BY c1; c1 c3 c5 c6 c7 1 Replication Testing Extra Col Kyle 1 CURRENT_TIMESTAMP 2 This Test Should work JOE 1 CURRENT_TIMESTAMP 3 If is does not, I will open a bug QA 1 CURRENT_TIMESTAMP *** Drop t14 *** +connection master; DROP TABLE t14; +connection slave; *** Create t15 on slave *** STOP SLAVE; RESET SLAVE; @@ -458,15 +554,18 @@ c6 INT DEFAULT '1', c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP )ENGINE='MyISAM'; *** Create t15 on Master *** +connection master; CREATE TABLE t15 (c1 INT PRIMARY KEY, c2 DECIMAL(8,2), c3 TEXT, c4 BLOB, c5 CHAR(5)) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; call mtr.add_suppression("Error .Unknown table .t6.. on query.* error.* 1051"); call mtr.add_suppression("Error .Duplicate column name .c6.. on query.* error.* 1060"); call mtr.add_suppression("Table definition on master and slave does not match: Column . ...e mismatch.* error.* 1535"); *** Master Data Insert *** +connection master; set @b1 = 'b1b1b1b1'; set @b1 = concat(@b1,@b1); INSERT INTO t15 () VALUES(1,1.00,'Replication Testing Extra Col',@b1,'Kyle'), @@ -478,19 +577,23 @@ c1 c2 c3 c4 c5 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA *** Select on Slave **** +connection slave; SELECT * FROM t15 ORDER BY c1; c1 c2 c3 c4 c5 c6 c7 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP *** Add column on master that is a Extra on Slave *** +connection master; ALTER TABLE t15 ADD COLUMN c6 INT AFTER c5; ******************************************** *** Expect slave to fail with Error 1060 *** ******************************************** +connection slave; include/wait_for_slave_sql_error_and_skip.inc [errno=1060] Last_SQL_Error = 'Error 'Duplicate column name 'c6'' on query. Default database: 'test'. Query: 'ALTER TABLE t15 ADD COLUMN c6 INT AFTER c5'' *** Try to insert in master **** +connection master; INSERT INTO t15 () VALUES(5,2.00,'Replication Testing',@b1,'Buda',2); SELECT * FROM t15 ORDER BY c1; c1 c2 c3 c4 c5 c6 @@ -499,6 +602,7 @@ c1 c2 c3 c4 c5 c6 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA NULL 5 2.00 Replication Testing b1b1b1b1b1b1b1b1 Buda 2 *** Try to select from slave **** +connection slave; SELECT * FROM t15 ORDER BY c1; c1 c2 c3 c4 c5 c6 c7 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP @@ -506,7 +610,9 @@ c1 c2 c3 c4 c5 c6 c7 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP 5 2.00 Replication Testing b1b1b1b1b1b1b1b1 Buda 2 CURRENT_TIMESTAMP *** DROP TABLE t15 *** +connection master; DROP TABLE t15; +connection slave; *** Create t16 on slave *** STOP SLAVE; RESET SLAVE; @@ -516,12 +622,15 @@ c6 INT DEFAULT '1', c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP )ENGINE='MyISAM'; *** Create t16 on Master *** +connection master; CREATE TABLE t16 (c1 INT PRIMARY KEY, c2 DECIMAL(8,2), c3 TEXT, c4 BLOB, c5 CHAR(5))ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; set @b1 = 'b1b1b1b1'; set @b1 = concat(@b1,@b1); INSERT INTO t16 () VALUES(1,1.00,'Replication Testing Extra Col',@b1,'Kyle'), @@ -533,12 +642,14 @@ c1 c2 c3 c4 c5 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA *** Select on Slave **** +connection slave; SELECT * FROM t16 ORDER BY c1; c1 c2 c3 c4 c5 c6 c7 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP *** Add Partition on master *** +connection master; ALTER TABLE t16 PARTITION BY KEY(c1) PARTITIONS 4; INSERT INTO t16 () VALUES(4,1.00,'Replication Rocks',@b1,'Omer'); SHOW CREATE TABLE t16; @@ -554,6 +665,7 @@ t16 CREATE TABLE `t16` ( /*!50100 PARTITION BY KEY (c1) PARTITIONS 4 */ *** Show table on Slave **** +connection slave; SHOW CREATE TABLE t16; Table Create Table t16 CREATE TABLE `t16` ( @@ -569,7 +681,9 @@ t16 CREATE TABLE `t16` ( /*!50100 PARTITION BY KEY (c1) PARTITIONS 4 */ *** DROP TABLE t16 *** +connection master; DROP TABLE t16; +connection slave; *** Alter Master End *** *** Create t17 on slave *** STOP SLAVE; @@ -579,18 +693,24 @@ d FLOAT DEFAULT '2.00', e CHAR(5) DEFAULT 'TEST2') ENGINE='MyISAM'; *** Create t17 on Master *** +connection master; CREATE TABLE t17 (a BIGINT PRIMARY KEY, b INT, c CHAR(10) ) ENGINE='MyISAM'; RESET MASTER; *** Start Slave *** +connection slave; START SLAVE; *** Master Data Insert *** +connection master; INSERT INTO t17 () VALUES(9223372036854775807,2,'Kyle, TEX'); ******************************************** *** Expect slave to fail with Error 1677 *** ******************************************** +connection slave; include/wait_for_slave_sql_error_and_skip.inc [errno=1677] Last_SQL_Error = 'Column 0 of table 'test.t17' cannot be converted from type 'bigint' to type 'smallint(6)'' ** DROP table t17 *** +connection master; DROP TABLE t17; +connection slave; include/rpl_end.inc |