diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2013-05-20 23:58:44 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-05-20 23:58:44 +0200 |
| commit | 62ab6982a43a99f9da1d4b140111a5db6f377de1 (patch) | |
| tree | 4b257e337b83f5251d386453fca7fc981ab27d07 /mysql-test | |
| parent | 7e4150d7cd893d8f27276b2304bebb39e909feda (diff) | |
| download | mariadb-git-62ab6982a43a99f9da1d4b140111a5db6f377de1.tar.gz | |
MDEV-388 Creating a federated table with a non-existing server returns a random error code
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/suite/federated/federatedx.result | 7 | ||||
| -rw-r--r-- | mysql-test/suite/federated/federatedx.test | 8 |
2 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/suite/federated/federatedx.result b/mysql-test/suite/federated/federatedx.result index 2ece1a32b4f..af34af05e7d 100644 --- a/mysql-test/suite/federated/federatedx.result +++ b/mysql-test/suite/federated/federatedx.result @@ -2157,6 +2157,13 @@ DROP TABLE federated.t1; End of 5.1 tests SET @@GLOBAL.CONCURRENT_INSERT= @OLD_MASTER_CONCURRENT_INSERT; SET @@GLOBAL.CONCURRENT_INSERT= @OLD_SLAVE_CONCURRENT_INSERT; +CREATE TABLE t1 (a INT) ENGINE=FEDERATED CONNECTION='non_existing'; +ERROR HY000: Can't create/write to file 'server name: 'non_existing' doesn't exist!' (Errcode: 16) +SHOW WARNINGS; +Level Code Message +Error 1 Can't create/write to file 'server name: 'non_existing' doesn't exist!' (Errcode: 16) +Error 1 Can't create/write to file 'non_existing' (Errcode: 14) +Error 1005 Can't create table 'test.t1' (errno: 1) DROP TABLE IF EXISTS federated.t1; DROP DATABASE IF EXISTS federated; DROP TABLE IF EXISTS federated.t1; diff --git a/mysql-test/suite/federated/federatedx.test b/mysql-test/suite/federated/federatedx.test index 15fdd47c4da..688893bb856 100644 --- a/mysql-test/suite/federated/federatedx.test +++ b/mysql-test/suite/federated/federatedx.test @@ -1999,4 +1999,12 @@ connection slave; SET @@GLOBAL.CONCURRENT_INSERT= @OLD_SLAVE_CONCURRENT_INSERT; connection default; + +# +# MDEV-388 Creating a federated table with a non-existing server returns a random error code +# +--error 1 +CREATE TABLE t1 (a INT) ENGINE=FEDERATED CONNECTION='non_existing'; +SHOW WARNINGS; + source include/federated_cleanup.inc; |