db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-287) Return value of IDENTITY_VAL_LOCAL for different connections is not related.
Date Sun, 15 May 2005 06:37:05 GMT
     [ http://issues.apache.org/jira/browse/DERBY-287?page=comments#action_65429 ]
     
Mamta A. Satoor commented on DERBY-287:
---------------------------------------

The change looks good to me. It will be nice to have feedback from others in case more changes
should be made.

> Return value of IDENTITY_VAL_LOCAL for different connections is not related.
> ----------------------------------------------------------------------------
>
>          Key: DERBY-287
>          URL: http://issues.apache.org/jira/browse/DERBY-287
>      Project: Derby
>         Type: Bug
>     Reporter: Mamta A. Satoor
>  Attachments: derby287.zip
>
> The current IDENTITY_VAL_LOCAL documentation (http://incubator.apache.org/derby/docs/ref/ref-single.html#rrefidentityvallocal)
is unclear if the IDENTITY_VAL_LOCAL function returns the most recently assigned value for
an identity column, for a connection/transaction/database and it needs to be fixed to say
that it is for a connection.
> The first line in the current doc is "The IDENTITY_VAL_LOCAL function is a non-deterministic
function that returns the most recently assigned value for an identity column, where the assignment
occurred as a result of a single row INSERT statement using a VALUES clause. " It should read
as "The IDENTITY_VAL_LOCAL function is a non-deterministic function that, for a connection,
returns the most recently assigned value for an identity column, where the assignment occurred
as a result of a single row INSERT statement using a VALUES clause."
> There is another line on the same page which reads "The value returned by the IDENTITY_VAL_LOCAL
function is the value assigned to the identity column of the table identified in the most
recent single row INSERT statement."  This needs to be slightly modified to say "The value
returned by the IDENTITY_VAL_LOCAL function, for a connection, is the value assigned to the
identity column of the table identified in the most recent single row INSERT statement."

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message