could you add details on what you would expect from such a feature. The usual problem with such a feature is what do you want the system to do with the number generator and transactions. Does it allow holes by committing the generation of a sequence number separate from the transaction which allocated the number or does it lock out other transactions until a transaction allocating the number commits.
Bernd Ruehlicke (JIRA) wrote: > Global Oracle/Axion style sequence generator > -------------------------------------------- > > Key: DERBY-103 > URL: http://nagoya.apache.org/jira/browse/DERBY-103 > Project: Derby > Type: Wish > Reporter: Bernd Ruehlicke > > > The identity column generator is just not enought. It would just be wonderful > if Derby had commands like > > CREATE SEQUENCE mySeq; > > values mySeq.nextval; > values mySeq.currval; > > CREATE TABLE my_table ( > id integer default mySeq.nextval, > value varchar(40) > ) > > DROP SEQUENCE mySeq; > > > >
