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] Resolved: (DERBY-3894) Reference Manual: supported functions should be listed in JDBC escape syntax topic
Date Tue, 21 Oct 2008 14:07:44 GMT

     [ https://issues.apache.org/jira/browse/DERBY-3894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kim Haase resolved DERBY-3894.
------------------------------

       Resolution: Fixed
    Fix Version/s: 10.5.0.0
       Derby Info:   (was: [Patch Available])

Thanks again, Knut.

Committed patch DERBY-3894-2.diff to documentation trunk at revision 706632.

> Reference Manual: supported functions should be listed in JDBC escape syntax topic
> ----------------------------------------------------------------------------------
>
>                 Key: DERBY-3894
>                 URL: https://issues.apache.org/jira/browse/DERBY-3894
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.4.2.0
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>            Priority: Minor
>             Fix For: 10.5.0.0
>
>         Attachments: DERBY-3894-2.diff, DERBY-3894.diff, rrefjdbc88908.html, rrefjdbc88908.html
>
>
> The topic "JDBC escape syntax for fn keyword" (http://db.apache.org/derby/docs/dev/ref/rrefjdbc88908.html)
does not include all the functions listed in Appendix C of the JDBC specification that Derby
supports.
> The following numeric functions, listed in Section C.1, are implemented in Derby but
not listed in this topic:
> COT(float)
> RAND(integer)
> SIGN(number)
> Three numeric functions listed in Section C.1 are not yet implemented in Derby; they
should be added to this topic when they are. (See DERBY-3893.)
> A number of the string functions listed in Section C.2 are not implemented in Derby.
Of the ones that are, the following are not listed in the JDBC escape syntax topic:
> LCASE(string)
> LENGTH(string)
> LTRIM(string)
> RTRIM(string)
> UCASE(string)
> Some of the time and date functions listed in Section C.3 are not implemented in Derby.
Of the ones that are, only two (TIMESTAMPADD and TIMESTAMPDIFF) are listed in the JDBC escape
syntax topic. The following should be added:
> CURDATE()
> CURTIME()
> HOUR(time)
> MINUTE(time)
> MONTH(date)
> SECOND(time)
> YEAR(date)
> Two of the three system functions listed in Section C.4 are not implemented in Derby.
The one that is, USER(), is not listed in the JDBC escape syntax topic.
> The functions should be listed in groups by type of function, and the fonts should conform
with Derby documentation style.

-- 
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