Bug #6585 Documentation ambiguity on unqualified JOIN

Submitted: 12 Nov 2004 6:27 Modified: 29 Nov 2004 15:23
Reporter: David POwell Email Updates:
Status: Not a Bug Impact on me:
None 
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.