MariaDB [test]> CREATE TABLE t1 (a INT) ENGINE=FEDERATED CONNECTION='non_existing';

ERROR 1 (HY000): Can't create/write to file 'server name: 'non_existing' doesn't exist!' (Errcode: 16)

MariaDB [test]> 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: 49043072)                         |

| Error | 1005 | Can't create table 'test.t1' (errno: 1)                                               |

+-------+------+---------------------------------------------------------------------------------------+

# If in MTR, run as 

# perl ./mtr --mysqld=--plugin-load=ha_federatedx.so --mysqld=--federated t1

# or 

# perl ./mtr --mysqld=--plugin-load=ha_federated.so --mysqld=--federated t1

# Outside MTR, just make sure FEDERATED[X] is installed and active.

--disable_abort_on_error

CREATE TABLE t1 (a INT) ENGINE=FEDERATED CONNECTION='non_existing';

SHOW WARNINGS;