Description:
testcase outputs:
mysql> create server s foreign data wrapper mysql options (user 'root',port 7777, host 'this.is.a.valid.domain.name.that.is.long.com',database 'db');
Query OK, 1 row affected (0.00 sec)
mysql> drop table if exists t;
Query OK, 0 rows affected (0.00 sec)
mysql> create table t (a int) engine=federated connection='s';
Query OK, 0 rows affected (0.00 sec)
mysql> select * from t;
ERROR 1429 (HY000): Unable to connect to foreign data source: Unknown MySQL server host 'this.is.a.valid.domain.name.that.is.l
mysql>
How to repeat:
start server with --federated=1
--------------------------------
drop server if exists s;
create server s foreign data wrapper mysql options (user 'root',port 7777, host 'this.is.a.valid.domain.name.that.is.long.com',database 'db');
drop table if exists t;
create table t (a int) engine=federated connection='s';
select * from t;