[FLINK-5520] Disable outer joins with non-equality predicates

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Done
• Affects Version/s: 1.2.0
• Fix Version/s: 1.2.0, 1.3.0
• Component/s: Table SQL / API
• Assignee: lincoln lee
• Reporter: Fabian Hueske
• Created: 17/Jan/17 07:56
• Updated: 20/Jan/17 07:55
• Resolved: 20/Jan/17 07:55

Description

Outer joins with non-equality predicates (and at least one equality predicate) compute incorrect results.

Since this is not a very common requirement, I propose to disable this feature for the 1.2.0 release and correctly implement it for a later version.

The fix should add checks in the Table API validation phase (to get a good error message) and in the DataSetJoinRule to prevent translation of SQL queries with non-equality predicates on outer joins.

Issue Links

• links to: GitHub Pull Request #3141