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

Write tests to verify the interaction of TRUNCATE TABLE and online backup

    Details

    • Type: Task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.9.1.0
    • Fix Version/s: 10.10.1.1
    • Component/s: SQL, Store
    • Labels:
      None
    • Issue & fix info:
      Newcomer

      Description

      An uncommitted TRUNCATE TABLE command does not block online backup. We should verify that the online and backed up databases are both in a consistent state. At a minimum, we should test the following:

      o uncommitted truncate table followed by online backup and then access the backup copy and access the table. should see the old data.
      o uncommitred truncate table, followed by online backup that keeps logs,
      then commit the truncate, and then access the table in the backup.

      For more information, please see this email thread: http://old.nabble.com/truncating-a-table-vs-online-backup-to31524933.html#a31524933

        Attachments

        1. DERBY-5213.diff_3
          8 kB
          Myrna van Lunteren
        2. DERBY-5213.diff_2
          11 kB
          Myrna van Lunteren
        3. DERBY_5213.diff_1
          15 kB
          Myrna van Lunteren

          Activity

            People

            • Assignee:
              myrna Myrna van Lunteren
              Reporter:
              rhillegas Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: