Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 407F110D9A for ; Sun, 7 Dec 2014 22:59:13 +0000 (UTC) Received: (qmail 61842 invoked by uid 500); 7 Dec 2014 22:59:13 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 61762 invoked by uid 500); 7 Dec 2014 22:59:13 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 61613 invoked by uid 99); 7 Dec 2014 22:59:12 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 07 Dec 2014 22:59:12 +0000 Date: Sun, 7 Dec 2014 22:59:12 +0000 (UTC) From: "ASF subversion and git services (JIRA)" To: derby-dev@db.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (DERBY-6753) Docs for IDENTITY_VAL_LOCAL needs to be updated to indicate that the return value will be impacted by single row UPDATE of identity column MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DERBY-6753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14237308#comment-14237308 ] ASF subversion and git services commented on DERBY-6753: -------------------------------------------------------- Commit 1643722 from [~myrna] in branch 'docs/trunk' [ https://svn.apache.org/r1643722 ] DERBY-6753; Docs for IDENTITY_VAL_LOCAL needs to be updated to indicate that the return value will be impacted by single row UPDATE of identity column adding information about single row update statements. > Docs for IDENTITY_VAL_LOCAL needs to be updated to indicate that the return value will be impacted by single row UPDATE of identity column > ------------------------------------------------------------------------------------------------------------------------------------------ > > Key: DERBY-6753 > URL: https://issues.apache.org/jira/browse/DERBY-6753 > Project: Derby > Issue Type: Task > Components: Documentation > Affects Versions: 10.12.0.0 > Environment: Changes for DERBY-6742 will now make the newly generated value for a single row UPDATE statement available through IDENTITY_VAL_LOCAL(). Current documentation mentions only INSERT statement changing the value of IDENTITY_VAL_LOCAL(). The changes in the doc are very localized and from my search, the changes need to go only in the reference manual. > Basically, DERBY-6414 now allows an identity column's value to be updated using DEFAULT clause in UPDATE statement(prior to DERBY-6414, there was no way of updating an identity column). This updated value is available through IDENTITY_VAL_LOCAL if only one row was updated of a table with identity column AND identity column was updated as part of that UPDATE with DEFAULT clause. The rules for UPDATE are same as for INSERT for IDENTITY_VAL_LOCAL. The rules for INSERT are already documented in the reference manual. > Reporter: Mamta A. Satoor > Assignee: Myrna van Lunteren > Attachments: DERBY-6753.diff, DERBY-6753.diff_2, crefjavstateautogen.html, crefjavstateautogen.html, rrefidentityvallocal.html, rrefidentityvallocal.html > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)