You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Mamta A. Satoor (JIRA)" <de...@db.apache.org> on 2005/05/14 15:34:06 UTC
[jira] Created: (DERBY-287) Return value of IDENTITY_VAL_LOCAL for different connections is not related.
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
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
[jira] Commented: (DERBY-287) Return value of IDENTITY_VAL_LOCAL for different connections is not related.
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-287?page=comments#action_12312701 ]
Jean T. Anderson commented on DERBY-287:
----------------------------------------
Satheesh Bandaram <sa...@Sourcery.Org> agrees the patch looks good and it's ok to commit the patch;
see http://mail-archives.apache.org/mod_mbox/db-derby-dev/200506.mbox/%3c42A33745.60307@Sourcery.Org%3e
> 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
> Components: Documentation
> Versions: 10.1.0.0
> Reporter: Mamta A. Satoor
> Fix For: 10.1.0.0
> 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
[jira] Closed: (DERBY-287) Return value of IDENTITY_VAL_LOCAL for different connections is not related.
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-287?page=all ]
Jean T. Anderson closed DERBY-287:
----------------------------------
Resolution: Fixed
Committed Jeff's patch, revision 189838, that clarifies IDENTITY_VAL_LOCAL. Files changed:
M src/ref/rrefidentityvallocal.dita
> 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
> Components: Documentation
> Versions: 10.1.0.0
> Reporter: Mamta A. Satoor
> Assignee: Jean T. Anderson
> Fix For: 10.1.0.0
> 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
[jira] Closed: (DERBY-287) Return value of IDENTITY_VAL_LOCAL for different connections is not related.
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-287?page=all ]
Jean T. Anderson closed DERBY-287:
----------------------------------
Resolution: Fixed
Committed, revision 180159, Jeff Levitt's patch that clarifies IDENTITY_VAL_LOCAL documentation.
> 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
> Components: Documentation
> Versions: 10.1.0.0
> Reporter: Mamta A. Satoor
> Fix For: 10.1.0.0
> 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
[jira] Updated: (DERBY-287) Return value of IDENTITY_VAL_LOCAL for different connections is not related.
Posted by "Jeff Levitt (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-287?page=all ]
Jeff Levitt updated DERBY-287:
------------------------------
Attachment: derby287.zip
Here's a patch, once again zipped with html output for review. I pretty much changed the two lines as suggested and added the line also suggested. I did fix one of the sentences because it seemed to flow better written a different way, and I did not include the example provided in this issue. There was already an example in the topic. If anyone would still like the example in this issue included in the documentation, please let me know, I'd be happy to create another patch if that's the case.
> 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
[jira] Updated: (DERBY-287) Return value of IDENTITY_VAL_LOCAL for different connections is not related.
Posted by "Samuel Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-287?page=all ]
Samuel Andrew McIntyre updated DERBY-287:
-----------------------------------------
Component: Documentation
Fix Version: 10.1.0.0
Description:
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."
was:
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."
Version: 10.1.0.0
Environment:
> 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
> Components: Documentation
> Versions: 10.1.0.0
> Reporter: Mamta A. Satoor
> Fix For: 10.1.0.0
> 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
[jira] Commented: (DERBY-287) Return value of IDENTITY_VAL_LOCAL for different connections is not related.
Posted by "Jeremy Boynes (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-287?page=comments#action_65395 ]
Jeremy Boynes commented on DERBY-287:
-------------------------------------
Please can you also include the clarification for triggers.
> 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
>
> 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
[jira] Commented: (DERBY-287) Return value of IDENTITY_VAL_LOCAL for different connections is not related.
Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-287?page=comments#action_65418 ]
Mamta A. Satoor commented on DERBY-287:
---------------------------------------
While we are working on fixing IDENTITY_VAL_LOCAL documentation, let's add the relevant information for triggers as well. Here is the info about it but can someone please re-word this properly for documentation?
If a table with an identity column has an insert trigger defined which inserts into another table with identity column, then IDENTITY_VAL_LOCAL() function will return the generated value for the statement table and not for the table modified by the trigger.
eg
$ java -Dij.exceptionTrace=true org.apache.derby.tools.ij
ij version 10.1
ij> connect 'jdbc:derby:c:/dellater/db1';
ij> create table t1 (c11 int generated always as identity (start with 101, increment by 3), c12 int);
0 rows inserted/updated/deleted
ij> create table t2 (c21 int generated always as identity (start with 201, increment by 5), c22 int);
0 rows inserted/updated/deleted
ij> create trigger t1tr1 after insert on t1 for each row mode db2sql insert into t2 (c22) values (1);
0 rows inserted/updated/deleted
ij> values IDENTITY_VAL_LOCAL();
1
-------------------------------
NULL
1 row selected
ij> insert into t1 (c12) values (1);
1 row inserted/updated/deleted
ij> values IDENTITY_VAL_LOCAL();
1
-------------------------------
101
1 row selected
ij> select * from t1;
C11 |C12
-----------------------
101 |1
1 row selected
ij> select * from t2;
C21 |C22
-----------------------
201 |1
1 row selected
ij>
> 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
>
> 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
[jira] Commented: (DERBY-287) Return value of IDENTITY_VAL_LOCAL for different connections is not related.
Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
[ 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
[jira] Updated: (DERBY-287) Return value of IDENTITY_VAL_LOCAL for different connections is not related.
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-287?page=all ]
Jean T. Anderson updated DERBY-287:
-----------------------------------
Comment: was deleted
> 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
> Components: Documentation
> Versions: 10.1.0.0
> Reporter: Mamta A. Satoor
> Assignee: Jean T. Anderson
> Fix For: 10.1.0.0
> 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
[jira] Reopened: (DERBY-287) Return value of IDENTITY_VAL_LOCAL for different connections is not related.
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-287?page=all ]
Jean T. Anderson reopened DERBY-287:
------------------------------------
Assign To: Jean T. Anderson
> 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
> Components: Documentation
> Versions: 10.1.0.0
> Reporter: Mamta A. Satoor
> Assignee: Jean T. Anderson
> Fix For: 10.1.0.0
> 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