[FLINK-19140] Join with Table Function (UDTF) SQL example is incorrect

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.12.0, 1.11.3
• Component/s: Documentation, Table SQL / API
• Labels: pull-request-available
• Assignee: Benchao Li
• Reporter: Benchao Li
• Created: 04/Sep/20 09:25
• Updated: 23/Sep/20 04:24
• Resolved: 22/Sep/20 14:55

Description

Section "Join with Table Function (UDTF)" of https://ci.apache.org/projects/flink/flink-docs-master/dev/table/sql/queries.html currently is:

SELECT users, tag
FROM Orders, LATERAL TABLE(unnest_udtf(tags)) t AS tag
-- and 
SELECT users, tag
FROM Orders LEFT JOIN LATERAL TABLE(unnest_udtf(tags)) t AS tag ON TRUE

 
however, it should be:

SELECT users, tag
FROM Orders, LATERAL TABLE(unnest_udtf(tags)) AS t(tag)
-- and 
SELECT users, tag
FROM Orders LEFT JOIN LATERAL TABLE(unnest_udtf(tags)) AS t(tag) ON TRUE

Issue Links

• links to: GitHub Pull Request #13429