Bug #13508 'Can't create federated table' on 5.0.13rc
Submitted: 26 Sep 2005 23:39 Modified: 29 Nov 2005 15:40
Reporter: Shuichi Tamagawa Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.13-rc/5.0.14-rc BK OS:Microsoft Windows (Windows XP SP2/Linux)
Assigned to: Eric Herman CPU Architecture:Any

[26 Sep 2005 23:39] Shuichi Tamagawa
Description:
Server returns 'Can't create federated table' error when you try to create federated table on 5.0.13-rc. The same create table syntax worked on 5.0.12-beta.

How to repeat:
/* I tested this on the local machine */

1. Create a table on the local 4.1.14 server using port 4114

mysql> select version();
+-------------------+
| version()         |
+-------------------+
| 4.1.14-nt-max-log |
+-------------------+
1 row in set (0.17 sec)

mysql> show variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 4114  |
+---------------+-------+
1 row in set (0.02 sec)

mysql> CREATE TABLE test_table (
    ->     id     int(20) NOT NULL auto_increment,
    ->     name   varchar(32) NOT NULL default '',
    ->     other  int(20) NOT NULL default '0',
    ->     PRIMARY KEY  (id),
    ->     KEY name (name),
    ->     KEY other_key (other)
    -> )
    -> ENGINE=MyISAM
    -> DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0.11 sec)

2. Create a federated table on the local 5.0.13 server using port 5013

mysql> select version();
+------------------+
| version()        |
+------------------+
| 5.0.13-rc-nt-max |
+------------------+
1 row in set (0.00 sec)

mysql> show variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 5013  |
+---------------+-------+
1 row in set (0.00 sec)

mysql> CREATE TABLE federated_table (
    ->     id     int(20) NOT NULL auto_increment,
    ->     name   varchar(32) NOT NULL default '',
    ->     other  int(20) NOT NULL default '0',
    ->     PRIMARY KEY  (id),
    ->     KEY name (name),
    ->     KEY other_key (other)
    -> )
    -> ENGINE=FEDERATED
    -> DEFAULT CHARSET=latin1
    -> COMMENT='mysql://root@localhost:4114/test/test_table';
ERROR 1432 (HY000): Can't create federated table. The data source connection string '' is not in the correct format

3. It works if you use the 5.0.12.

mysql> select version();
+--------------------+
| version()          |
+--------------------+
| 5.0.12-beta-nt-max |
+--------------------+
1 row in set (0.00 sec)

mysql> show variables like 'port%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 5012  |
+---------------+-------+
1 row in set (0.00 sec)

mysql> CREATE TABLE federated_table (
    ->     id     int(20) NOT NULL auto_increment,
    ->     name   varchar(32) NOT NULL default '',
    ->     other  int(20) NOT NULL default '0',
    ->     PRIMARY KEY  (id),
    ->     KEY name (name),
    ->     KEY other_key (other)
    -> )
    -> ENGINE=FEDERATED
    -> DEFAULT CHARSET=latin1
    -> COMMENT='mysql://root@localhost:4114/test/test_table';
Query OK, 0 rows affected (0.13 sec)

Suggested fix:
N/A
[27 Sep 2005 1:11] Miguel Solorzano
Happens also on Linux BK:

miguel@hegel:~/dbs/5.0> bin/mysql --defaults-file=/home/miguel/dbs/5.0/var/my.cnf -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.14-rc-debug-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select version();
+---------------------+
| version()           |
+---------------------+
| 5.0.14-rc-debug-log |
+---------------------+
1 row in set (0.02 sec)

mysql> show variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 5114  |
+---------------+-------+
1 row in set (0.01 sec)

mysql> CREATE TABLE federated_table (
    -> id     int(20) NOT NULL auto_increment,
    -> name   varchar(32) NOT NULL default '',
    -> other  int(20) NOT NULL default '0',
    -> PRIMARY KEY  (id),
    -> KEY name (name),
    -> KEY other_key (other)
    -> )
    -> ENGINE=FEDERATED
    -> DEFAULT CHARSET=latin1
    -> COMMENT='mysql://root@localhost:4114/test/test_table';
ERROR 1432 (HY000): Can't create federated table. The data source connection string '' is not in the correct format
[28 Sep 2005 5:32] Brian Aker
Eric, can you make sure this is documented?
[29 Nov 2005 15:40] Eric Herman
Now in the documentation: http://dev.mysql.com/doc/refman/5.0/en/federated-use.html