From 20c3b2ff807b07610ed9012f31fce0ba68d522b0 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Sun, 16 Nov 2014 13:15:35 +0100 Subject: 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") --- mysql-test/r/servers.result | 19 ++++++++++++++++++- 1 file changed, 18 insertions(+), 1 deletion(-) (limited to 'mysql-test/r/servers.result') 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; -- cgit v1.2.1