MySQL Bugs: #11695: Using Foreign Keys shows foreign key syntax that parser silently ignores

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

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.

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.