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

Same value returned by successive calls to a sequence generator.

    XMLWordPrintableJSON

Details

    • Normal
    • Patch Available, Release Note Needed
    • Deviation from standard, Wrong query result

    Description

      The following script shows the same value being returned from a sequence generator by two successive NEXT VALUE FOR calls. Thanks to Knut for finding this:

      connect 'jdbc:derby:memory:db;create=true';

      create table t (x int);
      create sequence s;
      autocommit off;
      select count from sys.syssequences with rs;
      values next value for s;
      drop table t;
      rollback;

      – same value as previous call
      values next value for s;

      Attachments

        1. releaseNote.html
          4 kB
          Richard N. Hillegas
        2. derby-5493-02-aa-boostPreallocationTo100.diff
          4 kB
          Richard N. Hillegas
        3. derby-5493-01-ag-mergedWith5494.diff
          40 kB
          Richard N. Hillegas
        4. derby-5493-01-af-usersubtran.diff
          42 kB
          Richard N. Hillegas
        5. derby-5493-01-ae-simplerApproachWithCrashJUnitTest.diff
          44 kB
          Richard N. Hillegas
        6. derby-5493-01-ad-simplerApproach.diff
          41 kB
          Richard N. Hillegas
        7. derby-5493-01-aa-correctnessPlusPeekerPlusTest.diff
          76 kB
          Richard N. Hillegas

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-5495 Master issue to track fixes to sequence generators

          • Major - Major loss of function.
          • Closed

          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-5697 Doc changes to account for correctness fixes for sequences

          • Major - Major loss of function.
          • Closed

          Activity

            People

              rhillegas Richard N. Hillegas
              rhillegas Richard N. Hillegas
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: