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] [Closed] (DERBY-5822) Document the new SQL standard behavior of the SPACE_TABLE vti
Date Tue, 09 Oct 2012 19:38:03 GMT

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

Kim Haase closed DERBY-5822.

Closing, since changes have appeared in Latest Alpha Manuals (as well as 10.9 and 10.8).
> Document the new SQL standard behavior of the SPACE_TABLE vti
> -------------------------------------------------------------
>                 Key: DERBY-5822
>                 URL: https://issues.apache.org/jira/browse/DERBY-5822
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions:
>            Reporter: Rick Hillegas
>            Assignee: Kim Haase
>             Fix For:,,
>         Attachments: DERBY-5822.diff, rrefsyscsdiagtables.html
> We will want to improve the Reference Guide section on the SPACE_TABLE vti after we commit
the derby-5554-02-aa-0argConstructor.diff attached to DERBY-5554. We will want to make the
following changes:
> 1) Describe the new TABLEID column which was added to SPACE_TABLE:
> Column Name: TABLEID
> Type: CHAR
> Length: 36
> Nullable: False
> Contents: The id of the table which the conglomerate belongs to.
> 2) Describe the additional no-arg constructor for this vti. There are now 3 ways to construct
this vti:
> i) No args. This is the new constructor which needs to be described. When the vti is
invoked with no arguments, it retrieves space information for all tables and indexes in the
> ii) One argument. This constructor is already described. If the vti is invoked with one
string argument, then that argument is the name of a table in the current schema.
> iii) Two arguments. This constructor is already described also. When the vti is invoked
with two string arguments, the first argument is a schema name and the second argument is
a table name.
> 3) Replace the first SPACE_TABLE example. That example uses Derby-specific syntax which
falls outside the SQL Standard. Showcasing non-standard syntax encourages users to try out
other non-standard syntax, giving rise to bugs like DERBY-5554. We should showcase the following
standard syntax instead:
> select t2.*
>     from
>         sys.systables systabs,
>         table (syscs_diag.space_table()) as t2
>     where systabs.tabletype = 'T'
>     and systabs.tableid = t2.tableid;

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

View raw message