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/02/01 05:05:39 UTC
[jira] Created: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
------------------------------------------------------------------------------------------
Key: DERBY-908
URL: http://issues.apache.org/jira/browse/DERBY-908
Project: Derby
Type: Bug
Components: Documentation
Versions: 10.1.1.0
Reporter: Daniel John Debrunner
Priority: Minor
Fix For: 10.2.0.0
All these functions in the reference manual have a sentence like:
(this is from DAY)
If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
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-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-908?page=all ]
Rick Hillegas updated DERBY-908:
--------------------------------
Urgency: Low
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: http://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Priority: Minor
> Fix For: 10.2.0.0
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
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-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-908:
----------------------------------
Attachment: rrefyearfunc.html
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, rrefdayfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and
DAY functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton reassigned DERBY-908:
-------------------------------------
Assignee: Bryan Pendleton
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and
DAY functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12475676 ]
Bryan Pendleton commented on DERBY-908:
---------------------------------------
I see a couple problems with the example, but I'm not sure I agree that it's clearly an example of using a duration.
The two problems I see in the example are:
1) It says "select all classes" where I think it should say "select all rows"
2) Since the values of the MINUTE function range from 0 to 59, the values are *always* less than 60. To find rows which are not on a full hour, I think the query should look for MINUTE() > 0.
So I suggest the following example:
Select all rows from the "flights" table where the "departure time" is between 6:00 and 6:30 AM:
SELECT * FROM flights WHERE HOUR(departure_time) = 6 AND MINUTE(departure_time) < 31;
Does that example make more sense?
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, docChanges_v4.diff, rrefdayfunc.html, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-908:
----------------------------------
Attachment: rrefhourfunc.html
rrefdayfunc.html
docChanges.diff
Attached is a proposed patch to the doc to eliminate the text about duration arguments, since Derby doesn't support that. Also attached are the 8 resulting html pages from the reference guide. Please let me know what you think.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, rrefdayfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and
DAY functions have incorrect information on durations.
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12472875 ]
Kim Haase commented on DERBY-908:
---------------------------------
Would it make sense at this point to --
1) Give the examples an "Example" header?
2) Indent the second line (WHERE clause) of the two-line examples, or put the clause on the same line as SELECT?
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and
DAY functions have incorrect information on durations.
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12472457 ]
Laura Stewart commented on DERBY-908:
-------------------------------------
Looks really good to me. Thanks for making that change.
Now all we need is Dan to review :-)
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and
DAY functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton resolved DERBY-908.
-----------------------------------
Resolution: Fixed
Derby Info: (was: [Patch Available])
Thank you for committing! Marked the issue resolved.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, docChanges_v4.diff, minuteExample.diff, rrefdayfunc.html, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-908:
----------------------------------
Attachment: rrefminutefunc.html
minuteExample.diff
It occurs to me that the "classes" example was meant to refer to an academic calendar example. For example the class schedule for the school might indicate that the first class period of the day started at 8:10 AM and ended at 9:05 AM. So the use of "classes" rather than "rows" was probably intentional.
But I think the "flights" example is good too, and if it is clearer to readers, that's better.
Attached is minuteExample.diff, and rrefminutefunc.html. This patch changes the example on the MINUTE page of the reference manual to correct the error of the previous example, which was that the result of the function is *always* less than 60, since the function's values range from 0 to 59.
Please let me know if you think the new example is clear.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, docChanges_v4.diff, minuteExample.diff, rrefdayfunc.html, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and
DAY functions have incorrect information on durations.
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12476145 ]
Tomohito Nakayama commented on DERBY-908:
-----------------------------------------
I committed.
Sending src/ref/rrefminutefunc.dita
Transmitting file data .
Committed revision 512226.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, docChanges_v4.diff, minuteExample.diff, rrefdayfunc.html, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-908:
----------------------------------
Attachment: rrefyearfunc.html
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, docChanges_v2.diff, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-908:
----------------------------------
Attachment: rrefyearfunc.html
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, docChanges_v4.diff, rrefdayfunc.html, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and
DAY functions have incorrect information on durations.
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12472383 ]
Laura Stewart commented on DERBY-908:
-------------------------------------
There is a sentence in each of these functions which repeats some of the text in another sentence. This duplicat text should be removed.
ORIGINAL TEXT
The DAY function returns the day part of a value.
The argument must be a date, timestamp, or a valid character string representation of a date or timestamp that is not a CLOB, LONG VARCHAR, or XML value. The result of the function is a large integer. If the argument can be null, the result can be null; if the argument is null, the result is the null value. If the argument is a date, timestamp, or valid string representation of a date or timestamp, the result is the day part of the value, which is an integer between 1 and 31.
PROPOSED REWORDING
The DAY function returns the day part of a value.
The argument must be a date, timestamp, or a valid character string representation of a date or timestamp that is not a CLOB, LONG VARCHAR, or XML value. The result of this function is a integer between 1 and 31. If the argument can be null, the result can be null. If the argument is null, the result is the null value.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, rrefdayfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-908:
----------------------------------
Attachment: rrefsecondfunc.html
rrefmonthfunc.html
rrefminutefunc.html
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, docChanges_v2.diff, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and
DAY functions have incorrect information on durations.
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12475602 ]
Tomohito Nakayama commented on DERBY-908:
-----------------------------------------
I think next example in minutes page is for duration which is not supported.
http://db.apache.org/derby/docs/dev/ref/rrefminutefunc.html
>Select all classes that do not end on a full hour:
>
>SELECT * FROM table1 WHERE MINUTE(ending) < 60;
I think this should be corrected in this issue.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, docChanges_v4.diff, rrefdayfunc.html, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and
DAY functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12472755 ]
Bryan Pendleton commented on DERBY-908:
---------------------------------------
I'll commit this later today if there are no additional comments.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and
DAY functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton resolved DERBY-908.
-----------------------------------
Resolution: Fixed
Fix Version/s: 10.3.0.0
Derby Info: (was: [Patch Available])
Thanks Kim. I made those corrections to the pages for Second and Minute, and re-built to confirm. I think these pages are much better now; thanks to all the reviewers for comments and suggestions!
Committed the updated pages to the docs trunk as revision 507301.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, docChanges_v4.diff, rrefdayfunc.html, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-908:
----------------------------------
Attachment: rrefhourfunc.html
rrefdayfunc.html
docChanges_v4.diff
I think the HTML looks better with the example titles and with the code blocks reformatted to avoid unnecessary line splits.
Please have a look at the latest attached HTML pages.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, docChanges_v4.diff, rrefdayfunc.html, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-908:
----------------------------------
Attachment: rrefsecondfunc.html
rrefmonthfunc.html
rrefminutefunc.html
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, docChanges_v4.diff, rrefdayfunc.html, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-908:
----------------------------------
Attachment: rrefhourfunc.html
rrefdayfunc.html
docChanges_v2.diff
Hi Laura, thanks very much for the review! I think your proposed rewording is clearer and simpler. Attached is docChanges_v2.diff, and updated versions of the HTML output with the diff.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, docChanges_v2.diff, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-908:
----------------------------------
Attachment: rrefsecondfunc.html
rrefmonthfunc.html
rrefminutefunc.html
Duh. Of course there are *6* html pages, not *8* pages, attached.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, rrefdayfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-908?page=all ]
Rick Hillegas updated DERBY-908:
--------------------------------
Fix Version/s: 10.2.2.0
(was: 10.2.1.0)
Moving to 10.2.2.0.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: http://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Priority: Minor
> Fix For: 10.2.2.0
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
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-908) YEAR,SECOND,MONTH, MINUTE, HOUR and
DAY functions have incorrect information on durations.
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12472424 ]
Laura Stewart commented on DERBY-908:
-------------------------------------
Bryan - These updates look really good. One minor thing, if you have time to fix it...
In the Seconds function (rrefsecondfunc.html) Example. I think it should be reworded to:
The RECEIVED column contains a timestamp that has an internal value equivalent to 2005-12-25-17.12.30.000000. To return only the seconds part of the timestamp, use the following syntax:
If you can't make this change, let me know and I'll add a new JIRA issue for this.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, docChanges_v2.diff, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and
DAY functions have incorrect information on durations.
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12472894 ]
Kim Haase commented on DERBY-908:
---------------------------------
Thanks, Bryan! Yes, those look good. There are a couple of small glitches -- I don't know if they matter that much.
rrefminutefunc has a space indent at the beginning of the example, unlike the others.
In rrefsecondfunc, the syntax and example are not in bold, unlike those in the other files.
This sort of thing could probably go on forever, though. Feel free to stop if you want!
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, docChanges_v4.diff, rrefdayfunc.html, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-908:
----------------------------------
Derby Info: [Patch Available]
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, docChanges_v4.diff, minuteExample.diff, rrefdayfunc.html, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-908:
----------------------------------
Derby Info: [Patch Available]
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, rrefdayfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-908?page=all ]
Rick Hillegas updated DERBY-908:
--------------------------------
Fix Version/s: 10.2.3.0
(was: 10.2.2.0)
Move to 10.2.3.0.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: http://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Priority: Minor
> Fix For: 10.2.3.0
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
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-908) YEAR,SECOND,MONTH, MINUTE, HOUR and
DAY functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12472878 ]
Bryan Pendleton commented on DERBY-908:
---------------------------------------
Hi Kim, those sound like fine ideas to me.
What does that translate to in DITA terms? Is it as simple as:
1) Add <title>Example</title> to each of the <example> blocks,
2) Remove the extraneous newlines from the DITA source inside the <codeblock> tags?
I'll give those changes a try, and we can see what the output looks like.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY
functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-908:
----------------------------------
Attachment: rrefsecondfunc.html
docChanges_v3.diff
Thanks Laura, that revised example is much clearer now. Attached is docChanges_v3.diff and rrefsecondfunc.html.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and
DAY functions have incorrect information on durations.
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12475702 ]
Tomohito Nakayama commented on DERBY-908:
-----------------------------------------
I think your new example is better than current one.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, docChanges_v4.diff, rrefdayfunc.html, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Reopened: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and
DAY functions have incorrect information on durations.
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton reopened DERBY-908:
-----------------------------------
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff, docChanges_v4.diff, rrefdayfunc.html, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.