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 ka...@apache.org on 2006/07/17 14:48:59 UTC
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
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;