Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.6.1.0
    • Fix Version/s: 10.6.1.0
    • Component/s: SQL
    • Labels:
      None

      Description

      The SQL standard defines two ways to specify the join condition in an INNER JOIN or a (LEFT/RIGHT/FULL) OUTER JOIN: with an ON clause or with a USING clause. Derby currently only accepts joins with an ON clause. Internally, Derby has code that supports USING. This code should be enabled to ease the migration to Derby. We must also verify that the implementation adheres to the standard before we enable it.

      Since USING is already a reserved keyword in Derby's parser, enabling the USING syntax should not cause any compatibility issues for existing queries.

      1. using.diff
        1.0 kB
        Knut Anders Hatlen
      2. using_v2.diff
        18 kB
        Knut Anders Hatlen
      3. using_v2.stat
        0.5 kB
        Knut Anders Hatlen

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 12475119 ] Default workflow, editable Closed status [ 12798379 ]
          Knut Anders Hatlen made changes -
          Link This issue is related to DERBY-4410 [ DERBY-4410 ]
          Knut Anders Hatlen made changes -
          Link This issue is related to DERBY-4407 [ DERBY-4407 ]
          Knut Anders Hatlen made changes -
          Link This issue is blocked by DERBY-4401 [ DERBY-4401 ]
          Knut Anders Hatlen made changes -
          Status In Progress [ 3 ] Closed [ 6 ]
          Issue & fix info [Patch Available]
          Fix Version/s 10.6.0.0 [ 12313727 ]
          Resolution Fixed [ 1 ]
          Knut Anders Hatlen made changes -
          Issue & fix info [Patch Available]
          Knut Anders Hatlen made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Knut Anders Hatlen made changes -
          Assignee Knut Anders Hatlen [ knutanders ]
          Knut Anders Hatlen made changes -
          Attachment using_v2.diff [ 12419513 ]
          Attachment using_v2.stat [ 12419514 ]
          Knut Anders Hatlen made changes -
          Field Original Value New Value
          Attachment using.diff [ 12418800 ]
          Knut Anders Hatlen created issue -

            People

            • Assignee:
              Knut Anders Hatlen
              Reporter:
              Knut Anders Hatlen
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development