Support for sequences
---------------------
Key: DERBY-712
URL: http://issues.apache.org/jira/browse/DERBY-712
Project: Derby
Type: New Feature
Environment: feature request
Reporter: Tony Dahbura
Would like to see support added for sequences. This would permit a select
against the sequence to always obtain a ever increasing/decreasing value. The
identity column works fine but there are times for applications where the
application needs to obtain the sequence number and use it prior to the
database write. Subsequent calls to the table/column would result in a new
number on each call.
SQL such as the following:
SELECT NEXT VALUE FOR sequence_name FROM sometable ; would result in a next
value.
--
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
