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 ka...@apache.org on 2009/04/22 09:22:47 UTC
svn commit: r767396 -
/db/derby/code/trunk/java/engine/org/apache/derby/diag/SpaceTable.java
Author: kahatlen
Date: Wed Apr 22 07:22:47 2009
New Revision: 767396
URL: http://svn.apache.org/viewvc?rev=767396&view=rev
Log:
DERBY-4051: The javadoc for SpaceTable refers to an alias that doesn't seem to work
Patch contributed by Tiago R. Espinha.
Modified:
db/derby/code/trunk/java/engine/org/apache/derby/diag/SpaceTable.java
Modified: db/derby/code/trunk/java/engine/org/apache/derby/diag/SpaceTable.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/diag/SpaceTable.java?rev=767396&r1=767395&r2=767396&view=diff
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/diag/SpaceTable.java (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/diag/SpaceTable.java Wed Apr 22 07:22:47 2009
@@ -53,11 +53,9 @@
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 @@
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>
*/