[jira] [Resolved] (DERBY-6415) SYSCS_DIAG.SPACE_TABLE sample query to show all tables and indexes should include schema

["Kim Haase (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-6415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kim Haase resolved DERBY-6415.
------------------------------

          Resolution: Fixed
       Fix Version/s: 10.11.0.0
                      10.10.1.3
    Issue & fix info:   (was: Patch Available)

Thanks very much, Kathey!

Committed patch DERBY-6415.diff to documentation trunk at revision 1547837. 
Merged to 10.10 doc branch at revision 1547864.

> SYSCS_DIAG.SPACE_TABLE sample query to show all tables and indexes should include schema
> ----------------------------------------------------------------------------------------
>
>                 Key: DERBY-6415
>                 URL: https://issues.apache.org/jira/browse/DERBY-6415
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.10.1.1
>            Reporter: Kathey Marsden
>            Assignee: Kim Haase
>            Priority: Trivial
>             Fix For: 10.10.1.3, 10.11.0.0
>
>         Attachments: DERBY-6415.diff, rrefsyscsdiagspacetable.html
>
>
> It would be good if the sample query for SYSCS_DIAG.SPACE_TABLE  also showed the schema name as that will be required by SYSCS_UTIL.SYSCS_COMPRESS_TABLE  if the tables are compressed.
> The doc page as at:
> http://db.apache.org/derby/docs/10.10/ref/rrefsyscsdiagspacetable.html
> The query for all tables and indexes could be:
> SELECT sysschemas.schemaname,  T2.*
>     FROM
>         SYS.SYSTABLES systabs, SYS.SYSSCHEMAS sysschemas,
>         TABLE (SYSCS_DIAG.SPACE_TABLE()) AS T2
>     WHERE systabs.tabletype = 'T'
>     AND sysschemas.schemaid = systabs.schemaid
>     AND systabs.tableid = T2.tableid;



--
This message was sent by Atlassian JIRA
(v6.1#6144)