db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [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
Date Wed, 01 Jul 2009 21:37:47 GMT

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


Mime
View raw message