diff options
Diffstat (limited to 'mysql-test/r/federated_innodb.result')
-rw-r--r-- | mysql-test/r/federated_innodb.result | 34 |
1 files changed, 0 insertions, 34 deletions
diff --git a/mysql-test/r/federated_innodb.result b/mysql-test/r/federated_innodb.result deleted file mode 100644 index 70ba3acb279..00000000000 --- a/mysql-test/r/federated_innodb.result +++ /dev/null @@ -1,34 +0,0 @@ -stop slave; -drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; -reset master; -reset slave; -drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; -start slave; -stop slave; -DROP DATABASE IF EXISTS federated; -CREATE DATABASE federated; -DROP DATABASE IF EXISTS federated; -CREATE DATABASE federated; -create table federated.t1 (a int primary key, b varchar(64)) -engine=myisam; -create table federated.t1 (a int primary key, b varchar(64)) -engine=federated -connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; -insert into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe"); -ERROR 23000: Can't write; duplicate key in table 't1' -select * from federated.t1; -a b -1 Larry -2 Curly -truncate federated.t1; -alter table federated.t1 engine=innodb; -insert into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe"); -ERROR 23000: Can't write; duplicate key in table 't1' -select * from federated.t1; -a b -drop table federated.t1; -drop table federated.t1; -DROP TABLE IF EXISTS federated.t1; -DROP DATABASE IF EXISTS federated; -DROP TABLE IF EXISTS federated.t1; -DROP DATABASE IF EXISTS federated; |