Bug #25722 Federated: change definitions that CREATE SERVER uses

• Submitted: 19 Jan 2007 17:59
• Modified: 19 Jan 2007 18:20
• Reporter: Peter Gulutzan
• Status: Verified
• Category: MySQL Server: Federated storage engine
• Severity: S4 (Feature request)
• Version: 5.1.15-beta-debug
• OS: Linux (SUSE 10.0 / 64-bit)
• CPU Architecture: Any

[19 Jan 2007 17:59] Peter Gulutzan

Description:
CREATE SERVER uses a table named mysql.servers.

Some column definitions in mysql.servers aren't the same as
the definitions in mysql.user or mysql.db for columns that I
thought are in the same domain. For example:

In mysql.servers:
`Host` char(64)
In mysql.user:
`Host` char(60) COLLATE utf8_bin

In mysql.servers:
`Db` char(64)
In mysql.db:
`Db` char(64) COLLATE utf8_bin

In mysql.servers:
`Username` char(64)
In mysql.user:
`User` char(16) COLLATE utf8_bin

In mysql.servers:
`Password` char(64)
In mysql.user:
`Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin

It's interesting as well that 'servers' is a plural name, while other
mysql-database tables have singular names, e.g. 'host', 'event', 'func'.

The feature request is to use similar definitions for similar things.

How to repeat:
Look at the metadata of mysql.servers and mysql.user and mysql.db
with SHOW CREATE TABLE or SELECT ... FROM INFORMATION_SCHEMA.COLUMNS ...

[19 Jan 2007 18:20] MySQL Verification Team

Thank you for the bug report. Verified as described:

mysql> show columns from mysql.servers like 'host';
+-------+----------+------+-----+---------+-------+
| Field | Type     | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| Host  | char(64) | NO   |     |         |       | 
+-------+----------+------+-----+---------+-------+
1 row in set (0.02 sec)

mysql> show columns from mysql.user like 'host';
+-------+----------+------+-----+---------+-------+
| Field | Type     | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| Host  | char(60) | NO   | PRI |         |       | 
+-------+----------+------+-----+---------+-------+
1 row in set (0.00 sec)