Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1200

Handle null equality join condition as IS NOT DISTINCT FROM in RelOptUtil.splitJoinCondition

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.8.0
    • core
    • None

    Description

      Currently RelOptUtil.splitJoinCondition can't recognize a join condition as equi-join condition if it is given as (t1.key = t2.key OR (t1.key IS NULL AND t2.key IS NULL)) which is basically an expanded version of IS NOT DISTINCT FROM function.

      This JIRA is to track changes to RelOptUtil.splitJoinCondition to handle null equality join condition by converting them to IS NOT DISTINCT FROM function.

      Attachments

        Issue Links

          Dependent

          Improvement - An improvement or enhancement to an existing feature or task. DRILL-4539 Add support for Null Equality Joins

          • Major - Major loss of function.
          • Open
          links to

          Web Link PR

          Activity

            People

              julianhyde Julian Hyde
              vkorukanti Venki Korukanti
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: