[MDEV-11144] create federated table command error Created: 2016-10-26  Updated: 2016-12-01  Resolved: 2016-12-01

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Federated
Affects Version/s: 10.0.20
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: jisun bae Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: need_feedback
Environment:

Red Hat Enterprise Linux Server release 6.7 (Santiago) / MariaDB 10.0.20


 Description   

I create some federated tables like below command.

CREATE SERVER 'remote' FOREIGN DATA WRAPPER 'mysql' OPTIONS
 
(HOST 'IP address',
 
 DATABASE 'dbname',
 
 USER 'root',
 
 PASSWORD 'password',
 
 PORT 3306,
 
 SOCKET '',
 
 OWNER 'root');
 
 
CREATE TABLE "table_name" (
 
....
 
) ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='remote';

Already I created 266 tables, I want to create some more tables.
But I got a error message.

##############################################
 
Lookup Error - MySQL Database Error: Can't create federated table. Foreign data src error:  database: 'dbname'  username: 'root'  hostname: 'ip address'
 
##############################################

Already created tables are useable but the new create table command is error.
What's wrong?

 Comments   
Comment by Elena Stepanova [ 2016-11-02 ]

Since you don't specify a remote table name in your connection string CONNECTION='remote', it assumes that the remote table has the same name as the local FEDERATED table you are trying to create.
The most probably reason of the error you are getting is that there is no corresponding remote table for the local table name you are using in your CREATE statement.

Comment by Elena Stepanova [ 2016-12-01 ]

Closing as "not a bug" based on the assumptions above. If you disagree and have more information, please comment to re-open.

Generated at Thu Feb 08 07:47:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.