You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by km...@apache.org on 2011/02/07 18:06:26 UTC
svn commit: r1068015 -
/db/derby/code/branches/10.5/java/engine/org/apache/derby/diag/SpaceTable.java
Author: kmarsden
Date: Mon Feb 7 17:06:26 2011
New Revision: 1068015
URL: http://svn.apache.org/viewvc?rev=1068015&view=rev
Log:
DERBY-4051 The javadoc for SpaceTable refers to an alias that doesn't seem to work
contributed by Tiago Espinha (tiago dot derby at espinhas dot net)
Modified:
db/derby/code/branches/10.5/java/engine/org/apache/derby/diag/SpaceTable.java
Modified: db/derby/code/branches/10.5/java/engine/org/apache/derby/diag/SpaceTable.java
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.5/java/engine/org/apache/derby/diag/SpaceTable.java?rev=1068015&r1=1068014&r2=1068015&view=diff
==============================================================================
--- db/derby/code/branches/10.5/java/engine/org/apache/derby/diag/SpaceTable.java (original)
+++ db/derby/code/branches/10.5/java/engine/org/apache/derby/diag/SpaceTable.java Mon Feb 7 17:06:26 2011
@@ -53,11 +53,9 @@ import org.apache.derby.vti.VTIEnvironme
This virtual table can be invoked by calling it
directly, and supplying the schema name and table name as arguments.
- <PRE> select * from new org.apache.derby.diag.SpaceTable('MYSCHEMA','MYTABLE') t; </PRE>
+ <PRE> SELECT * FROM TABLE(SYSCS_DIAG.SPACE_TABLE('MYSCHEMA', 'MYTABLE')) T; </PRE>
If the schema name is not supplied, the default schema is used.
- <PRE> select * from new org.apache.derby.diag.SpaceTable('MYTABLE') t; </PRE>
- Alternatively, the table can be invoked through the system alias SpaceTable
- <PRE> select * from new SPACETABLE('MYTABLE') t; </PRE>
+ <PRE> SELECT * FROM TABLE(SYSCS_DIAG.SPACE_TABLE('MYTABLE')) T; </PRE>
<P>
NOTE: Both the schema name and the table name must be any expression that evaluates to a
string data type. If you created a schema or table name as a non-delimited identifier,
@@ -102,7 +100,7 @@ import org.apache.derby.vti.VTIEnvironme
select v.*
from SYS.SYSSCHEMAS s,
SYS.SYSTABLES t,
- new org.apache.derby.diag.SpaceTable(SCHEMANAME,TABLENAME) v
+ TABLE(SYSCS_DIAG.SPACE_TABLE(SCHEMANAME, TABLENAME)) v
where s.SCHEMAID = t.SCHEMAID;
</PRE>
*/