Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-103

Global Oracle/Axion style sequence generator

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • None
    • None
    • SQL
    • None

    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;

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            suranjay Suran Jayathilaka
            bruehlicke Bernd Ruehlicke
            Votes:
            18 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment