diff options
| author | Satya B <satya.bn@sun.com> | 2009-03-19 14:19:51 +0530 |
|---|---|---|
| committer | Satya B <satya.bn@sun.com> | 2009-03-19 14:19:51 +0530 |
| commit | 5c49e6ebb38467d0fd6fc65bbeb1eecbe13f2f70 (patch) | |
| tree | 7a338d6b708fbda61ade36477a94e80718b415f7 /mysql-test/suite/federated/federated.result | |
| parent | 53849a24f97ad28a46dfb2a76a987676dda476fe (diff) | |
| parent | 322fe7419f56cbb9ff4d7ded4de852c63b67b0e0 (diff) | |
| download | mariadb-git-5c49e6ebb38467d0fd6fc65bbeb1eecbe13f2f70.tar.gz | |
Merge 5.0-bugteam to 5.1-bugteam
Diffstat (limited to 'mysql-test/suite/federated/federated.result')
| -rw-r--r-- | mysql-test/suite/federated/federated.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/suite/federated/federated.result b/mysql-test/suite/federated/federated.result index e54aa63b2ac..57f665995a1 100644 --- a/mysql-test/suite/federated/federated.result +++ b/mysql-test/suite/federated/federated.result @@ -2130,6 +2130,26 @@ SELECT t1.a FROM t1, t1 as t2 WHERE t2.b NOT LIKE t1.b; a DROP TABLE t1; DROP TABLE t1; +# +# BUG#21360 - mysqldump error on federated tables +# +#Switch to Connection Slave +CREATE TABLE t1(id VARCHAR(20) NOT NULL, PRIMARY KEY(id)); +INSERT INTO t1 VALUES ('text1'),('text2'),('text3'),('text4'); +#Switch to Connection Master +CREATE TABLE t1(id VARCHAR(20) NOT NULL, PRIMARY KEY(id)) ENGINE=FEDERATED +CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; +# Dump table t1 using mysqldump tool +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `t1` ( + `id` varchar(20) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE t1; +#Switch to Connection Slave +DROP TABLE t1; End of 5.0 tests create server 's1' foreign data wrapper 'mysql' options (port 3306); drop server 's1'; |