From derby-commits-return-13797-apmail-db-derby-commits-archive=db.apache.org@db.apache.org Mon Feb 07 17:06:54 2011 Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 98972 invoked from network); 7 Feb 2011 17:06:53 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 7 Feb 2011 17:06:53 -0000 Received: (qmail 72241 invoked by uid 500); 7 Feb 2011 17:06:53 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 72198 invoked by uid 500); 7 Feb 2011 17:06:50 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 72190 invoked by uid 99); 7 Feb 2011 17:06:49 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Feb 2011 17:06:49 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Feb 2011 17:06:47 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id 8B6642388A41; Mon, 7 Feb 2011 17:06:26 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit 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 -0000 To: derby-commits@db.apache.org From: kmarsden@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20110207170626.8B6642388A41@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org 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. - 
 select * from new org.apache.derby.diag.SpaceTable('MYSCHEMA','MYTABLE') t;
+ 
 SELECT * FROM TABLE(SYSCS_DIAG.SPACE_TABLE('MYSCHEMA', 'MYTABLE')) T;
If the schema name is not supplied, the default schema is used. - 
 select * from new org.apache.derby.diag.SpaceTable('MYTABLE') t;
- Alternatively, the table can be invoked through the system alias SpaceTable - 
 select * from new SPACETABLE('MYTABLE') t;
+ 
 SELECT * FROM TABLE(SYSCS_DIAG.SPACE_TABLE('MYTABLE')) T;

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