summaryrefslogtreecommitdiff
path: root/mysql-test/r/federated_innodb.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/federated_innodb.result')
-rw-r--r--mysql-test/r/federated_innodb.result34
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;