Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.6.1.0
    • Component/s: SQL
    • Labels:
      None
    • Environment:
      feature request
    • Issue & fix info:
      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.

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

        Issue Links

          Activity

            People

            • Assignee:
              Suran Jayathilaka
              Reporter:
              Tony Dahbura
            • Votes:
              17 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development