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

Global Oracle/Axion style sequence generator

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:
      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

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: