db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (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
Date Thu, 04 Dec 2014 00:35:13 GMT

     [ https://issues.apache.org/jira/browse/DERBY-6753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Myrna van Lunteren reassigned DERBY-6753:
-----------------------------------------

    Assignee: Myrna van Lunteren

> 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, crefjavstateautogen.html, rrefidentityvallocal.html
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message