db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject svn commit: r1068015 - /db/derby/code/branches/10.5/java/engine/org/apache/derby/diag/SpaceTable.java
Date Mon, 07 Feb 2011 17:06:26 GMT
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>
 */



Mime
View raw message