[ https://issues.apache.org/jira/browse/FLINK-14173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17328265#comment-17328265 ]
Flink Jira Bot commented on FLINK-14173: ---------------------------------------- This major issue is unassigned and itself and all of its Sub-Tasks have not been updated for 30 days. So, it has been labeled "stale-major". If this ticket is indeed "major", please either assign yourself or give an update. Afterwards, please remove the label. In 7 days the issue will be deprioritized. > ANSI-style JOIN with Temporal Table Function fails > -------------------------------------------------- > > Key: FLINK-14173 > URL: https://issues.apache.org/jira/browse/FLINK-14173 > Project: Flink > Issue Type: Bug > Components: Table SQL / Legacy Planner, Table SQL / Planner > Affects Versions: 1.9.0 > Environment: Java 1.8, Scala 2.11, Flink 1.9 (pom.xml file attached) > Reporter: Benoît Paris > Priority: Major > Labels: stale-major > Attachments: flink-test-temporal-tables-1.9.zip > > > The planner fails to generate a plan for ANSI-style joins with Temporal Table > Functions. The Blink planners throws with a "Missing conversion is > LogicalTableFunctionScan[convention: NONE -> LOGICAL]" message (and some very > fancy graphviz stuff). The old planner does a "This exception indicates that > the query uses an unsupported SQL feature." > This fails: > {code:java} > SELECT > o_amount * r_amount AS amount > FROM Orders > JOIN LATERAL TABLE (Rates(o_proctime)) > ON r_currency = o_currency {code} > This works: > {code:java} > SELECT > o_amount * r_amount AS amount > FROM Orders > , LATERAL TABLE (Rates(o_proctime)) > WHERE r_currency = o_currency{code} > Reproduction with the attached Java and pom.xml files. Also included: stack > traces for both Blink and the old planner. > I think this is a regression. I remember using ANSI-style joins with a > temporal table function successfully in 1.8. -- This message was sent by Atlassian Jira (v8.3.4#803005)