[jira] [Created] (FLINK-5520) Disable outer joins with non-equality predicates

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (FLINK-5520) Disable outer joins with non-equality predicates

Shang Yuanchun (Jira)
Fabian Hueske created FLINK-5520:
------------------------------------

             Summary: Disable outer joins with non-equality predicates
                 Key: FLINK-5520
                 URL: https://issues.apache.org/jira/browse/FLINK-5520
             Project: Flink
          Issue Type: Bug
          Components: Table API & SQL
    Affects Versions: 1.2.0
            Reporter: Fabian Hueske
            Priority: Blocker
             Fix For: 1.2.0


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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)