Details

    • Type: Improvement
    • Status: Closed
    • Priority: 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.

        Attachments

        1. sequences_next_value_a.patch
          10 kB
          Suran Jayathilaka
        2. SequenceGenerator.html
          24 kB
          Rick Hillegas
        3. SequenceGenerator.html
          24 kB
          Rick Hillegas
        4. derby-712-06-aa-restrictedDrops.diff
          12 kB
          Rick Hillegas
        5. derby-712-05-al-sequenceGenerator.diff
          99 kB
          Rick Hillegas
        6. derby-712-05-af-sequenceGenerator.diff
          87 kB
          Rick Hillegas
        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. derby-712-02-aa-privilegeNodeCleanup.diff
          10 kB
          Rick Hillegas
        11. createseq_args_bind_b.diff
          22 kB
          Suran Jayathilaka
        12. createseq_args_bind_a.diff
          16 kB
          Suran Jayathilaka
        13. create_sequence_a.patch
          18 kB
          Suran Jayathilaka
        14. create_drop_sequence_d.patch
          40 kB
          Suran Jayathilaka
        15. create_drop_sequence_c.patch
          39 kB
          Suran Jayathilaka
        16. create_drop_sequence_b.patch
          34 kB
          Suran Jayathilaka
        17. create_drop_sequence_a.patch
          29 kB
          Suran Jayathilaka
        18. catalogs_h.diff
          70 kB
          Rick Hillegas
        19. catalogs_g.diff
          69 kB
          Rick Hillegas
        20. catalogs_f.patch
          69 kB
          Suran Jayathilaka
        21. catalogs_f_2.patch
          69 kB
          Suran Jayathilaka
        22. catalogs_e.patch
          69 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. altertable.diff
          18 kB
          Suran Jayathilaka

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: