MySQL Bugs: #34971: Creating a FEDERATED Table Using CREATE SERVER

Bug #34971	Creating a FEDERATED Table Using CREATE SERVER
Submitted:	1 Mar 2008 17:17	Modified:	5 Dec 2008 14:04
Reporter:	[ name withheld ] (Basic Quality Contributor)	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	5.1.23-rc-community	OS:	Windows
Assigned to:	Sergei Glukhov	CPU Architecture:	Any
Tags:	create server, federated, qc

Description:
I'm trying to create a federated table using create server statement as per the manual on mysql 5.1.23 rc community edition but this statement fails:

CREATE SERVER remote_link
FOREIGN DATA WRAPPER mysql
OPTIONS (USER 'root', HOST '127.0.0.1', PORT 3306, DATABASE 'remote_test');

complaining about a non existent mysql.SERVERS table, which really is not there.

How to repeat:
Use statements provided above.

Thank you for a problem report. What exact binaries you had installed (send URL)? Did you have any older 5.1.x version before or it was clean installation?

Hi, it was a clean install, I'm using 5.1.23-rc-community for windows downloaded from mysql.com (the installer package, not the .zip version)

Thank you for the bug report.

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.23-rc-community MySQL Community Server (GPL)

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

mysql> use test
Database changed
mysql> CREATE SERVER remote_link
    -> FOREIGN DATA WRAPPER mysql
    -> OPTIONS (USER 'root', HOST '127.0.0.1', PORT 3306, DATABASE 'remote_test'
);
ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
mysql>

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.24-rc-nt-log Source distribution

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

mysql> CREATE SERVER remote_link
    -> FOREIGN DATA WRAPPER mysql
    -> OPTIONS (USER 'root', HOST '127.0.0.1', PORT 3306, DATABASE 'remote_test');
Query OK, 1 row affected (0.03 sec)

mysql>

Workaround: se mysql_system_tables_fix.sql to create the table

The bug is not repeatable on latest tree:

mysql> CREATE SERVER s
    -> FOREIGN DATA WRAPPER mysql
    -> OPTIONS (USER 'Remote', HOST '192.168.1.106', DATABASE 'test');
Query OK, 1 row affected (0.00 sec)

mysql> select version()
    -> ;
+------------------+
| version()        |
+------------------+
| 5.1.30-community |
+------------------+
1 row in set (0.00 sec)

mysql>