[ http://issues.apache.org/jira/browse/DERBY-103?page=all ]
Mike Matrigali updated DERBY-103:
---------------------------------
Component: SQL
Description:
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;
was:
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;
Environment:
> Global Oracle/Axion style sequence generator
> --------------------------------------------
>
> Key: DERBY-103
> URL: http://issues.apache.org/jira/browse/DERBY-103
> Project: Derby
> Type: Wish
> Components: SQL
> 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;
--
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
