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

With the change for DERBY-353 IDENTITY_VAL_LOCAL documentation needs to be changed to reflect the value inserted by the user for GENERATED BY DEFAULT

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

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.2.1.6
    • 10.6.1.0
    • Documentation
    • None
    • Newcomer

    Description

      The documentation for IDENTITY_VAL_LOCAL at http://db.apache.org/derby/docs/dev/ref/rrefidentityvallocal.html

      says:
      The INSERT statement must contain a VALUES clause on a table containing an identity column.
      The assigned value is an identity value generated by Derby.

      but after the fix for DERBY-353 fix the value is the last value inserted into an identity column whether it it was generated by Derby or specified by the user in the case of GENERATED BY DEFAULT

      Perhaps we could just remove the sentence:
      The assigned value is an identity value generated by Derby.

      Attachments

        Activity

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

          People

            bryanpendleton Bryan Pendleton
            kmarsden Katherine Marsden
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Issue deployment