Bug #31856 Misleading documentation on DDL and federated tables

• Submitted: 25 Oct 2007 16:48
• Modified: 15 Nov 2007 7:32
• Reporter: Peter Brawley (Basic Quality Contributor)
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.0,5.1
• OS: Any
• Assigned to: MC Brown
• CPU Architecture: Any

[25 Oct 2007 16:48] Peter Brawley

Description:
The usage notes page for the federated engine (eg http://dev.mysql.com/doc/refman/5.1/en/federated-usagenotes.html) says:

"It does not support ALTER TABLE, or any Data Definition Language statements other than DROP TABLE."

On the usual convention (observed by IBM, for example, at http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sql...), CREATE TRIGGER is DDL. Fed tables support triggers, so the quoted statement is misleading.

How to repeat:
As above

[15 Nov 2007 7:32] MC Brown

The notes on DDL statements for FEDERATED tables have been updated. The wording has been changing to make it clear that we are referring to DDL statements that directly affect the table structure.