db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kahat...@apache.org
Subject svn commit: r767396 - /db/derby/code/trunk/java/engine/org/apache/derby/diag/SpaceTable.java
Date Wed, 22 Apr 2009 07:22:47 GMT
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>
 */



Mime
View raw message