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

RelBuilder.join incorrectly rewrites correlated conditions

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • core
    • None

    Description

      When are correlated join is rewritten to correlate + filters, if the conditions contains a subquery with correlate variable from the right side, the result rewrite is incorrect. The correlated variable while be indexed from the context of the join, however in the case of right side, this should be shifted by the size of the left index.

      Attachments

        Issue Links

          blocks

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-4686 SubQueryRemoveRule.matchJoin should correctly rewrite all sub-queries

          • Major - Major loss of function.
          • In Progress

          Activity

            People

              jamesstarr James Starr
              jamesstarr James Starr
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: