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 Fri, 04 Aug 2006 19:38:16 GMT
    [ 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

        

Mime
View raw message