Subject 
[jira] Commented: (DERBY1548) Document builtin functions  ACOS, ASIN, ATAN, COS, SIN, TAN, PI, DEGREES, RADIANS, EXP, LN, LOG, LOG10, CEIL, CEILING, FLOOR 
[ http://issues.apache.org/jira/browse/DERBY1548?page=comments#action_12424245 ]
Daniel John Debrunner commented on DERBY1548:

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: DERBY1548
> URL: http://issues.apache.org/jira/browse/DERBY1548
> 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 builtin functions were added in DERBY475.
> They should be added to the reference guide's builtin 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
