diff options
Diffstat (limited to 'mysql-test/suite/federated/federated_partition.result')
-rw-r--r-- | mysql-test/suite/federated/federated_partition.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/suite/federated/federated_partition.result b/mysql-test/suite/federated/federated_partition.result index 26a6443ffad..8d0840a1d2d 100644 --- a/mysql-test/suite/federated/federated_partition.result +++ b/mysql-test/suite/federated/federated_partition.result @@ -1,8 +1,14 @@ +connect master,127.0.0.1,root,,test,$MASTER_MYPORT,; +connect slave,127.0.0.1,root,,test,$SLAVE_MYPORT,; +connection master; CREATE DATABASE federated; +connection slave; CREATE DATABASE federated; drop table if exists t1; +connection slave; create table federated.t1_1 (s1 int primary key) engine=myisam; create table federated.t1_2 (s1 int primary key) engine=innodb; +connection master; create table t1 (s1 int primary key) engine=federated partition by list (s1) (partition p1 values in (1,3) @@ -25,6 +31,7 @@ s1 3 2 4 +connection slave; select * from federated.t1_1; s1 1 @@ -33,11 +40,15 @@ select * from federated.t1_2; s1 2 4 +connection master; drop table t1; +connection slave; drop table federated.t1_1; drop table federated.t1_2; End of 5.1 tests +connection master; DROP TABLE IF EXISTS federated.t1; DROP DATABASE IF EXISTS federated; +connection slave; DROP TABLE IF EXISTS federated.t1; DROP DATABASE IF EXISTS federated; |