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 "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2008/04/15 22:06:22 UTC
[jira] Created: (DERBY-3622) SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE
needs a better description in the reference manual
SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the reference manual
-----------------------------------------------------------------------------------------
Key: DERBY-3622
URL: https://issues.apache.org/jira/browse/DERBY-3622
Project: Derby
Issue Type: Improvement
Components: Documentation
Affects Versions: 10.4.1.1
Reporter: Knut Anders Hatlen
Priority: Minor
Currently, the reference manual describes the SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure like this[1]:
> The SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE stored procedure is a useful diagnostic tool.
The description should state what the procedure does, not only that it's useful. (I'm not even sure it's true that it is a diagnostic tool.)
[1] http://db.apache.org/derby/docs/dev/ref/rrefemptystmtcache.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-3622)
SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the
reference manual
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase resolved DERBY-3622.
------------------------------
Resolution: Fixed
Fix Version/s: 10.5.0.0
10.4.1.4
Derby Info: (was: [Patch Available])
Resolving, since there have been no further comments.
> SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the reference manual
> -----------------------------------------------------------------------------------------
>
> Key: DERBY-3622
> URL: https://issues.apache.org/jira/browse/DERBY-3622
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.1.3
> Reporter: Knut Anders Hatlen
> Assignee: Kim Haase
> Priority: Minor
> Fix For: 10.4.1.4, 10.5.0.0
>
> Attachments: DERBY-3622-2.diff, DERBY-3622.diff, rrefemptystmtcache.html, rrefemptystmtcache.html
>
>
> Currently, the reference manual describes the SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure like this[1]:
> > The SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE stored procedure is a useful diagnostic tool.
> The description should state what the procedure does, not only that it's useful. (I'm not even sure it's true that it is a diagnostic tool.)
> [1] http://db.apache.org/derby/docs/dev/ref/rrefemptystmtcache.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3622)
SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the
reference manual
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12590604#action_12590604 ]
Kim Haase commented on DERBY-3622:
----------------------------------
Committed DERBY-3622-2.diff to trunk at revision 649681.
Merged to 10.4 docs branch at revision 649683.
Leaving open, though, in case further changes are needed.
> SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the reference manual
> -----------------------------------------------------------------------------------------
>
> Key: DERBY-3622
> URL: https://issues.apache.org/jira/browse/DERBY-3622
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.1.1
> Reporter: Knut Anders Hatlen
> Assignee: Kim Haase
> Priority: Minor
> Attachments: DERBY-3622-2.diff, DERBY-3622.diff, rrefemptystmtcache.html, rrefemptystmtcache.html
>
>
> Currently, the reference manual describes the SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure like this[1]:
> > The SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE stored procedure is a useful diagnostic tool.
> The description should state what the procedure does, not only that it's useful. (I'm not even sure it's true that it is a diagnostic tool.)
> [1] http://db.apache.org/derby/docs/dev/ref/rrefemptystmtcache.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3622) SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE
needs a better description in the reference manual
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-3622:
-----------------------------
Attachment: rrefemptystmtcache.html
DERBY-3622-2.diff
Thanks for that information and pointer, Knut Anders. I have added the information in the javadoc to the topic -- if we say that the cache is not guaranteed to be empty, I think people will want to know why. If this seems like too much information, though, please let me know. The new diffs file is DERBY-3622-2.diff, and I've added the new version of rrefemptystmtcache.html also.
> SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the reference manual
> -----------------------------------------------------------------------------------------
>
> Key: DERBY-3622
> URL: https://issues.apache.org/jira/browse/DERBY-3622
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.1.1
> Reporter: Knut Anders Hatlen
> Assignee: Kim Haase
> Priority: Minor
> Attachments: DERBY-3622-2.diff, DERBY-3622.diff, rrefemptystmtcache.html, rrefemptystmtcache.html
>
>
> Currently, the reference manual describes the SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure like this[1]:
> > The SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE stored procedure is a useful diagnostic tool.
> The description should state what the procedure does, not only that it's useful. (I'm not even sure it's true that it is a diagnostic tool.)
> [1] http://db.apache.org/derby/docs/dev/ref/rrefemptystmtcache.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3622)
SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the
reference manual
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12590585#action_12590585 ]
Knut Anders Hatlen commented on DERBY-3622:
-------------------------------------------
Thanks Kim, the latest patch looks very good. +1 to commit.
> SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the reference manual
> -----------------------------------------------------------------------------------------
>
> Key: DERBY-3622
> URL: https://issues.apache.org/jira/browse/DERBY-3622
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.1.1
> Reporter: Knut Anders Hatlen
> Assignee: Kim Haase
> Priority: Minor
> Attachments: DERBY-3622-2.diff, DERBY-3622.diff, rrefemptystmtcache.html, rrefemptystmtcache.html
>
>
> Currently, the reference manual describes the SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure like this[1]:
> > The SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE stored procedure is a useful diagnostic tool.
> The description should state what the procedure does, not only that it's useful. (I'm not even sure it's true that it is a diagnostic tool.)
> [1] http://db.apache.org/derby/docs/dev/ref/rrefemptystmtcache.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3622) SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE
needs a better description in the reference manual
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-3622:
-----------------------------
Derby Info: [Patch Available]
> SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the reference manual
> -----------------------------------------------------------------------------------------
>
> Key: DERBY-3622
> URL: https://issues.apache.org/jira/browse/DERBY-3622
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.1.1
> Reporter: Knut Anders Hatlen
> Assignee: Kim Haase
> Priority: Minor
> Attachments: DERBY-3622-2.diff, DERBY-3622.diff, rrefemptystmtcache.html, rrefemptystmtcache.html
>
>
> Currently, the reference manual describes the SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure like this[1]:
> > The SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE stored procedure is a useful diagnostic tool.
> The description should state what the procedure does, not only that it's useful. (I'm not even sure it's true that it is a diagnostic tool.)
> [1] http://db.apache.org/derby/docs/dev/ref/rrefemptystmtcache.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3622) SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE
needs a better description in the reference manual
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-3622:
-----------------------------
Attachment: DERBY-3622.diff
rrefemptystmtcache.html
Attaching new version of topic with revised description and examples. The description comes from DERBY-2914. Is it correct and sufficient?
> SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the reference manual
> -----------------------------------------------------------------------------------------
>
> Key: DERBY-3622
> URL: https://issues.apache.org/jira/browse/DERBY-3622
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.1.1
> Reporter: Knut Anders Hatlen
> Assignee: Kim Haase
> Priority: Minor
> Attachments: DERBY-3622.diff, rrefemptystmtcache.html
>
>
> Currently, the reference manual describes the SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure like this[1]:
> > The SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE stored procedure is a useful diagnostic tool.
> The description should state what the procedure does, not only that it's useful. (I'm not even sure it's true that it is a diagnostic tool.)
> [1] http://db.apache.org/derby/docs/dev/ref/rrefemptystmtcache.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3622)
SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the
reference manual
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12590602#action_12590602 ]
Kim Haase commented on DERBY-3622:
----------------------------------
Well, it's in the javadoc pointed to in Knut Anders' comment from yesterday. Is the javadoc incorrect? I jumped the gun a bit, I guess, and am in the process of committing and merging, but I can certainly make corrections if necessary.
> SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the reference manual
> -----------------------------------------------------------------------------------------
>
> Key: DERBY-3622
> URL: https://issues.apache.org/jira/browse/DERBY-3622
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.1.1
> Reporter: Knut Anders Hatlen
> Assignee: Kim Haase
> Priority: Minor
> Attachments: DERBY-3622-2.diff, DERBY-3622.diff, rrefemptystmtcache.html, rrefemptystmtcache.html
>
>
> Currently, the reference manual describes the SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure like this[1]:
> > The SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE stored procedure is a useful diagnostic tool.
> The description should state what the procedure does, not only that it's useful. (I'm not even sure it's true that it is a diagnostic tool.)
> [1] http://db.apache.org/derby/docs/dev/ref/rrefemptystmtcache.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3622)
SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the
reference manual
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12590201#action_12590201 ]
Knut Anders Hatlen commented on DERBY-3622:
-------------------------------------------
Thanks for picking this up, Kim. I think the description is correct. The javadoc[1] for this procedure says that it is not guaranteed that the cache is empty after the call. Is it worth mentioning that? By the way, if it's not guaranteed to be empty, "all compiled statements" is probably a little too strong. Perhaps it is more precise if we say "The SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE stored procedure removes as many compiled statements (plans) as possible from the database-wide statement cache."
[1] http://db.apache.org/derby/javadoc/engine/org/apache/derby/catalog/SystemProcedures.html#SYSCS_EMPTY_STATEMENT_CACHE()
> SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the reference manual
> -----------------------------------------------------------------------------------------
>
> Key: DERBY-3622
> URL: https://issues.apache.org/jira/browse/DERBY-3622
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.1.1
> Reporter: Knut Anders Hatlen
> Assignee: Kim Haase
> Priority: Minor
> Attachments: DERBY-3622.diff, rrefemptystmtcache.html
>
>
> Currently, the reference manual describes the SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure like this[1]:
> > The SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE stored procedure is a useful diagnostic tool.
> The description should state what the procedure does, not only that it's useful. (I'm not even sure it's true that it is a diagnostic tool.)
> [1] http://db.apache.org/derby/docs/dev/ref/rrefemptystmtcache.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3622)
SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the
reference manual
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12589713#action_12589713 ]
Kim Haase commented on DERBY-3622:
----------------------------------
Good catch, Knut Anders. This procedure was documented as part of DERBY-2914, but somehow it seems to have gotten lost in the shuffle -- a couple of other procedures got documented at the same time. There is information in the comments on that issue.
> SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the reference manual
> -----------------------------------------------------------------------------------------
>
> Key: DERBY-3622
> URL: https://issues.apache.org/jira/browse/DERBY-3622
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.1.1
> Reporter: Knut Anders Hatlen
> Priority: Minor
>
> Currently, the reference manual describes the SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure like this[1]:
> > The SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE stored procedure is a useful diagnostic tool.
> The description should state what the procedure does, not only that it's useful. (I'm not even sure it's true that it is a diagnostic tool.)
> [1] http://db.apache.org/derby/docs/dev/ref/rrefemptystmtcache.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3622)
SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the
reference manual
Posted by "Daniel John Debrunner (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12590597#action_12590597 ]
Daniel John Debrunner commented on DERBY-3622:
----------------------------------------------
Where does this come from:
"The procedure does not remove statements related to currently executing queries"
I'm not sure that's true, what's the justification?
> SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the reference manual
> -----------------------------------------------------------------------------------------
>
> Key: DERBY-3622
> URL: https://issues.apache.org/jira/browse/DERBY-3622
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.1.1
> Reporter: Knut Anders Hatlen
> Assignee: Kim Haase
> Priority: Minor
> Attachments: DERBY-3622-2.diff, DERBY-3622.diff, rrefemptystmtcache.html, rrefemptystmtcache.html
>
>
> Currently, the reference manual describes the SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure like this[1]:
> > The SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE stored procedure is a useful diagnostic tool.
> The description should state what the procedure does, not only that it's useful. (I'm not even sure it's true that it is a diagnostic tool.)
> [1] http://db.apache.org/derby/docs/dev/ref/rrefemptystmtcache.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (DERBY-3622)
SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the
reference manual
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase reassigned DERBY-3622:
--------------------------------
Assignee: Kim Haase
> SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the reference manual
> -----------------------------------------------------------------------------------------
>
> Key: DERBY-3622
> URL: https://issues.apache.org/jira/browse/DERBY-3622
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.1.1
> Reporter: Knut Anders Hatlen
> Assignee: Kim Haase
> Priority: Minor
>
> Currently, the reference manual describes the SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure like this[1]:
> > The SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE stored procedure is a useful diagnostic tool.
> The description should state what the procedure does, not only that it's useful. (I'm not even sure it's true that it is a diagnostic tool.)
> [1] http://db.apache.org/derby/docs/dev/ref/rrefemptystmtcache.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.