[
http://issues.apache.org/jira/browse/DERBY-1548?page=comments#action_12425833 ]
Daniel John Debrunner commented on DERBY-1548:
----------------------------------------------
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: 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: derby1548_ref.diff, derby1548_ref_html.zip,
> 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
