db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4051) The javadoc for SpaceTable refers to an alias that doesn't seem to work
Date Mon, 09 Feb 2009 14:01:01 GMT

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

Knut Anders Hatlen commented on DERBY-4051:
-------------------------------------------

I think we should remove the mentioning of the alias and add an example with SYSCS_DIAG.SPACE_TABLE
(which is the preferred way to invoke this VTI, isn't it?).

SELECT * FROM TABLE(SYSCS_DIAG.SPACE_TABLE('MYTABLE')) T;
SELECT * FROM TABLE(SYSCS_DIAG.SPACE_TABLE('MYSCHEMA', 'MYTABLE')) T;

> The javadoc for SpaceTable refers to an alias that doesn't seem to work
> -----------------------------------------------------------------------
>
>                 Key: DERBY-4051
>                 URL: https://issues.apache.org/jira/browse/DERBY-4051
>             Project: Derby
>          Issue Type: Bug
>          Components: Javadoc
>    Affects Versions: 10.5.0.0
>            Reporter: Kathey Marsden
>            Priority: Trivial
>
> The javadoc for the SpaceTable vti refers to an alias that doesn't seem to work:
> http://db.apache.org/derby/javadoc/engine/org/apache/derby/diag/SpaceTable.html
> "Alternatively, the table can be invoked through the system alias SpaceTable
>  select * from new SPACETABLE('MYTABLE') t; "

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