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 "Kathey Marsden (JIRA)" <de...@db.apache.org> on 2006/04/13 02:36:59 UTC
[jira] Created: (DERBY-1209) It would be good to add an example to
the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
----------------------------------------------------------------------------------------------------------------
Key: DERBY-1209
URL: http://issues.apache.org/jira/browse/DERBY-1209
Project: Derby
Type: Improvement
Components: Documentation
Versions: 10.1.2.3, 10.2.0.0
Reporter: Kathey Marsden
Priority: Minor
Fix For: 10.2.0.0
It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation on how to check all tables:
http://db.apache.org/derby/docs/10.1/ref/rrefsyscschecktablefunc.html
e.g.
SELECT schemaname, tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname,
tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid =
t.schemaid;
--
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-1209) It would be good to add an example to
the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1209?page=all ]
Rick Hillegas updated DERBY-1209:
---------------------------------
Urgency: Low
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
> ----------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1209
> URL: http://issues.apache.org/jira/browse/DERBY-1209
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.0.0, 10.1.2.3
> Reporter: Kathey Marsden
> Priority: Minor
> Fix For: 10.2.0.0
>
>
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation on how to check all tables:
> http://db.apache.org/derby/docs/10.1/ref/rrefsyscschecktablefunc.html
> e.g.
> SELECT schemaname, tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname,
> tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid =
> t.schemaid;
--
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-1209) It would be good to add an example to
the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-1209:
----------------------------------
Derby Categories: [Newcomer]
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
> ----------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1209
> URL: https://issues.apache.org/jira/browse/DERBY-1209
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.1.3.1, 10.2.1.6
> Reporter: Kathey Marsden
> Priority: Minor
>
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation on how to check all tables:
> http://db.apache.org/derby/docs/10.1/ref/rrefsyscschecktablefunc.html
> e.g.
> SELECT schemaname, tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname,
> tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid =
> t.schemaid;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-1209) It would be good to add an example to
the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden resolved DERBY-1209.
-----------------------------------
Resolution: Fixed
Fix Version/s: 10.6.0.0
10.5.1.2
Check fix into 10.5 with revision 793647. I don't plan to backport further.
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
> ----------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1209
> URL: https://issues.apache.org/jira/browse/DERBY-1209
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.1.3.1, 10.2.1.6
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Priority: Minor
> Fix For: 10.5.1.2, 10.6.0.0
>
> Attachments: derby-1209_diff.txt, rrefsyscschecktablefunc.html
>
>
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation on how to check all tables:
> http://db.apache.org/derby/docs/10.1/ref/rrefsyscschecktablefunc.html
> e.g.
> SELECT schemaname, tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname,
> tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid =
> t.schemaid;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-1209) It would be good to add an example
to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all
tables
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1209?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12726232#action_12726232 ]
Kim Haase commented on DERBY-1209:
----------------------------------
The patch is just fine, Kathey -- thanks very much for picking this up. +1 to commit.
A lot of warnings and errors started appearing a couple years ago, I think -- they have no major effect on the output and no one has figured out why they occur. The "Unresolved id reference" errors have the effect of making the table links (they're always to tables, I think) not work in the PDF and html-single versions, though they work fine in the HTML frames versions. I filed JIRA issues for some of them.
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
> ----------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1209
> URL: https://issues.apache.org/jira/browse/DERBY-1209
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.1.3.1, 10.2.1.6
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Priority: Minor
> Attachments: derby-1209_diff.txt, rrefsyscschecktablefunc.html
>
>
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation on how to check all tables:
> http://db.apache.org/derby/docs/10.1/ref/rrefsyscschecktablefunc.html
> e.g.
> SELECT schemaname, tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname,
> tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid =
> t.schemaid;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1209) It would be good to add an example to
the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-1209:
----------------------------------
Attachment: derby-1209_diff.txt
rrefsyscschecktablefunc.html
Attached is a patch for this issue. It is very small, but I would appreciate review from someone familiar with the doc build to make sure I did it correctly as I haven't made a doc patch in a while.
I seemed to get a lot of warnings in my build e.g.
[fop] Jul 1, 2009 10:19:54 AM org.apache.fop.area.RenderPagesModel checkPreparedPages
[fop] WARNING: Page 193: Unresolved id reference "jdbc25312" found.
[fop] Jul 1, 2009 10:19:54 AM org.apache.fop.area.RenderPagesModel checkPreparedPages
[fop] WARNING: Page 193: Unresolved id reference "jdbc31241" found.
Is this normal?
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
> ----------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1209
> URL: https://issues.apache.org/jira/browse/DERBY-1209
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.1.3.1, 10.2.1.6
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Priority: Minor
> Attachments: derby-1209_diff.txt, rrefsyscschecktablefunc.html
>
>
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation on how to check all tables:
> http://db.apache.org/derby/docs/10.1/ref/rrefsyscschecktablefunc.html
> e.g.
> SELECT schemaname, tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname,
> tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid =
> t.schemaid;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1209) It would be good to add an example to
the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1209?page=all ]
Rick Hillegas updated DERBY-1209:
---------------------------------
Fix Version/s: 10.2.2.0
(was: 10.2.1.0)
Moving to 10.2.2.0.
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
> ----------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1209
> URL: http://issues.apache.org/jira/browse/DERBY-1209
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.0, 10.1.2.3
> Reporter: Kathey Marsden
> Priority: Minor
> Fix For: 10.2.2.0
>
>
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation on how to check all tables:
> http://db.apache.org/derby/docs/10.1/ref/rrefsyscschecktablefunc.html
> e.g.
> SELECT schemaname, tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname,
> tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid =
> t.schemaid;
--
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-1209) It would be good to add an example to
the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden reassigned DERBY-1209:
-------------------------------------
Assignee: Kathey Marsden
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
> ----------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1209
> URL: https://issues.apache.org/jira/browse/DERBY-1209
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.1.3.1, 10.2.1.6
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Priority: Minor
>
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation on how to check all tables:
> http://db.apache.org/derby/docs/10.1/ref/rrefsyscschecktablefunc.html
> e.g.
> SELECT schemaname, tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname,
> tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid =
> t.schemaid;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1209) It would be good to add an example to
the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-1209:
----------------------------------
Issue & fix info: [Newcomer, Patch Available] (was: [Newcomer])
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
> ----------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1209
> URL: https://issues.apache.org/jira/browse/DERBY-1209
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.1.3.1, 10.2.1.6
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Priority: Minor
> Attachments: derby-1209_diff.txt, rrefsyscschecktablefunc.html
>
>
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation on how to check all tables:
> http://db.apache.org/derby/docs/10.1/ref/rrefsyscschecktablefunc.html
> e.g.
> SELECT schemaname, tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname,
> tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid =
> t.schemaid;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1209) It would be good to add an example to
the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-1209:
----------------------------------
Urgency: Urgent (was: Low)
Marking urgent for 10.5.2. I plan to fix this.
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
> ----------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1209
> URL: https://issues.apache.org/jira/browse/DERBY-1209
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.1.3.1, 10.2.1.6
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Priority: Minor
> Attachments: derby-1209_diff.txt, rrefsyscschecktablefunc.html
>
>
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation on how to check all tables:
> http://db.apache.org/derby/docs/10.1/ref/rrefsyscschecktablefunc.html
> e.g.
> SELECT schemaname, tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname,
> tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid =
> t.schemaid;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1209) It would be good to add an example to
the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1209?page=all ]
Rick Hillegas updated DERBY-1209:
---------------------------------
Fix Version/s: 10.2.3.0
(was: 10.2.2.0)
Move to 10.2.3.0.
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables
> ----------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1209
> URL: http://issues.apache.org/jira/browse/DERBY-1209
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.6, 10.1.3.1
> Reporter: Kathey Marsden
> Priority: Minor
> Fix For: 10.2.3.0
>
>
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation on how to check all tables:
> http://db.apache.org/derby/docs/10.1/ref/rrefsyscschecktablefunc.html
> e.g.
> SELECT schemaname, tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname,
> tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid =
> t.schemaid;
--
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