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