Description:
I'm not able to create FEDERATED table - I got strange error.
./mysql test -u root -h quadxeon
mysql> create table t3 (id int);
Query OK, 0 rows affected (0.56 sec)
mysql> create table t3f (id int) engine = federated connection='mysql://root@quadxeon/test/t3';
ERROR 1434 (HY000): Can't create federated table. Foreign data src error: error: 1159 ''
SHOW ENGINES:
mysql> show engines;
+------------+----------+----------------------------------------------------------------+
| Engine | Support | Comment |
+------------+----------+----------------------------------------------------------------+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables |
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys |
| BerkeleyDB | NO | Supports transactions and page-level locking |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) |
| EXAMPLE | YES | Example storage engine |
| ARCHIVE | YES | Archive storage engine |
| CSV | YES | CSV storage engine |
| ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based tables |
| FEDERATED | YES | Federated MySQL storage engine |
| MRG_MYISAM | YES | Collection of identical MyISAM tables |
| ISAM | NO | Obsolete storage engine |
+------------+----------+----------------------------------------------------------------+
12 rows in set (0.00 sec)
How to repeat:
create table t3 (id int);
create table t3f (id int) engine = federated connection='mysql://root@quadxeon/test/t3';