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)