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