Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4401

Document USING clause in joins

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.6.1.0
    • 10.6.1.0
    • Documentation
    • None

    Description

      DERBY-4370 made some of the join operations accept a USING clause. This should be documented in the reference manual.

      The JOIN operations section talks about "join clause", which should be fine since that could mean both ON clause and USING clause.

      The sections INNER JOIN operation, LEFT OUTER JOIN operation and RIGHT OUTER JOIN operation need to be updated with the new syntax. We need to replace

      {
      ON booleanExpression
      }

      with

      {

      { ON booleanExpression }

      |

      { USING ( Simple-column-Name [ , Simple-column-Name ]* ) }

      }

      Perhaps it would make sense to factor out this part of the syntax into a separate element JoinSpecification, and explain the meaning of USING there.

      Attachments

        1. inner_syntax.diff
          1 kB
          Knut Anders Hatlen
        2. using.diff
          8 kB
          Knut Anders Hatlen
        3. using.zip
          9 kB
          Knut Anders Hatlen

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            knutanders Knut Anders Hatlen
            knutanders Knut Anders Hatlen
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Issue deployment