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

        Issue Links

          Activity

          Tony Dahbura created issue -
          Mike Matrigali made changes -
          Field Original Value New Value
          Component/s SQL [ 11408 ]
          Rick Hillegas made changes -
          Link This issue relates to DERBY-103 [ DERBY-103 ]
          Suran Jayathilaka made changes -
          Assignee Suran Jayathilaka [ suranjay ]
          Rick Hillegas made changes -
          Attachment SequenceGenerator.html [ 12401852 ]
          Suran Jayathilaka made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Suran Jayathilaka made changes -
          Attachment catalogs_a.patch [ 12408958 ]
          Suran Jayathilaka made changes -
          Fix Version/s 10.6.0.0 [ 12313727 ]
          Derby Info [Patch Available]
          Suran Jayathilaka made changes -
          Attachment catalogs_b.patch [ 12410348 ]
          Suran Jayathilaka made changes -
          Attachment catalogs_c.patch [ 12411445 ]
          Suran Jayathilaka made changes -
          Attachment catalogs_d.patch [ 12411552 ]
          Attachment altertable.diff [ 12411553 ]
          Suran Jayathilaka made changes -
          Attachment catalogs_e.patch [ 12412191 ]
          Dag H. Wanvik made changes -
          Issue Type New Feature [ 2 ] Improvement [ 4 ]
          Suran Jayathilaka made changes -
          Attachment catalogs_f.patch [ 12412658 ]
          Suran Jayathilaka made changes -
          Attachment catalogs_f_2.patch [ 12412659 ]
          Rick Hillegas made changes -
          Attachment catalogs_g.diff [ 12412736 ]
          Rick Hillegas made changes -
          Attachment catalogs_h.diff [ 12412875 ]
          Sukhitha Prabhath Jayathilaka made changes -
          Comment [ Hi Rick,

          That's great! Thank you so much for your patience and help. I will get started on the CREATE/DROP SEQUENCE work right away.

          Thanks!
          Suran ]
          Rick Hillegas made changes -
          Issue & fix info [Patch Available]
          Suran Jayathilaka made changes -
          Attachment create_sequence_a.patch [ 12416008 ]
          Suran Jayathilaka made changes -
          Attachment create_drop_sequence_a.patch [ 12416102 ]
          Suran Jayathilaka made changes -
          Attachment create_drop_sequence_b.patch [ 12416248 ]
          Suran Jayathilaka made changes -
          Attachment create_drop_sequence_c.patch [ 12416729 ]
          Suran Jayathilaka made changes -
          Attachment create_drop_sequence_d.patch [ 12418178 ]
          Rick Hillegas made changes -
          Link This issue relates to DERBY-4393 [ DERBY-4393 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-4437 [ DERBY-4437 ]
          Rick Hillegas made changes -
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4487 [ DERBY-4487 ]
          Suran Jayathilaka made changes -
          Attachment sequences_next_value_a.patch [ 12428893 ]
          Rick Hillegas made changes -
          Attachment derby-712-03-aa-usagePrivilege.diff [ 12429551 ]
          Rick Hillegas made changes -
          Attachment derby-712-03-ac-usagePrivilege.diff [ 12429642 ]
          Rick Hillegas made changes -
          Attachment derby-712-04-aa-dblook.diff [ 12429957 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4513 [ DERBY-4513 ]
          Suran Jayathilaka made changes -
          Attachment createseq_args_bind_a.diff [ 12431067 ]
          Suran Jayathilaka made changes -
          Attachment createseq_args_bind_a.diff [ 12431067 ]
          Suran Jayathilaka made changes -
          Attachment createseq_args_bind_a.diff [ 12431068 ]
          Rick Hillegas made changes -
          Attachment derby-712-05-af-sequenceGenerator.diff [ 12431431 ]
          Rick Hillegas made changes -
          Issue & fix info [Patch Available]
          Suran Jayathilaka made changes -
          Attachment createseq_args_bind_b.diff [ 12431917 ]
          Rick Hillegas made changes -
          Attachment derby-712-05-al-sequenceGenerator.diff [ 12434908 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4539 [ DERBY-4539 ]
          Rick Hillegas made changes -
          Attachment derby-712-06-aa-restrictedDrops.diff [ 12435773 ]
          Rick Hillegas made changes -
          Attachment SequenceGenerator.html [ 12435885 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4565 [ DERBY-4565 ]
          Kim Haase made changes -
          Link This issue blocks DERBY-4568 [ DERBY-4568 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4580 [ DERBY-4580 ]
          Rick Hillegas made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Rick Hillegas made changes -
          Link This issue is blocked by DERBY-5151 [ DERBY-5151 ]
          Rick Hillegas made changes -
          Link This issue relates to DERBY-5254 [ DERBY-5254 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-5426 [ DERBY-5426 ]
          Gavin made changes -
          Link This issue blocks DERBY-4568 [ DERBY-4568 ]
          Gavin made changes -
          Link This issue is depended upon by DERBY-4568 [ DERBY-4568 ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12343827 ] Default workflow, editable Closed status [ 12802850 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-6494 [ DERBY-6494 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development