Bug #99166 MySQL manual does include LATERAL tables in syntax description for join

• Submitted: 3 Apr 2020 0:19
• Modified: 4 Apr 2020 11:58
• Reporter: Øystein Grøvlen
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 8.0
• OS: Any
• CPU Architecture: Any

[3 Apr 2020 0:19] Øystein Grøvlen

Description:
The syntax description for joins (table_references) does not show the syntax for LATERAL derived tables.

How to repeat:
See https://dev.mysql.com/doc/refman/8.0/en/join.html

Suggested fix:
Change the definition of table_factor to:

table_factor:
    tbl_name [PARTITION (partition_names)]
        [[AS] alias] [index_hint_list]
  | [LATERAL] table_subquery [AS] alias [(col_list)]
  | ( table_references )

[3 Apr 2020 0:21] Øystein Grøvlen

Sorry, a not is missing in the title.

[3 Apr 2020 6:57] MySQL Verification Team

Hello Øystein,

Thank you for the report and feedback.

regards,
Umesh

[4 Apr 2020 11:58] Paul DuBois

Posted by developer:
 
Fixed. Thanks for spotting this!