You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by fu...@apache.org on 2006/07/17 08:27:01 UTC
svn commit: r422633 -
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/onlineBackupTest4.out
Author: fuzzylogic
Date: Sun Jul 16 23:27:01 2006
New Revision: 422633
URL: http://svn.apache.org/viewvc?rev=422633&view=rev
Log:
Set svn:eol-style native on onlineBackupTest4.out
Modified:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/onlineBackupTest4.out (contents, props changed)
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/onlineBackupTest4.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/onlineBackupTest4.out?rev=422633&r1=422632&r2=422633&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/onlineBackupTest4.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/onlineBackupTest4.out Sun Jul 16 23:27:01 2006
@@ -1,80 +1,80 @@
-ij> -- This script tests online backup functionality and restore.
-connect 'wombat' as c1 ;
-ij(C1)> connect 'wombat' as c2;
-ij(C2)> set connection c1;
-ij(C1)> autocommit off;
-ij(C1)> -- check backup/restore work with in place compress operation.
-create table ctest(id int primary key, name char(200)) ;
-0 rows inserted/updated/deleted
-ij(C1)> insert into ctest values(1, 'derby backup/compress test') ;
-1 row inserted/updated/deleted
-ij(C1)> insert into ctest values(2, 'derby backup/compress test') ;
-1 row inserted/updated/deleted
-ij(C1)> insert into ctest select id+2, name from ctest;
-2 rows inserted/updated/deleted
-ij(C1)> insert into ctest select id+4, name from ctest;
-4 rows inserted/updated/deleted
-ij(C1)> insert into ctest select id+8, name from ctest;
-8 rows inserted/updated/deleted
-ij(C1)> insert into ctest select id+16, name from ctest;
-16 rows inserted/updated/deleted
-ij(C1)> insert into ctest select id+32, name from ctest;
-32 rows inserted/updated/deleted
-ij(C1)> insert into ctest select id+64, name from ctest;
-64 rows inserted/updated/deleted
-ij(C1)> insert into ctest select id+128, name from ctest;
-128 rows inserted/updated/deleted
-ij(C1)> insert into ctest select id+256, name from ctest;
-256 rows inserted/updated/deleted
-ij(C1)> commit ;
-ij(C1)> delete from ctest where id > 2 and id < 509 and id != 300;
-505 rows inserted/updated/deleted
-ij(C1)> select * from ctest;
-ID |NAME
---------------------------------------------------------------------------------------------------------------------------------------------
-1 |derby backup/compress test &
-2 |derby backup/compress test &
-300 |derby backup/compress test &
-509 |derby backup/compress test &
-510 |derby backup/compress test &
-511 |derby backup/compress test &
-512 |derby backup/compress test &
-ij(C1)> commit;
-ij(C1)> --start backup in a seperare thread.
-set connection c2;
-ij(C2)> async bthread
- 'call SYSCS_UTIL.SYSCS_BACKUP_DATABASE(''extinout/mybackup'')';
-ij(C2)> -- start compress in seperate thread.
-set connection c1;
-ij(C1)> async cthread
- 'call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE(''APP'' ,
- ''CTEST'' , 1, 1, 1)';
-ij(C1)> set connection c2;
-ij(C2)> -- wait for backup thread to finish the work.
-wait for bthread;
-0 rows inserted/updated/deleted
-ij(C2)> commit;
-ij(C2)> disconnect;
-ij> set connection c1;
-ij(C1)> -- wait for compress thread to finish the work.
-wait for cthread;
-0 rows inserted/updated/deleted
-ij(C1)> commit;
-ij(C1)> disconnect;
-ij> --shutdown the database
-connect 'wombat;shutdown=true';
-ERROR 08006: Database 'wombat' shutdown.
-ij> connect 'wombat;restoreFrom=extinout/mybackup/wombat';
-ij(CONNECTION1)> select * from ctest;
-ID |NAME
---------------------------------------------------------------------------------------------------------------------------------------------
-1 |derby backup/compress test &
-2 |derby backup/compress test &
-300 |derby backup/compress test &
-509 |derby backup/compress test &
-510 |derby backup/compress test &
-511 |derby backup/compress test &
-512 |derby backup/compress test &
-ij(CONNECTION1)> insert into ctest values(2000, 'restore was successfil') ;
-1 row inserted/updated/deleted
-ij(CONNECTION1)>
+ij> -- This script tests online backup functionality and restore.
+connect 'wombat' as c1 ;
+ij(C1)> connect 'wombat' as c2;
+ij(C2)> set connection c1;
+ij(C1)> autocommit off;
+ij(C1)> -- check backup/restore work with in place compress operation.
+create table ctest(id int primary key, name char(200)) ;
+0 rows inserted/updated/deleted
+ij(C1)> insert into ctest values(1, 'derby backup/compress test') ;
+1 row inserted/updated/deleted
+ij(C1)> insert into ctest values(2, 'derby backup/compress test') ;
+1 row inserted/updated/deleted
+ij(C1)> insert into ctest select id+2, name from ctest;
+2 rows inserted/updated/deleted
+ij(C1)> insert into ctest select id+4, name from ctest;
+4 rows inserted/updated/deleted
+ij(C1)> insert into ctest select id+8, name from ctest;
+8 rows inserted/updated/deleted
+ij(C1)> insert into ctest select id+16, name from ctest;
+16 rows inserted/updated/deleted
+ij(C1)> insert into ctest select id+32, name from ctest;
+32 rows inserted/updated/deleted
+ij(C1)> insert into ctest select id+64, name from ctest;
+64 rows inserted/updated/deleted
+ij(C1)> insert into ctest select id+128, name from ctest;
+128 rows inserted/updated/deleted
+ij(C1)> insert into ctest select id+256, name from ctest;
+256 rows inserted/updated/deleted
+ij(C1)> commit ;
+ij(C1)> delete from ctest where id > 2 and id < 509 and id != 300;
+505 rows inserted/updated/deleted
+ij(C1)> select * from ctest;
+ID |NAME
+--------------------------------------------------------------------------------------------------------------------------------------------
+1 |derby backup/compress test &
+2 |derby backup/compress test &
+300 |derby backup/compress test &
+509 |derby backup/compress test &
+510 |derby backup/compress test &
+511 |derby backup/compress test &
+512 |derby backup/compress test &
+ij(C1)> commit;
+ij(C1)> --start backup in a seperare thread.
+set connection c2;
+ij(C2)> async bthread
+ 'call SYSCS_UTIL.SYSCS_BACKUP_DATABASE(''extinout/mybackup'')';
+ij(C2)> -- start compress in seperate thread.
+set connection c1;
+ij(C1)> async cthread
+ 'call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE(''APP'' ,
+ ''CTEST'' , 1, 1, 1)';
+ij(C1)> set connection c2;
+ij(C2)> -- wait for backup thread to finish the work.
+wait for bthread;
+0 rows inserted/updated/deleted
+ij(C2)> commit;
+ij(C2)> disconnect;
+ij> set connection c1;
+ij(C1)> -- wait for compress thread to finish the work.
+wait for cthread;
+0 rows inserted/updated/deleted
+ij(C1)> commit;
+ij(C1)> disconnect;
+ij> --shutdown the database
+connect 'wombat;shutdown=true';
+ERROR 08006: Database 'wombat' shutdown.
+ij> connect 'wombat;restoreFrom=extinout/mybackup/wombat';
+ij(CONNECTION1)> select * from ctest;
+ID |NAME
+--------------------------------------------------------------------------------------------------------------------------------------------
+1 |derby backup/compress test &
+2 |derby backup/compress test &
+300 |derby backup/compress test &
+509 |derby backup/compress test &
+510 |derby backup/compress test &
+511 |derby backup/compress test &
+512 |derby backup/compress test &
+ij(CONNECTION1)> insert into ctest values(2000, 'restore was successfil') ;
+1 row inserted/updated/deleted
+ij(CONNECTION1)>
Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/onlineBackupTest4.out
------------------------------------------------------------------------------
svn:eol-style = native