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

Implement JOIN whose ON clause contains mixed equi and theta

          Details

          • Type: Bug
          • Status: Closed
          • Priority: Major
          • Resolution: Fixed
          • Affects Version/s: None
          • Fix Version/s: 0.9.0-incubating
          • Component/s: None
          • Labels:
            None

            Description

            Cannot implement a JOIN whose ON clause contains a mixture of equi and theta conditions. The equivalent query expressed using WHERE can be implemented.

            The solution is to make EnumerableJoinRule split the condition into equi and non-equi parts, provided that the join type is inner.

              Attachments

                Issue Links

                relates to

                Bug - A problem which impairs or prevents the functions of the product. CALCITE-451 Implement theta join, inner and outer, in enumerable convention

                • Major - Major loss of function.
                • Closed

                  Activity

                    People

                    • Assignee:
                      julianhyde Julian Hyde
                      Reporter:
                      julianhyde Julian Hyde
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      1 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: