db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fuzzylo...@apache.org
Subject svn commit: r422633 - /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/onlineBackupTest4.out
Date Mon, 17 Jul 2006 06:27:01 GMT
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



Mime
View raw message