Bug #6585 Documentation ambiguity on unqualified JOIN

• Submitted: 12 Nov 2004 6:27
• Modified: 29 Nov 2004 15:23
• Reporter: David POwell
• Status: Not a Bug
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: current
• OS: N/A
• Assigned to: Paul DuBois
• CPU Architecture: Any

[12 Nov 2004 6:27] David POwell

Description:
Ref.: http://dev.mysql.com/doc/mysql/en/JOIN.html
Manual:14.1.7.1 JOIN Syntax

Minor ambiguity in the status of an unqualified "JOIN":

it's not permissible according to the syntax prototypes - there's always a qualifying adjective.  But the following text implies that it is accepted:

"Note that INNER JOIN syntax allows a join_condition only from MySQL 3.23.17 on. The same is true for JOIN and CROSS JOIN only as of MySQL 4.0.11. "

How to repeat:
Read.

Suggested fix:
Brackets around [INNER] in syntax prototype if that is appropriate.  Else alter comment quoted above.

[12 Nov 2004 16:36] Paul DuBois

It appears that INNER is already within square brackets
in the syntax prototype.  Please clarify the nature of the
ambiguity. Thanks.

[14 Nov 2004 6:22] David POwell

True; sorry.  I misread the [INNER|CROSS] expression as requiring one of the listed alternatives.  But in fact either is optional.  No error.