db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From d..@apache.org
Subject svn commit: r475446 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/functions.out tests/lang/functions.sql
Date Wed, 15 Nov 2006 21:54:40 GMT
Author: djd
Date: Wed Nov 15 13:54:40 2006
New Revision: 475446

URL: http://svn.apache.org/viewvc?view=rev&rev=475446
Log:
Remove test cases from functions.sql that are covered by MathTrigFunctionsTest.

Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/functions.sql

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out?view=diff&rev=475446&r1=475445&r2=475446
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out
Wed Nov 15 13:54:40 2006
@@ -635,98 +635,6 @@
 1 row inserted/updated/deleted
 ij> insert into SYSFUN_MATH_TEST values 1.34;
 1 row inserted/updated/deleted
-ij> -- cast result to DECIMAL to reduce possible diffs
--- with different vms and double values.;
-VALUES PI();
-1                     
-----------------------
-3.141592653589793     
-ij> select cast (ACOS(d) as DECIMAL(6,3)) AS ACOS FROM SYSFUN_MATH_TEST;
-ACOS    
---------
-NULL    
-0.836   
-ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
-ij> select cast (ASIN(d) as DECIMAL(6,3)) AS ASIN FROM SYSFUN_MATH_TEST;
-ASIN    
---------
-NULL    
-0.734   
-ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
-ij> select cast (ATAN(d) as DECIMAL(6,3)) AS ATAN FROM SYSFUN_MATH_TEST;
-ATAN    
---------
-NULL    
-0.590   
-0.929   
-ij> select cast (COS(d) as DECIMAL(6,3)) AS COS FROM SYSFUN_MATH_TEST;
-COS     
---------
-NULL    
-0.783   
-0.228   
-ij> select cast (SIN(d) as DECIMAL(6,3)) AS SIN FROM SYSFUN_MATH_TEST;
-SIN     
---------
-NULL    
-0.620   
-0.973   
-ij> select cast (TAN(d) as DECIMAL(6,3)) AS TAN FROM SYSFUN_MATH_TEST;
-TAN     
---------
-NULL    
-0.792   
-4.255   
-ij> select cast (DEGREES(d) as DECIMAL(6,3)) AS DEGREES FROM SYSFUN_MATH_TEST;
-DEGREES 
---------
-NULL    
-38.388  
-76.776  
-ij> select cast (RADIANS(d) as DECIMAL(6,3)) AS RADIANS FROM SYSFUN_MATH_TEST;
-RADIANS 
---------
-NULL    
-0.011   
-0.023   
-ij> select cast (LN(d) as DECIMAL(6,3)) AS LN,
-       cast (LOG(d) as DECIMAL(6,3)) AS LOG
-                       FROM SYSFUN_MATH_TEST;
-LN      |LOG     
------------------
-NULL    |NULL    
--0.400  |-0.400  
-0.292   |0.292   
-ij> select cast (EXP(d) as DECIMAL(6,3)) AS EXP FROM SYSFUN_MATH_TEST;
-EXP     
---------
-NULL    
-1.954   
-3.819   
-ij> select cast (LOG10(d) as DECIMAL(6,3)) AS LOG10 FROM SYSFUN_MATH_TEST;
-LOG10   
---------
-NULL    
--0.173  
-0.127   
-ij> select cast (CEIL(d) as DECIMAL(6,3)) AS CEIL FROM SYSFUN_MATH_TEST;
-CEIL    
---------
-NULL    
-1.000   
-2.000   
-ij> select cast (CEILING(d) as DECIMAL(6,3)) AS CEILING FROM SYSFUN_MATH_TEST;
-CEILING 
---------
-NULL    
-1.000   
-2.000   
-ij> select cast (FLOOR(d) as DECIMAL(6,3)) AS FLOOR FROM SYSFUN_MATH_TEST;
-FLOOR   
---------
-NULL    
-0.000   
-1.000   
 ij> select cast (SYSFUN.ACOS(d) as DECIMAL(6,3)) AS SYSFUN_ACOS FROM SYSFUN_MATH_TEST;
 SYSFUN_&
 --------

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/functions.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/functions.sql?view=diff&rev=475446&r1=475445&r2=475446
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/functions.sql
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/functions.sql
Wed Nov 15 13:54:40 2006
@@ -300,33 +300,6 @@
 insert into SYSFUN_MATH_TEST values 0.67;
 insert into SYSFUN_MATH_TEST values 1.34;
 
--- cast result to DECIMAL to reduce possible diffs
--- with different vms and double values.;
-
-VALUES PI();
-
-select cast (ACOS(d) as DECIMAL(6,3)) AS ACOS FROM SYSFUN_MATH_TEST;
-select cast (ASIN(d) as DECIMAL(6,3)) AS ASIN FROM SYSFUN_MATH_TEST;
-select cast (ATAN(d) as DECIMAL(6,3)) AS ATAN FROM SYSFUN_MATH_TEST;
-
-select cast (COS(d) as DECIMAL(6,3)) AS COS FROM SYSFUN_MATH_TEST;
-select cast (SIN(d) as DECIMAL(6,3)) AS SIN FROM SYSFUN_MATH_TEST;
-select cast (TAN(d) as DECIMAL(6,3)) AS TAN FROM SYSFUN_MATH_TEST;
-
-select cast (DEGREES(d) as DECIMAL(6,3)) AS DEGREES FROM SYSFUN_MATH_TEST;
-select cast (RADIANS(d) as DECIMAL(6,3)) AS RADIANS FROM SYSFUN_MATH_TEST;
-
-select cast (LN(d) as DECIMAL(6,3)) AS LN,
-       cast (LOG(d) as DECIMAL(6,3)) AS LOG
-                       FROM SYSFUN_MATH_TEST;
-select cast (EXP(d) as DECIMAL(6,3)) AS EXP FROM SYSFUN_MATH_TEST;
-
-select cast (LOG10(d) as DECIMAL(6,3)) AS LOG10 FROM SYSFUN_MATH_TEST;
-
-select cast (CEIL(d) as DECIMAL(6,3)) AS CEIL FROM SYSFUN_MATH_TEST;
-select cast (CEILING(d) as DECIMAL(6,3)) AS CEILING FROM SYSFUN_MATH_TEST;
-select cast (FLOOR(d) as DECIMAL(6,3)) AS FLOOR FROM SYSFUN_MATH_TEST;
-
 select cast (SYSFUN.ACOS(d) as DECIMAL(6,3)) AS SYSFUN_ACOS FROM SYSFUN_MATH_TEST;
 
 CREATE VIEW VSMT AS SELECT SIN(d) sd, PI() pi FROM SYSFUN_MATH_TEST;



Mime
View raw message