[#MDEV-388] Creating a federated table with a non-existing server returns a random error code

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)                                               |

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

There used to be bug http://bugs.mysql.com/bug.php?id=33702 which is now marked as fixed and closed (and contains a patch), but the fix was apparently lost along with MySQL 6.0. It is still reproducible on MySQL 5.5, 5.6.

# 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;

[MDEV-388] Creating a federated table with a non-existing server returns a random error code Created: 2012-07-10 Updated: 2013-05-21 Resolved: 2013-05-21
Status:	Closed
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	5.5.25, 5.3.7, 5.2.12, 5.1.62
Fix Version/s:	5.5.31

[MDEV-388] Creating a federated table with a non-existing server returns a random error code Created: 2012-07-10 Updated: 2013-05-21 Resolved: 2013-05-21