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

Support for sequences

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 10.6.1.0
    • SQL
    • None
    • feature request
    • Patch Available

    Description

      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.

      Attachments

        1. altertable.diff
          18 kB
          Suran Jayathilaka
        2. catalogs_a.patch
          57 kB
          Suran Jayathilaka
        3. catalogs_b.patch
          52 kB
          Suran Jayathilaka
        4. catalogs_c.patch
          70 kB
          Suran Jayathilaka
        5. catalogs_d.patch
          69 kB
          Suran Jayathilaka
        6. catalogs_e.patch
          69 kB
          Suran Jayathilaka
        7. catalogs_f_2.patch
          69 kB
          Suran Jayathilaka
        8. catalogs_f.patch
          69 kB
          Suran Jayathilaka
        9. catalogs_g.diff
          69 kB
          Richard N. Hillegas
        10. catalogs_h.diff
          70 kB
          Richard N. Hillegas
        11. create_drop_sequence_a.patch
          29 kB
          Suran Jayathilaka
        12. create_drop_sequence_b.patch
          34 kB
          Suran Jayathilaka
        13. create_drop_sequence_c.patch
          39 kB
          Suran Jayathilaka
        14. create_drop_sequence_d.patch
          40 kB
          Suran Jayathilaka
        15. create_sequence_a.patch
          18 kB
          Suran Jayathilaka
        16. createseq_args_bind_a.diff
          16 kB
          Suran Jayathilaka
        17. createseq_args_bind_b.diff
          22 kB
          Suran Jayathilaka
        18. derby-712-02-aa-privilegeNodeCleanup.diff
          10 kB
          Richard N. Hillegas
        19. derby-712-03-aa-usagePrivilege.diff
          17 kB
          Richard N. Hillegas
        20. derby-712-03-ac-usagePrivilege.diff
          18 kB
          Richard N. Hillegas
        21. derby-712-04-aa-dblook.diff
          28 kB
          Richard N. Hillegas
        22. derby-712-05-af-sequenceGenerator.diff
          87 kB
          Richard N. Hillegas
        23. derby-712-05-al-sequenceGenerator.diff
          99 kB
          Richard N. Hillegas
        24. derby-712-06-aa-restrictedDrops.diff
          12 kB
          Richard N. Hillegas
        25. SequenceGenerator.html
          24 kB
          Richard N. Hillegas
        26. SequenceGenerator.html
          24 kB
          Richard N. Hillegas
        27. sequences_next_value_a.patch
          10 kB
          Suran Jayathilaka

        Issue Links

          incorporates

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4513 Forbid NEXT VALUE FOR clause in certain contexts

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4580 Cannot use dblook on soft-upgraded database: Table/View 'SYS.SYSSEQUENCES' does not exist.

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4539 Make it possible to put the optional clauses of a CREATE SEQUENCE statement in the arbitrary order allowed by the SQL Standard

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-4487 Add dblook support for SEQUENCEs

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. DERBY-4565 Create concurrency test to stress sequence generators.

          • Major - Major loss of function.
          • Closed
          is blocked by

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-5151 Don't leak unused identity/sequence values on abnormal exit.

          • Major - Major loss of function.
          • Open
          is depended upon by

          Task - A task that needs to be done. DERBY-4568 Documentation needed for sequence generators

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-6494 NEXT VALUE FOR should be illegal inside a COALESCE expression

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-4437 Concurrent inserts into table with identity column perform poorly

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-5426 Improve the error raised by too much contention on a sequence/identity.

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4393 lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-5254 The keywords introduced by the CREATE SEQUENCE work are treated as reserved rather than unreserved.

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-103 Global Oracle/Axion style sequence generator

          • Major - Major loss of function.
          • Closed

          Activity

            People

              suranjay Suran Jayathilaka
              tdahbura Tony Dahbura
              Votes:
              17 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: