| 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: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.13-rc/5.0.14-rc BK | OS: | Windows (Windows XP SP2/Linux) |
| Assigned to: | Eric Herman | CPU Architecture: | Any |
[27 Sep 2005 1:11]
MySQL Verification Team
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
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