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

[Shang Yuanchun (Jira)]

Benchao Li created FLINK-19140:
----------------------------------

             Summary: 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


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)