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

    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

        1. rrefidentityvallocal.html
          6 kB
          Bryan Pendleton
        2. docs.diff
          0.9 kB
          Bryan Pendleton

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: