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. 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
          Rick Hillegas
        10. catalogs_h.diff
          70 kB
          Rick 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
          Rick Hillegas
        19. derby-712-03-aa-usagePrivilege.diff
          17 kB
          Rick Hillegas
        20. derby-712-03-ac-usagePrivilege.diff
          18 kB
          Rick Hillegas
        21. derby-712-04-aa-dblook.diff
          28 kB
          Rick Hillegas
        22. derby-712-05-af-sequenceGenerator.diff
          87 kB
          Rick Hillegas
        23. derby-712-05-al-sequenceGenerator.diff
          99 kB
          Rick Hillegas
        24. derby-712-06-aa-restrictedDrops.diff
          12 kB
          Rick Hillegas
        25. SequenceGenerator.html
          24 kB
          Rick Hillegas
        26. SequenceGenerator.html
          24 kB
          Rick Hillegas
        27. sequences_next_value_a.patch
          10 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: