1set sql_mode=""; 2# 3# MDEV-4594 - CREATE SERVER crashes embedded 4# 5CREATE SERVER s1 FOREIGN DATA WRAPPER mysql OPTIONS(HOST 'localhost'); 6SELECT * FROM mysql.servers; 7Server_name Host Db Username Password Port Socket Wrapper Owner 8s1 localhost 3306 mysql 9DROP SERVER s1; 10CREATE SERVER s1 FOREIGN DATA WRAPPER foo OPTIONS(USER 'bar'); 11SELECT * FROM mysql.servers; 12Server_name Host Db Username Password Port Socket Wrapper Owner 13s1 bar 0 foo 14DROP SERVER s1; 15CREATE SERVER s1 FOREIGN DATA WRAPPER mysql OPTIONS(USER 'bar'); 16ERROR HY000: Can't create federated table. Foreign data src error: either HOST or SOCKET must be set 17CREATE SERVER s1 FOREIGN DATA WRAPPER mysql OPTIONS(HOST 'bar'); 18SELECT * FROM mysql.servers; 19Server_name Host Db Username Password Port Socket Wrapper Owner 20s1 bar 3306 mysql 21DROP SERVER s1; 22CREATE SERVER s1 FOREIGN DATA WRAPPER mysql OPTIONS(SOCKET 'bar'); 23SELECT * FROM mysql.servers; 24Server_name Host Db Username Password Port Socket Wrapper Owner 25s1 3306 bar mysql 26DROP SERVER s1; 27