Benoît Paris created FLINK-14173: ------------------------------------ Summary: 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 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)