db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1548) Document builtin functions - ACOS, ASIN, ATAN, COS, SIN, TAN, PI, DEGREES, RADIANS, EXP, LN, LOG, LOG10, CEIL, CEILING, FLOOR
Date Sat, 29 Jul 2006 00:54:14 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1548?page=comments#action_12424245 ] 
            
Daniel John Debrunner commented on DERBY-1548:
----------------------------------------------

Thanks for the descriptions Laura.
The functions all correspond to methods in the java class java.lang.StrictMath, you may want
to double cheeck the descriptions there
and compare yours to them. 

One general comment is that the return type for all of the functions is DOUBLE PRECISION.
(and as above, they return NULL if they are passed NULL)



CEIL & CEILING are the same in Derby. Your description for CEIL is the closest match.

FLOOR - corresponds to single argument method - java.lang.StrictMath.floor(double)
Syntax=FLOOR(number)

LOG - is the same as LN

PI - You wrote:
   "The PI function returns the approximate number 3.14159265358979, the mathematical constant
pi, accurate to 15 digits."
   Not sure where you got the 15 digits figure from, I don't see that in the jdk 142 javadoc
for java.lang.StrictMath.PI, maybe it's in a newer version?
    Can you provide a reference?

SIN - I would either remove this sentence:
   "If your number is in degrees, multiply the number by PI()/180 to convert the number to
radians. "
  or replace it with a recommendation to use the RADIANS function.

TAN - the angle is passed in radians, not degrees











> Document builtin functions - ACOS, ASIN, ATAN, COS, SIN, TAN, PI, DEGREES, RADIANS, EXP,
LN, LOG, LOG10, CEIL, CEILING, FLOOR
> -----------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1548
>                 URL: http://issues.apache.org/jira/browse/DERBY-1548
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.2.0.0
>            Reporter: Daniel John Debrunner
>         Assigned To: Laura Stewart
>         Attachments: MathFunctions.txt
>
>
> These built-in functions were added in DERBY-475.
> They should be added to the reference guide's built-in function section.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message