db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3874) Document numeric function ATAN2(float1,float2)
Date Wed, 24 Sep 2008 14:58:44 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12634161#action_12634161
] 

Kim Haase commented on DERBY-3874:
----------------------------------

The following numeric functions, in addition to atan2, are listed in Section C.1 of the JDBC
spec but are not currently documented in the "JDBC escape syntax for fn keyword" topic:

cot
power
radians
rand
round
sign
truncate

Of these, Derby supports the following builtin versions:

COT
RADIANS
RAND
SIGN

(However, there seem to be no implementations of POWER, ROUND, or TRUNCATE, for whatever reason.)

I'm guessing we should put the four supported ones (cot, radians, rand, sign) into the JDBC
escape syntax topic -- does that make sense?

Derby's support for the other functions in this appendix (string, time and date, system, conversion)
is much spottier, apparently. The topic documents three string functions and two time/date
functions, although more are supported by Derby. Of the string functions, Derby appears to
support

char
lcase
length
ltrim
rtrim
ucase

Of the date/time functions, Derby appears to support 

curdate (CURRENT_DATE)
curtime (CURRENT_TIME)
hour
minute
month
second
year

Would it be legitimate to add these to the "JDBC escape syntax for fn keyword" topic? If so,
I'd better file a separate issue for these changes.


> Document numeric function ATAN2(float1,float2)
> ----------------------------------------------
>
>                 Key: DERBY-3874
>                 URL: https://issues.apache.org/jira/browse/DERBY-3874
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Documentation
>    Affects Versions: 10.5.0.0
>            Reporter: Kristian Waagan
>            Assignee: Kim Haase
>
> Document the numeric function ATAN2(float1,float2).
> Mentioned in the JDBC specification, appendix C.1.
> Implementation documented by the JavaDoc for StrictMath.atan2.
> According to the JDBC specification, table B-1, a JDBC float maps to a Java double.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message