[ http://issues.apache.org/jira/browse/DERBY1548?page=comments#action_12425833 ]
Daniel John Debrunner commented on DERBY1548:

Thanks Laura, some comments:
ACOS,ASIN  If the absolute value of the specified number is greater than 1, the result is
not a number.
Not a number is not valid in Derby, thus instead an exception is raised with SQL state
22003, value out of range
ATAN  If the specified number is zero (0), the result of this function is zero with the same
sign as the specified number.
Derby doesn't support negative zero, so remove 'with the same sign as the specified number.'
CEIL  If the specified number is an infinity, positive zero, or negative zero, the result
of these functions is the same as the specified number.
Derby doesn't support infinity, so replace with
If the specified number is zero the result of these functions is zero.
CEIL  If the specified number is less than zero but greater than 1.0, then the result of
these functions is negative zero.
remove 'negative' at the end
CEIL  The returned value is the smallest (closest to negative infinity) double floating point
value and is equal to a mathematical integer
That doesn't make sense, I think you need to add some reference into the passed in value.
COS  Remove 'If the specified number is an infinity, the result of this function is not a
number.'
REmove 'The returned value is the smallest (closest to negative infinity) double
value and is equal to a mathematical integer.'
think this is left over from CEIL
FLOOR  If the specified number is an infinity, positive zero, or negative zero, the result
of this function is the same as the specified number.
make same change as CEIL
FLOOR  The returned value is the largest (closest to positive infinity) double floating
point value and is equal to a mathematical integer.
That doesn't make sense, I think you need to add some reference into the passed in value.
LN,LOG,LOG10  Remove LOG10 that returns the log base 10, not base e
If the specified number is less than zero, the result of these functions is not a number.
throws the 22003 exception
Remove  if the specified number is positive infinity, the result of these functions is
positive infinity.
If the specified number is positive zero or negative zero, the result of these functions
is negative infinity.
replace "positive zero or negative zero" with zero.
throws 22003 exception
Add page for LOG10
SIN,TAN  Remove  If the specified number an infinity, the result of this function is not
a number.
If the specified number is zero (0), the result of this function is zero with the same
sign as the specified number.
remove 'with the same sign as the specified number.'
> 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: derby1548_ref.diff, derby1548_ref_html.zip, 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
