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 "Kim Haase (JIRA)" <ji...@apache.org> on 2012/10/09 21:38:03 UTC
[jira] [Closed] (DERBY-5822) Document the new SQL standard behavior
of the SPACE_TABLE vti
[ 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: 10.10.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Fix For: 10.8.2.3, 10.9.1.1, 10.10.0.0
>
> 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 database.
> 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