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

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

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.9.1.0
    • 10.10.1.1
    • SQL, Store
    • None
    • 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_1
          15 kB
          Myrna van Lunteren
        2. DERBY-5213.diff_2
          11 kB
          Myrna van Lunteren
        3. DERBY-5213.diff_3
          8 kB
          Myrna van Lunteren

        Activity

          People

            myrna Myrna van Lunteren
            rhillegas Richard N. Hillegas
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: