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;

      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

          Rick Hillegas created issue -
          Rick Hillegas made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-5495 [ DERBY-5495 ]
          Mamta A. Satoor made changes -
          Labels derby_triage10_9
          Rick Hillegas made changes -
          Assignee Rick Hillegas [ rhillegas ]
          Rick Hillegas made changes -
          Rick Hillegas made changes -
          Bug behavior facts Deviation from standard,Wrong query result [ 10367,10366 ]
          Issue & fix info Patch Available,Release Note Needed [ 10102,10101 ]
          Rick Hillegas made changes -
          Attachment derby-5493-01-ad-simplerApproach.diff [ 12522169 ]
          Rick Hillegas made changes -
          Rick Hillegas made changes -
          Link This issue is related to DERBY-4437 [ DERBY-4437 ]
          Mike Matrigali made changes -
          Assignee Rick Hillegas [ rhillegas ] Mike Matrigali [ mikem ]
          Mike Matrigali made changes -
          Assignee Mike Matrigali [ mikem ] Rick Hillegas [ rhillegas ]
          Rick Hillegas made changes -
          Attachment derby-5493-01-af-usersubtran.diff [ 12522992 ]
          Rick Hillegas made changes -
          Attachment derby-5493-01-ag-mergedWith5494.diff [ 12523181 ]
          Rick Hillegas made changes -
          Rick Hillegas made changes -
          Link This issue is related to DERBY-5697 [ DERBY-5697 ]
          Rick Hillegas made changes -
          Attachment releaseNote.html [ 12523390 ]
          Rick Hillegas made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Mike Matrigali made changes -
          Fix Version/s 10.9.1.0 [ 12316344 ]
          Kathey Marsden made changes -
          Link This issue is required by DERBY-5923 [ DERBY-5923 ]
          Kathey Marsden made changes -
          Labels derby_triage10_9 derby_backport_reject_10_8 derby_triage10_9
          Kathey Marsden made changes -
          Link This issue is required by DERBY-5923 [ DERBY-5923 ]
          Mike Matrigali made changes -
          Comment [ I think we don't want to backport this. To alleviate the performance issue created by this issue and DERBY-5494 the preallocation behavior was changed. ]
          Rick Hillegas made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12641289 ] Default workflow, editable Closed status [ 12802611 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development