[
https://issues.apache.org/jira/browse/FLINK-19140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17190645#comment-17190645
]
Timo Walther commented on FLINK-19140:
--------------------------------------
btw the `AS t(tag)` is optional starting 1.12 due to the new FLIP-65 functions
> Join with Table Function (UDTF) SQL example is incorrect
> --------------------------------------------------------
>
> Key: FLINK-19140
> URL: https://issues.apache.org/jira/browse/FLINK-19140
> Project: Flink
> Issue Type: Bug
> Components: Documentation, Table SQL / API
> Reporter: Benchao Li
> Priority: Major
>
> Section "*Join with Table Function (UDTF)*" of
> [https://ci.apache.org/projects/flink/flink-docs-master/dev/table/sql/queries.html]
> currently is:
> {code:SQL}
> 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
> {code}
>
> however, it should be:
> {code:SQL}
> 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
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
