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-5822) Document the new SQL standard behavior of the SPACE_TABLE vti
Date Thu, 28 Jun 2012 19:20:44 GMT

    [ https://issues.apache.org/jira/browse/DERBY-5822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13403389#comment-13403389

Kim Haase commented on DERBY-5822:

Thanks, Rick! Committed patch DERBY-5822.diff to documentation trunk at revision 1355117.

It appears that the fix for DERBY-5554 has been ported to the 10.9 and 10.8 branches, but
the issue has not yet been resolved. Is it okay to port the doc fix to the branches as well?

> 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
>         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: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message