diff options
Diffstat (limited to 'mysql-test/suite/federated/assisted_discovery.result')
| -rw-r--r-- | mysql-test/suite/federated/assisted_discovery.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/suite/federated/assisted_discovery.result b/mysql-test/suite/federated/assisted_discovery.result index 7a351b9df6f..76ac6e422cd 100644 --- a/mysql-test/suite/federated/assisted_discovery.result +++ b/mysql-test/suite/federated/assisted_discovery.result @@ -1,5 +1,10 @@ +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; +connection slave; CREATE TABLE t1 ( `id` int(20) primary key, `group` int NOT NULL default 1, @@ -7,6 +12,7 @@ CREATE TABLE t1 ( `a\\` int unsigned, `name` varchar(32) default 'name') DEFAULT CHARSET=latin1; +connection master; CREATE TABLE t1 ENGINE=FEDERATED CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; SHOW CREATE TABLE t1; @@ -26,12 +32,15 @@ id group a\\b a\\ name 1 1 2 NULL foo 2 1 2 NULL fee DROP TABLE t1; +connection slave; SELECT * FROM t1; id group a\\b a\\ name 1 1 2 NULL foo 2 1 2 NULL fee DROP TABLE t1; +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; |