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