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

Same value returned by successive calls to a sequence generator.

    Details

    • Urgency:
      Normal
    • Issue & fix info:
      Patch Available, Release Note Needed
    • Bug behavior facts:
      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
          Rick Hillegas
        2. derby-5493-02-aa-boostPreallocationTo100.diff
          4 kB
          Rick Hillegas
        3. derby-5493-01-ag-mergedWith5494.diff
          40 kB
          Rick Hillegas
        4. derby-5493-01-af-usersubtran.diff
          42 kB
          Rick Hillegas
        5. derby-5493-01-ae-simplerApproachWithCrashJUnitTest.diff
          44 kB
          Rick Hillegas
        6. derby-5493-01-ad-simplerApproach.diff
          41 kB
          Rick Hillegas
        7. derby-5493-01-aa-correctnessPlusPeekerPlusTest.diff
          76 kB
          Rick Hillegas

          Issue Links

            Activity

              People

              • Assignee:
                rhillegas Rick Hillegas
                Reporter:
                rhillegas Rick Hillegas
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: