[FLINK-24115] Outdated SQL Temporal Join Example

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.14.0, 1.13.3, 1.15.0
• Component/s: Documentation, Table SQL / API
• Labels: pull-request-available
• Assignee: Leonard Xu
• Reporter: Nico Kruber
• Created: 01/Sep/21 15:14
• Updated: 08/Sep/21 02:44
• Resolved: 08/Sep/21 02:44

Description

https://ci.apache.org/projects/flink/flink-docs-release-1.13/docs/dev/table/sql/queries/joins/#event-time-temporal-join is missing a primary key in the Table DDL.

Also, the following note does not map the current example anymore:

Note: The event-time temporal join requires the primary key contained in the equivalence condition of the temporal join condition, e.g., The primary key P.product_id of table product_changelog to be constrained in the condition O.product_id = P.product_id.

 

Issue Links

• links to: GitHub Pull Request #17121
• links to: GitHub Pull Request #17122
• links to: GitHub Pull Request #17124