Derby
  1. Derby
  2. DERBY-5213

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

    Details

    • Type: Task Task
    • Status: Closed
    • Priority: Major 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

      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

        Rick Hillegas created issue -
        Myrna van Lunteren made changes -
        Field Original Value New Value
        Assignee Myrna van Lunteren [ myrna ]
        Myrna van Lunteren made changes -
        Attachment DERBY_5213.diff_1 [ 12542875 ]
        Myrna van Lunteren made changes -
        Issue & fix info Newcomer [ 10423 ] Newcomer,Patch Available [ 10423, 10102 ]
        Myrna van Lunteren made changes -
        Attachment DERBY-5213.diff_2 [ 12543202 ]
        Myrna van Lunteren made changes -
        Attachment DERBY-5213.diff_3 [ 12544735 ]
        Myrna van Lunteren made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Issue & fix info Newcomer,Patch Available [ 10423, 10102 ] Newcomer [ 10423 ]
        Fix Version/s 10.10.0.0 [ 12321550 ]
        Resolution Fixed [ 1 ]
        Rick Hillegas made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Gavin made changes -
        Workflow jira [ 12612335 ] Default workflow, editable Closed status [ 12802650 ]

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development