Bug #11695 Using Foreign Keys shows foreign key syntax that parser silently ignores
Submitted: 1 Jul 2005 22:36 Modified: 11 Jul 2005 4:04
Reporter: Dean Ellis Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:
Assigned to: Jon Stephens CPU Architecture:Any

[1 Jul 2005 22:36] Dean Ellis
Description:
Chapter "Using Foreign Keys" contains an example which uses foreign key syntax that the parser silently ignores, which is confusing if one supposes that the example (if one were using InnoDB) would actually create the foreign key.

How to repeat:
http://dev.mysql.com/doc/mysql/en/example-foreign-keys.html

Suggested fix:
Use valid syntax (which InnoDB will accept) in the example, or clarify that this example is (for whatever reason) demonstrating syntax that does not actually do anything and which will be ignored.
[11 Jul 2005 4:04] Jon Stephens
Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).

Additional info:

Rewrote indicated section of Manual to address issues brought up by the submitter. Made it clear that the syntax does not create a key (foreign or otherwise), that no checks are performed, and that attempting to use it for an InnoDB table results in an error. Closed.