diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2014-11-16 13:15:35 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2014-12-04 10:41:51 +0100 |
| commit | 20c3b2ff807b07610ed9012f31fce0ba68d522b0 (patch) | |
| tree | 5133874c82e30bc8a7277589f2f62aceeb53ca45 /mysql-test/r/servers.result | |
| parent | 97a913e31c161dbd18f4fcb9cc00f23640497e03 (diff) | |
| download | mariadb-git-20c3b2ff807b07610ed9012f31fce0ba68d522b0.tar.gz | |
MDEV-6311 Add errors on CREATE SERVER
fail CREATE SERVER foreign data wrapper is "mysql"
and neither HOST nor SOCKET are specified.
Also default PORT to 3306 (again, only for foreign
data wrapper "mysql")
Diffstat (limited to 'mysql-test/r/servers.result')
| -rw-r--r-- | mysql-test/r/servers.result | 19 |
1 files changed, 18 insertions, 1 deletions
diff --git a/mysql-test/r/servers.result b/mysql-test/r/servers.result index c9d82c9cfcc..ab5e444b134 100644 --- a/mysql-test/r/servers.result +++ b/mysql-test/r/servers.result @@ -4,5 +4,22 @@ CREATE SERVER s1 FOREIGN DATA WRAPPER mysql OPTIONS(HOST 'localhost'); SELECT * FROM mysql.servers; Server_name Host Db Username Password Port Socket Wrapper Owner -s1 localhost 0 mysql +s1 localhost 3306 mysql +DROP SERVER s1; +CREATE SERVER s1 FOREIGN DATA WRAPPER foo OPTIONS(USER 'bar'); +SELECT * FROM mysql.servers; +Server_name Host Db Username Password Port Socket Wrapper Owner +s1 bar 0 foo +DROP SERVER s1; +CREATE SERVER s1 FOREIGN DATA WRAPPER mysql OPTIONS(USER 'bar'); +ERROR HY000: Can't create federated table. Foreign data src error: either HOST or SOCKET must be set +CREATE SERVER s1 FOREIGN DATA WRAPPER mysql OPTIONS(HOST 'bar'); +SELECT * FROM mysql.servers; +Server_name Host Db Username Password Port Socket Wrapper Owner +s1 bar 3306 mysql +DROP SERVER s1; +CREATE SERVER s1 FOREIGN DATA WRAPPER mysql OPTIONS(SOCKET 'bar'); +SELECT * FROM mysql.servers; +Server_name Host Db Username Password Port Socket Wrapper Owner +s1 3306 bar mysql DROP SERVER s1; |