You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Daniel John Debrunner (JIRA)" <de...@db.apache.org> on 2006/07/20 16:28:13 UTC
[jira] Created: (DERBY-1549) Document support for JDBC escape
functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP,
LOG, LOG10, CEILING, FLOOR
Document support for JDBC escape functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP, LOG, LOG10, CEILING, FLOOR
-----------------------------------------------------------------------------------------------------------------------------------
Key: DERBY-1549
URL: http://issues.apache.org/jira/browse/DERBY-1549
Project: Derby
Issue Type: Improvement
Components: Documentation
Affects Versions: 10.2.0.0
Reporter: Daniel John Debrunner
Document in the reference manual in the section "JDBC escape syntax for fn keyword"
--
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
[jira] Updated: (DERBY-1549) Document support for JDBC escape
functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP,
LOG, LOG10, CEILING, FLOOR
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1549?page=all ]
Laura Stewart updated DERBY-1549:
---------------------------------
Attachment: derby1549_ref2.diff
rrefjdbc88908_2.html
Attached the patch and html for this update.
Please review and commit.
> Document support for JDBC escape functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP, LOG, LOG10, CEILING, FLOOR
> -----------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1549
> URL: http://issues.apache.org/jira/browse/DERBY-1549
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.0.0
> Reporter: Daniel John Debrunner
> Assigned To: Laura Stewart
> Attachments: derby1549_ref.diff, derby1549_ref2.diff, rrefjdbc88908.html, rrefjdbc88908_2.html
>
>
> Document in the reference manual in the section "JDBC escape syntax for fn keyword"
--
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
[jira] Updated: (DERBY-1549) Document support for JDBC escape
functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP,
LOG, LOG10, CEILING, FLOOR
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1549?page=all ]
Laura Stewart updated DERBY-1549:
---------------------------------
Attachment: derby1549_ref.diff
rrefjdbc88908.html
This is the patch for Derby-1549. Only one file needed to be updated.
I added the new functions.
Additionally, I formatted the file using a definition list which makes finding the functions easier. I reorded the list alphabetically, cleaned up the indexes, and cleaned up some of the DITA tagging too.
Question:
On substring, the text says that "the index starts with 1". But I think that must be wrong...since the user can specify the startIndex parameter, it would make sense that they can specify a number other than 1. I suspect that the text should say that if the startIndex is not specified that the index starts with 1.
Can someone confirm this one way or the other?
FYI - some of the links are not resolving in the html file because they depend on the new files that I created for Derby-1548. Once that patch is committed, these links will resolve properly.
Thanks
Laura
> Document support for JDBC escape functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP, LOG, LOG10, CEILING, FLOOR
> -----------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1549
> URL: http://issues.apache.org/jira/browse/DERBY-1549
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.0.0
> Reporter: Daniel John Debrunner
> Assigned To: Laura Stewart
> Attachments: derby1549_ref.diff, rrefjdbc88908.html
>
>
> Document in the reference manual in the section "JDBC escape syntax for fn keyword"
--
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
[jira] Updated: (DERBY-1549) Document support for JDBC escape
functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP,
LOG, LOG10, CEILING, FLOOR
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1549?page=all ]
Jean T. Anderson updated DERBY-1549:
------------------------------------
Fix Version/s: 10.2.1.0
Changes were mega merged from trunk to 10.2 branch on Aug 18.
> Document support for JDBC escape functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP, LOG, LOG10, CEILING, FLOOR
> -----------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1549
> URL: http://issues.apache.org/jira/browse/DERBY-1549
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Laura Stewart
> Fix For: 10.2.1.0, 10.3.0.0
>
> Attachments: derby1549_ref.diff, derby1549_ref2.diff, rrefjdbc88908.html, rrefjdbc88908_2.html
>
>
> Document in the reference manual in the section "JDBC escape syntax for fn keyword"
--
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
[jira] Commented: (DERBY-1549) Document support for JDBC escape
functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP,
LOG, LOG10, CEILING, FLOOR
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1549?page=comments#action_12425620 ]
Daniel John Debrunner commented on DERBY-1549:
----------------------------------------------
The list of functions is correct, thanks for checking.
They are defined by the JDBC 3.0 specification, appendix C. Derby only supports a sub-set of the set defined by JDBC 3.
It's incorrect to say any builtin function can be used in the JDBC escape syntax, that would be non-standard behaviour.
I think the line in MOD should be removed, I guess it was meant to be at the end of the section, but it is not true. Good catch
> Document support for JDBC escape functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP, LOG, LOG10, CEILING, FLOOR
> -----------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1549
> URL: http://issues.apache.org/jira/browse/DERBY-1549
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.0.0
> Reporter: Daniel John Debrunner
>
> Document in the reference manual in the section "JDBC escape syntax for fn keyword"
--
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
[jira] Resolved: (DERBY-1549) Document support for JDBC escape
functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP,
LOG, LOG10, CEILING, FLOOR
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1549?page=all ]
Laura Stewart resolved DERBY-1549.
----------------------------------
Resolution: Fixed
Not closing until Doc updates are mega-merged for 10.2
> Document support for JDBC escape functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP, LOG, LOG10, CEILING, FLOOR
> -----------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1549
> URL: http://issues.apache.org/jira/browse/DERBY-1549
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Laura Stewart
> Fix For: 10.3.0.0
>
> Attachments: derby1549_ref.diff, derby1549_ref2.diff, rrefjdbc88908.html, rrefjdbc88908_2.html
>
>
> Document in the reference manual in the section "JDBC escape syntax for fn keyword"
--
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
[jira] Commented: (DERBY-1549) Document support for JDBC escape
functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP,
LOG, LOG10, CEILING, FLOOR
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1549?page=comments#action_12426270 ]
Laura Stewart commented on DERBY-1549:
--------------------------------------
Please review and answer the question that I posted on 8/3.
> Document support for JDBC escape functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP, LOG, LOG10, CEILING, FLOOR
> -----------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1549
> URL: http://issues.apache.org/jira/browse/DERBY-1549
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.0.0
> Reporter: Daniel John Debrunner
> Assigned To: Laura Stewart
> Attachments: derby1549_ref.diff, rrefjdbc88908.html
>
>
> Document in the reference manual in the section "JDBC escape syntax for fn keyword"
--
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
[jira] Commented: (DERBY-1549) Document support for JDBC escape
functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP,
LOG, LOG10, CEILING, FLOOR
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1549?page=comments#action_12426726 ]
Daniel John Debrunner commented on DERBY-1549:
----------------------------------------------
For the substring question, I think the text 'the index starts with 1' should be replaced with something like:
The index of the first character is 1.
> Document support for JDBC escape functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP, LOG, LOG10, CEILING, FLOOR
> -----------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1549
> URL: http://issues.apache.org/jira/browse/DERBY-1549
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.0.0
> Reporter: Daniel John Debrunner
> Assigned To: Laura Stewart
> Attachments: derby1549_ref.diff, rrefjdbc88908.html
>
>
> Document in the reference manual in the section "JDBC escape syntax for fn keyword"
--
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
[jira] Updated: (DERBY-1549) Document support for JDBC escape
functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP,
LOG, LOG10, CEILING, FLOOR
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1549?page=all ]
Daniel John Debrunner updated DERBY-1549:
-----------------------------------------
Fix Version/s: 10.3.0.0
Derby Info: (was: [Patch Available])
Patch applied with one minor change. The intro for log10 had 'log or log10', changed it to just 'log10'.
Committed revision 431991.
Thanks Laura.
> Document support for JDBC escape functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP, LOG, LOG10, CEILING, FLOOR
> -----------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1549
> URL: http://issues.apache.org/jira/browse/DERBY-1549
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.0.0
> Reporter: Daniel John Debrunner
> Assigned To: Laura Stewart
> Fix For: 10.3.0.0
>
> Attachments: derby1549_ref.diff, derby1549_ref2.diff, rrefjdbc88908.html, rrefjdbc88908_2.html
>
>
> Document in the reference manual in the section "JDBC escape syntax for fn keyword"
--
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
[jira] Commented: (DERBY-1549) Document support for JDBC escape
functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP,
LOG, LOG10, CEILING, FLOOR
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1549?page=comments#action_12425619 ]
Laura Stewart commented on DERBY-1549:
--------------------------------------
This list is slightly different than the list of functions in Derby-1548. Missing from this list are LN and CEIL. Should they be added as escape functions as well?
Also, for the escape function section in the Reference Manual, were you expecting to list *each* of the new functions in this section.. similar to the way that ABS is documented? Or is it appropriate to indicate that any standard built-in function can be used in JDBC escape syntax. Only a handful of the built-in functions are shown in that section.
Finally, as you look at that section, look at MOD. At the end of MOD there is a note that says
"Note: Any Derby built-in function is allowed in this syntax, not just those listed in this section."
Seems to me that this note belongs at the beginning of the section (if it applies to all of the functions) or
if needs to have some further clarification if it somehow only applies to MOD. Please advise.
> Document support for JDBC escape functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP, LOG, LOG10, CEILING, FLOOR
> -----------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1549
> URL: http://issues.apache.org/jira/browse/DERBY-1549
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.0.0
> Reporter: Daniel John Debrunner
>
> Document in the reference manual in the section "JDBC escape syntax for fn keyword"
--
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
[jira] Commented: (DERBY-1549) Document support for JDBC escape
functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP,
LOG, LOG10, CEILING, FLOOR
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1549?page=comments#action_12425624 ]
Laura Stewart commented on DERBY-1549:
--------------------------------------
Okay, glad that I confirmed the list, and I will remove the note under MOD.
As for documenting the new functions, I assume that they should look similar to ABS, since there isn't any further info here or in Derby-592 on what else should be documented. For example:
acos (
number
)
Arc cosine of a number. The escape syntax {fn acos(number)} is equivalent to the built-in syntax ACOS(number). For more details see the ACOS function.
> Document support for JDBC escape functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP, LOG, LOG10, CEILING, FLOOR
> -----------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1549
> URL: http://issues.apache.org/jira/browse/DERBY-1549
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.0.0
> Reporter: Daniel John Debrunner
>
> Document in the reference manual in the section "JDBC escape syntax for fn keyword"
--
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
[jira] Assigned: (DERBY-1549) Document support for JDBC escape
functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP,
LOG, LOG10, CEILING, FLOOR
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1549?page=all ]
Laura Stewart reassigned DERBY-1549:
------------------------------------
Assignee: Laura Stewart
> Document support for JDBC escape functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP, LOG, LOG10, CEILING, FLOOR
> -----------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1549
> URL: http://issues.apache.org/jira/browse/DERBY-1549
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.0.0
> Reporter: Daniel John Debrunner
> Assigned To: Laura Stewart
>
> Document in the reference manual in the section "JDBC escape syntax for fn keyword"
--
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
[jira] Updated: (DERBY-1549) Document support for JDBC escape
functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP,
LOG, LOG10, CEILING, FLOOR
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1549?page=all ]
Daniel John Debrunner updated DERBY-1549:
-----------------------------------------
Derby Info: [Patch Available]
> Document support for JDBC escape functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP, LOG, LOG10, CEILING, FLOOR
> -----------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1549
> URL: http://issues.apache.org/jira/browse/DERBY-1549
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.0.0
> Reporter: Daniel John Debrunner
> Assigned To: Laura Stewart
> Attachments: derby1549_ref.diff, derby1549_ref2.diff, rrefjdbc88908.html, rrefjdbc88908_2.html
>
>
> Document in the reference manual in the section "JDBC escape syntax for fn keyword"
--
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
[jira] Closed: (DERBY-1549) Document support for JDBC escape
functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP,
LOG, LOG10, CEILING, FLOOR
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1549?page=all ]
Laura Stewart closed DERBY-1549.
--------------------------------
Closing this issue because Rick has already merged these patches into the current trunk.
> Document support for JDBC escape functions: ACOS, ASIN, ATAN, COS, SIN, TAN, PI , DEGREES, RADIANS, EXP, LOG, LOG10, CEILING, FLOOR
> -----------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1549
> URL: http://issues.apache.org/jira/browse/DERBY-1549
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Laura Stewart
> Fix For: 10.2.1.0, 10.3.0.0
>
> Attachments: derby1549_ref.diff, derby1549_ref2.diff, rrefjdbc88908.html, rrefjdbc88908_2.html
>
>
> Document in the reference manual in the section "JDBC escape syntax for fn keyword"
--
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