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 dj...@apache.org on 2006/11/15 22:54:40 UTC
svn commit: r475446 - in
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests:
master/functions.out tests/lang/functions.sql
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;