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

Allow standards-compliant column ordering for NATURAL JOIN and JOIN USING when dynamic tables are used

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      In CALCITE-2227 was allowed standards-compliant column ordering for NATURAL JOIN and JOIN USING for non-dynamic tables. In CALCITE-2392 was prevented permutation of columns for dynamic tables to avoid IOBE.

      The aim of this Jira is to implement standards-compliant column ordering for NATURAL JOIN and JOIN USING for dynamic tables.

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-2227 "SELECT *" in a NATURAL JOIN and JOIN USING query should output join columns only once

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-2392 Query with JOIN and USING on dynamic table fails with IndexOutOfBoundsException

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              volodymyr Vova Vysotskyi
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: