db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kahat...@apache.org
Subject svn commit: r422706 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master: backupRestore.out dml026.out dml034.out dml076.out dml099.out dml148.out testsqldecimal.out
Date Mon, 17 Jul 2006 12:48:59 GMT
Author: kahatlen
Date: Mon Jul 17 05:48:58 2006
New Revision: 422706

URL: http://svn.apache.org/viewvc?rev=422706&view=rev
Log:
DERBY-836/DERBY-1514: Failures in derbyall in trunk seen after
revision 421960

Updated master files. Patch contributed by Mayuresh Nirhali.

Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/backupRestore.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml026.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml034.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml076.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml148.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/testsqldecimal.out

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/backupRestore.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/backupRestore.out?rev=422706&r1=422705&r2=422706&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/backupRestore.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/backupRestore.out
Mon Jul 17 05:48:58 2006
@@ -10,11 +10,11 @@
 ij> create function dv(P1 INT) RETURNS INT NO SQL external name 'dbytesting.CodeInAJar.doubleMe'
language java parameter style java;
 0 rows inserted/updated/deleted
 ij> select cast (dv(x) as dec(5,2)) from x;
-1       
---------
-2.00    
-20.00   
-40.00   
+1      
+-------
+2.00   
+20.00  
+40.00  
 ij> ----take a backup.
 call SYSCS_UTIL.SYSCS_BACKUP_DATABASE('extinout/mybackup');
 0 rows inserted/updated/deleted
@@ -24,32 +24,32 @@
 ij> ---restore a databases
 connect 'wombat;restoreFrom=extinout/mybackup/wombat';
 ij> select cast (dv(x) as dec(5,2)) from x;
-1       
---------
-2.00    
-20.00   
-40.00   
+1      
+-------
+2.00   
+20.00  
+40.00  
 ij> connect 'wombat;shutdown=true';
 ERROR 08006: Database 'wombat' shutdown.
 ij> disconnect;
 ij> ---create a new database from backup.
 connect 'wombatnew;createFrom=extinout/mybackup/wombat';
 ij> select cast (dv(x) as dec(5,2)) from x;
-1       
---------
-2.00    
-20.00   
-40.00   
+1      
+-------
+2.00   
+20.00  
+40.00  
 ij> connect 'wombatnew;shutdown=true';
 ERROR 08006: Database 'wombatnew' shutdown.
 ij> disconnect;
 ij> connect 'wombat';
 ij> select cast (dv(x) as dec(5,2)) from x;
-1       
---------
-2.00    
-20.00   
-40.00   
+1      
+-------
+2.00   
+20.00  
+40.00  
 ij> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE('extinout/mybackup',
1);
 0 rows inserted/updated/deleted
 ij> insert into x values (1,1),(10,1),(20,1);
@@ -61,23 +61,23 @@
 ij> insert into x values (1,1),(10,1),(20,1);
 3 rows inserted/updated/deleted
 ij> select cast (dv(x) as dec(5,2)) from x;
-1       
---------
-2.00    
-20.00   
-40.00   
-2.00    
-20.00   
-40.00   
-2.00    
-20.00   
-40.00   
-2.00    
-20.00   
-40.00   
-2.00    
-20.00   
-40.00   
+1      
+-------
+2.00   
+20.00  
+40.00  
+2.00   
+20.00  
+40.00  
+2.00   
+20.00  
+40.00  
+2.00   
+20.00  
+40.00  
+2.00   
+20.00  
+40.00  
 ij> connect 'wombat;shutdown=true';
 ERROR 08006: Database 'wombat' shutdown.
 ij> disconnect;
@@ -102,23 +102,23 @@
 10.0                  |1          
 20.0                  |1          
 ij> select cast (dv(x) as dec(5,2)) from x;
-1       
---------
-2.00    
-20.00   
-40.00   
-2.00    
-20.00   
-40.00   
-2.00    
-20.00   
-40.00   
-2.00    
-20.00   
-40.00   
-2.00    
-20.00   
-40.00   
+1      
+-------
+2.00   
+20.00  
+40.00  
+2.00   
+20.00  
+40.00  
+2.00   
+20.00  
+40.00  
+2.00   
+20.00  
+40.00  
+2.00   
+20.00  
+40.00  
 ij> insert into x values (1,1),(10,1),(20,1);
 3 rows inserted/updated/deleted
 ij> connect 'wombat;shutdown=true';

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml026.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml026.out?rev=422706&r1=422705&r2=422706&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml026.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml026.out
Mon Jul 17 05:48:58 2006
@@ -82,12 +82,12 @@
 --O      SELECT COUNT(*)
       SELECT *
            FROM VTABLE;
-COL1       |COL2       |COL3       |COL4       |COL5      
-----------------------------------------------------------
-10         |20         |30         |40         |10.50     
-0          |1          |2          |3          |4.25      
-100        |200        |300        |400        |500.01    
-1000       |-2000      |3000       |NULL       |4000.00   
+COL1       |COL2       |COL3       |COL4       |COL5     
+---------------------------------------------------------
+10         |20         |30         |40         |10.50    
+0          |1          |2          |3          |4.25     
+100        |200        |300        |400        |500.01   
+1000       |-2000      |3000       |NULL       |4000.00  
 ij> -- PASS:0121 If count = 4 ?
       SELECT +COL1+COL2 - COL3*COL4/COL1
               FROM VTABLE

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml034.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml034.out?rev=422706&r1=422705&r2=422706&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml034.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml034.out
Mon Jul 17 05:48:58 2006
@@ -117,17 +117,17 @@
 ij> -- PASS:0093 If 1 row is inserted?
      SELECT *
           FROM LL;
-NUMTEST         
-----------------
-123456.123456   
+NUMTEST        
+---------------
+123456.123456  
 ij> -- PASS:0093 If NUMTEST = 123456.123456 ?
 -- PASS:0093 OR  is between 123456.123451 and 123456.123461 ?
      SELECT * 
        FROM LL
        WHERE NUMTEST > 123456.123450 and NUMTEST < 123456.123462;
-NUMTEST         
-----------------
-123456.123456   
+NUMTEST        
+---------------
+123456.123456  
 ij> -- PASS:0093 If 1 row selected?
 -- restore
      ROLLBACK WORK;
@@ -141,9 +141,9 @@
 ij> -- PASS:0094 If 1 row is inserted?
      SELECT *
           FROM PP;
-NUMTEST         
-----------------
-123456.123456   
+NUMTEST        
+---------------
+123456.123456  
 ij> -- PASS:0094 If NUMTEST = 123456.123456 ?
 -- PASS:0094 OR  is between 123456.123451 and 123456.123461 ?
 -- restore
@@ -158,9 +158,9 @@
 ij> -- PASS:0095 If 1 row is inserted?
      SELECT *
           FROM SS;
-NUMTEST         
-----------------
-123456.123456   
+NUMTEST        
+---------------
+123456.123456  
 ij> -- PASS:0095 If NUMTEST = 123456.123456 ?
 -- PASS:0095 OR  is between 123456.123451 and 123456.123461 ?
 -- restore

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml076.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml076.out?rev=422706&r1=422705&r2=422706&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml076.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml076.out
Mon Jul 17 05:48:58 2006
@@ -101,9 +101,9 @@
 ij> -- PASS:0436 If NUMTEST is NULL (Implementor defined print format)?
     SELECT NUMTEST 
       FROM SS;
-NUMTEST         
-----------------
-NULL            
+NUMTEST        
+---------------
+NULL           
 ij> -- PASS:0436 If NUMTEST is NULL (Implementor defined print format)?
 -- restore
     ROLLBACK WORK;

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out?rev=422706&r1=422705&r2=422706&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out
Mon Jul 17 05:48:58 2006
@@ -26,17 +26,17 @@
 1 row inserted/updated/deleted
 ij> -- PASS:0582 If 1 row is inserted?
    SELECT C1, C2, C3 FROM ICAST2;
-C1         |C2                    |C3      
--------------------------------------------
-3          |3.0                   |3.142   
+C1         |C2                    |C3     
+------------------------------------------
+3          |3.0                   |3.142  
 ij> -- PASS:0582 If 1 row is selected with C1 = 3 and C3 = 3.142?
    UPDATE ICAST2 SET C1 = 5.2413E+0, C2 = 5, C3 = 5.2413E+0;
 1 row inserted/updated/deleted
 ij> -- PASS:0582 If 1 row is updated?
    SELECT C1, C2, C3 FROM ICAST2;
-C1         |C2                    |C3      
--------------------------------------------
-5          |5.0                   |5.241   
+C1         |C2                    |C3     
+------------------------------------------
+5          |5.0                   |5.241  
 ij> -- PASS:0582 If 1 row is selected with C1 = 5 and C3 = 5.241?
    UPDATE ICAST2 SET C1 = 6.28E+0, C2 = 2.1E+0, C3 = .07E+2;
 1 row inserted/updated/deleted
@@ -45,9 +45,9 @@
 1 row inserted/updated/deleted
 ij> -- PASS:0582 If 1 row is updated?
    SELECT C1, C2, C3 FROM ICAST2;
-C1         |C2                    |C3      
--------------------------------------------
-2          |2.1                   |9.100   
+C1         |C2                    |C3     
+------------------------------------------
+2          |2.1                   |9.100  
 ij> -- PASS:0582 If 1 row is selected with C1 = 2 and C3 = 9.100?
    ROLLBACK WORK;
 ij> --O   DROP TABLE ICAST2 CASCADE;

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml148.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml148.out?rev=422706&r1=422705&r2=422706&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml148.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml148.out
Mon Jul 17 05:48:58 2006
@@ -122,14 +122,14 @@
      FROM HU.STAFF LEFT OUTER JOIN SEVEN_TYPES 
         ON -GRADE / 11 BETWEEN T_REAL AND T_DECIMAL
      ORDER BY EMPNAME;
-EMPNAME             |CITY           |T_DECIMAL    
---------------------------------------------------
-Alice               |Deale          |NULL         
-Betty               |Vienna         |0.00         
-Betty               |Vienna         |0.00         
-Carmen              |Vienna         |NULL         
-Don                 |Deale          |NULL         
-Ed                  |Akron          |NULL         
+EMPNAME             |CITY           |T_DECIMAL   
+-------------------------------------------------
+Alice               |Deale          |NULL        
+Betty               |Vienna         |0.00        
+Betty               |Vienna         |0.00        
+Carmen              |Vienna         |NULL        
+Don                 |Deale          |NULL        
+Ed                  |Akron          |NULL        
 ij> -- PASS:0844 If 6 rows selected with ordered rows and column values ?
 -- PASS:0844    Alice  Deale  NULL  ?
 -- PASS:0844    Betty  Vienna    0  ?

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/testsqldecimal.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/testsqldecimal.out?rev=422706&r1=422705&r2=422706&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/testsqldecimal.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/testsqldecimal.out
Mon Jul 17 05:48:58 2006
@@ -245,101 +245,101 @@
 from test_numeric
 where v < 0.55
 order by v;
-V                                 
-----------------------------------
-0.1536593492525492044009638448    
-0.1555191728719779176159931921    
-0.1568456833499958236188831506    
-0.1677713423639355383443216851    
-0.1695519434076245834930318778    
-0.1718278072488579333310099173    
-0.1727255141705672514262914774    
-0.1737904400565515317111930926    
-0.1782843963042969326338038627    
-0.1904438653452124041720594505    
-0.2047081212587233967070687867    
-0.2049258536123884644197801208    
-0.2067829913930419039047592377    
-0.2089758117552442673314772036    
-0.2191137080532280512201737110    
-0.2193507343945524379336120546    
-0.2210122551768809451289143908    
-0.2338520214389969709145589149    
-0.2501658790914437213714904828    
-0.2547320773064839505295253729    
-0.2566525896214666424555161938    
-0.2591775211286250213404969144    
-0.2597117429367816754393061273    
-0.2634260831072273711939146778    
-0.2651539382849691373067457789    
-0.2843947542914674331271385199    
-0.2845017209632791921336547602    
-0.2857735416823491414461955173    
-0.2936700960145427474756729679    
-0.2981415793510636680352376970    
-0.3008307627334292355669731477    
-0.3014802756720524889999524020    
-0.3134104958348893354980191361    
-0.3155969996710682456964036646    
-0.3167678364660315715184424334    
-0.3198315610140561870977649050    
-0.3215818675905512957768905835    
-0.3300449190657601672427290395    
-0.3401701729489799985728382125    
-0.3430233301954115354703844786    
-0.3435288389096449179760384140    
-0.3480383249530311084996014869    
-0.3481765899409600129033037774    
-0.3483875618801968165882954053    
-0.3489572605138031580196411596    
-0.3537609496084048732456039942    
-0.3539043709099155554653748367    
-0.3551966720704967661603745909    
-0.3565980920095701556249423447    
-0.3618915503987547577224859196    
-0.3630175110466937749009730396    
-0.3642959475737695962394013804    
-0.3651732821323184774442438538    
-0.3664574220416412231315916869    
-0.3734062052302885570398416348    
-0.3794512437319138564717491135    
-0.3875715021397930781787977139    
-0.3910761415141438268605611483    
-0.3940797013215265875984982812    
-0.4084500754886088991213455301    
-0.4138057060514680474128113019    
-0.4189695575666363414057968839    
-0.4268132421296624290363297404    
-0.4370347171902146943267553069    
-0.4481460586770347198637409746    
-0.4485604032505513538708896703    
-0.4538202696163863292255769010    
-0.4562698097865310886689371727    
-0.4618552559223557674172866427    
-0.4692321237545271639390875861    
-0.4701059689574355049401788164    
-0.4710495304435537988752003002    
-0.4718012889544094257132655911    
-0.4720981740142321525510737956    
-0.4799980443000889662741315078    
-0.4875103485574007189384815319    
-0.4883443943160398204028638247    
-0.4914539318893716979275154699    
-0.4928119513939271945091036286    
-0.4986869346852229600841610590    
-0.5085511833170096585021724422    
-0.5100216985763087462757425782    
-0.5146415813055444932189175233    
-0.5148385992594396443067239488    
-0.5162544567876936607575544257    
-0.5174249980879759291951813793    
-0.5206175563480499590696126688    
-0.5235405195184146265319213853    
-0.5262072554280383673841470226    
-0.5360358184493685396176942958    
-0.5385193561200120049292650037    
-0.5399195678570223311254494547    
-0.5467385094357491981398311509    
+V                                
+---------------------------------
+0.1536593492525492044009638448   
+0.1555191728719779176159931921   
+0.1568456833499958236188831506   
+0.1677713423639355383443216851   
+0.1695519434076245834930318778   
+0.1718278072488579333310099173   
+0.1727255141705672514262914774   
+0.1737904400565515317111930926   
+0.1782843963042969326338038627   
+0.1904438653452124041720594505   
+0.2047081212587233967070687867   
+0.2049258536123884644197801208   
+0.2067829913930419039047592377   
+0.2089758117552442673314772036   
+0.2191137080532280512201737110   
+0.2193507343945524379336120546   
+0.2210122551768809451289143908   
+0.2338520214389969709145589149   
+0.2501658790914437213714904828   
+0.2547320773064839505295253729   
+0.2566525896214666424555161938   
+0.2591775211286250213404969144   
+0.2597117429367816754393061273   
+0.2634260831072273711939146778   
+0.2651539382849691373067457789   
+0.2843947542914674331271385199   
+0.2845017209632791921336547602   
+0.2857735416823491414461955173   
+0.2936700960145427474756729679   
+0.2981415793510636680352376970   
+0.3008307627334292355669731477   
+0.3014802756720524889999524020   
+0.3134104958348893354980191361   
+0.3155969996710682456964036646   
+0.3167678364660315715184424334   
+0.3198315610140561870977649050   
+0.3215818675905512957768905835   
+0.3300449190657601672427290395   
+0.3401701729489799985728382125   
+0.3430233301954115354703844786   
+0.3435288389096449179760384140   
+0.3480383249530311084996014869   
+0.3481765899409600129033037774   
+0.3483875618801968165882954053   
+0.3489572605138031580196411596   
+0.3537609496084048732456039942   
+0.3539043709099155554653748367   
+0.3551966720704967661603745909   
+0.3565980920095701556249423447   
+0.3618915503987547577224859196   
+0.3630175110466937749009730396   
+0.3642959475737695962394013804   
+0.3651732821323184774442438538   
+0.3664574220416412231315916869   
+0.3734062052302885570398416348   
+0.3794512437319138564717491135   
+0.3875715021397930781787977139   
+0.3910761415141438268605611483   
+0.3940797013215265875984982812   
+0.4084500754886088991213455301   
+0.4138057060514680474128113019   
+0.4189695575666363414057968839   
+0.4268132421296624290363297404   
+0.4370347171902146943267553069   
+0.4481460586770347198637409746   
+0.4485604032505513538708896703   
+0.4538202696163863292255769010   
+0.4562698097865310886689371727   
+0.4618552559223557674172866427   
+0.4692321237545271639390875861   
+0.4701059689574355049401788164   
+0.4710495304435537988752003002   
+0.4718012889544094257132655911   
+0.4720981740142321525510737956   
+0.4799980443000889662741315078   
+0.4875103485574007189384815319   
+0.4883443943160398204028638247   
+0.4914539318893716979275154699   
+0.4928119513939271945091036286   
+0.4986869346852229600841610590   
+0.5085511833170096585021724422   
+0.5100216985763087462757425782   
+0.5146415813055444932189175233   
+0.5148385992594396443067239488   
+0.5162544567876936607575544257   
+0.5174249980879759291951813793   
+0.5206175563480499590696126688   
+0.5235405195184146265319213853   
+0.5262072554280383673841470226   
+0.5360358184493685396176942958   
+0.5385193561200120049292650037   
+0.5399195678570223311254494547   
+0.5467385094357491981398311509   
 ij> drop table test_numeric;
 0 rows inserted/updated/deleted
 ij> exit;



Mime
View raw message