Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.5.8
-
None
-
Linux, n.a.
Description
FederatedX (MariaDB) does not rise the underlying error in usable way:
CREATE TABLE `test_fed` ( |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT, |
`data` varchar(128) DEFAULT NULL, |
`ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
PRIMARY KEY (`id`) |
) ENGINE="FEDERATED" DEFAULT CHARSET=latin1 |
CONNECTION='mysql-57' |
;
|
ERROR 1434 (HY000): Can't create federated table. Foreign data src error: database: 'test' username: 'app' hostname: '127.0.0.1' |
 |
SQL> show warnings;
|
+---------+------+-----------------------------------------------------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+-----------------------------------------------------------------------------------------------------------------+
|
| Error | 1434 | Can't create federated table. Foreign data src error: database: 'test' username: 'app' hostname: '127.0.0.1' | |
| Warning | 1030 | Got error 1 "Operation not permitted" from storage engine FEDERATED | |
+---------+------+-----------------------------------------------------------------------------------------------------------------+ |
The reason for the error was just that the table did not exist on the remote system. It took me some time to find that out.
Either display a proper error message or write the error in the MariaDB error log.