Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 83050 invoked from network); 15 Mar 2006 21:33:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 15 Mar 2006 21:33:19 -0000 Received: (qmail 93693 invoked by uid 500); 15 Mar 2006 21:33:14 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 93348 invoked by uid 500); 15 Mar 2006 21:33:12 -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 93101 invoked by uid 99); 15 Mar 2006 21:33:10 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Mar 2006 13:33:10 -0800 X-ASF-Spam-Status: No, hits=-9.4 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME,UPPERCASE_25_50 X-Spam-Check-By: apache.org Received: from [209.237.227.194] (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 15 Mar 2006 13:32:48 -0800 Received: (qmail 82053 invoked by uid 65534); 15 Mar 2006 21:32:26 -0000 Message-ID: <20060315213226.82050.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r386169 [11/36] - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master: DerbyNet/jdk16/ DerbyNetClient/jdk16/ jdk16/ Date: Wed, 15 Mar 2006 21:31:59 -0000 To: derby-commits@db.apache.org From: davidvc@apache.org X-Mailer: svnmailer-1.0.7 X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/syscat.out URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/syscat.out?rev=386169&view=auto ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/syscat.out (added) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/syscat.out Wed Mar 15 13:31:53 2006 @@ -0,0 +1,701 @@ +ij> -- +----- this test shows the system catalogs +----- +----- It is a goal of this test not to display information that +----- can (and will!) change from run to run, such as fields +----- that may eventually be UUIDs or UUID-like. +----- +maximumdisplaywidth 500; +ij> -- negative tests +----- verify no user ddl allowed on system tables +----- drop table +drop table sys.systables; +ERROR X0Y56: 'DROP TABLE' is not allowed on the System table 'SYS.SYSTABLES'. : +ij> -- drop index +drop index sys.sysaliases_index2; +ERROR 42X62: 'DROP INDEX' is not allowed in the 'SYS' schema. : +ij> -- create index +create index trash on sys.systables(tableid); +ERROR 42X62: 'CREATE INDEX' is not allowed in the 'SYS' schema. : +ij> -- system tables are not updateable +autocommit off; +ij> delete from sys.systables; +ERROR 42Y25: 'SYS.SYSTABLES' is a system table. Users are not allowed to modify the contents of this table. : +ij> update sys.systables set tablename = tablename | | 'trash'; +ERROR 42Y25: 'SYS.SYSTABLES' is a system table. Users are not allowed to modify the contents of this table. : +ij> insert into sys.systables select * from sys.systables; +ERROR 42Y25: 'SYS.SYSTABLES' is a system table. Users are not allowed to modify the contents of this table. : +ij> get cursor c as 'select tablename from sys.systables for update of tablename'; +ERROR 42Y90: FOR UPDATE is not permitted in this type of statement. : +ij> -- users not allowed to do ddl in sys schema +create table sys.usertable(c1 int); +ERROR 42X62: 'CREATE TABLE' is not allowed in the 'SYS' schema. : +ij> create view sys.userview as values 1; +ERROR 42908: The CREATE VIEW statement does not include a column list. : +ij> rollback work; +ij> autocommit on; +ij> -- positive tests +create function gatp(SCH VARCHAR(128), TBL VARCHAR(128)) RETURNS VARCHAR(1000) +EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestPropertyInfo.getAllTableProperties' +LANGUAGE JAVA PARAMETER STYLE JAVA; +0 rows inserted/updated/deleted +ij> create function gaip(SCH VARCHAR(128), TBL VARCHAR(128)) RETURNS VARCHAR(1000) +EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestPropertyInfo.getAllIndexProperties' +LANGUAGE JAVA PARAMETER STYLE JAVA; +0 rows inserted/updated/deleted +ij> -- get the properties for the heaps +select tablename,gatp('SYS', + tablename) from sys.systables +order by tablename; +TABLENAME |2 +----- +SYSALIASES |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSCHECKS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSCOLPERMS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSCOLUMNS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSCONGLOMERATES |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSCONSTRAINTS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSDEPENDS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSDUMMY1 |{ } +SYSFILES |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSFOREIGNKEYS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSKEYS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSREQUIREDPERM |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSROUTINEPERMS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSSCHEMAS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSSTATEMENTS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSSTATISTICS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSTABLEPERMS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSTABLES |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSTRIGGERS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +SYSVIEWS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } +ij> -- get the properties for the indexes +select conglomeratename, gaip('SYS', + conglomeratename) from sys.sysconglomerates +where isindex +order by conglomeratename; +CONGLOMERATENAME |2 +----- +SYSALIASES_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSALIASES_INDEX2 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSALIASES_INDEX3 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSCHECKS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSCOLPERMS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSCOLUMNS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSCOLUMNS_INDEX2 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSCONGLOMERATES_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSCONGLOMERATES_INDEX2 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSCONGLOMERATES_INDEX3 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSCONSTRAINTS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSCONSTRAINTS_INDEX2 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSCONSTRAINTS_INDEX3 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSDEPENDS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSDEPENDS_INDEX2 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSFILES_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSFILES_INDEX2 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSFOREIGNKEYS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSFOREIGNKEYS_INDEX2 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSKEYS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSREQUIREDPERM_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSROUTINEPERMS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSSCHEMAS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSSCHEMAS_INDEX2 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSSTATEMENTS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSSTATEMENTS_INDEX2 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSSTATISTICS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSTABLEPERMS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSTABLES_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSTABLES_INDEX2 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSTRIGGERS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSTRIGGERS_INDEX2 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSTRIGGERS_INDEX3 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +SYSVIEWS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } +ij> select TABLENAME, TABLETYPE from sys.systables order by tablename; +TABLENAME |& +----- +SYSALIASES |S +SYSCHECKS |S +SYSCOLPERMS |S +SYSCOLUMNS |S +SYSCONGLOMERATES |S +SYSCONSTRAINTS |S +SYSDEPENDS |S +SYSDUMMY1 |S +SYSFILES |S +SYSFOREIGNKEYS |S +SYSKEYS |S +SYSREQUIREDPERM |S +SYSROUTINEPERMS |S +SYSSCHEMAS |S +SYSSTATEMENTS |S +SYSSTATISTICS |S +SYSTABLEPERMS |S +SYSTABLES |S +SYSTRIGGERS |S +SYSVIEWS |S +ij> select TABLENAME, + COLUMNNAME, COLUMNNUMBER, + columndatatype +from sys.systables t, sys.syscolumns c +where t.TABLEID=c.REFERENCEID +order by TABLENAME, COLUMNNAME; +TABLENAME |COLUMNNAME |COLUMNNUMB& |COLUMNDATATYPE +----- +SYSALIASES |ALIAS |2 |VARCHAR(128) NOT NULL +SYSALIASES |ALIASID |1 |CHAR(36) NOT NULL +SYSALIASES |ALIASINFO |8 |org.apache.derby.catalog.AliasInfo +SYSALIASES |ALIASTYPE |5 |CHAR(1) NOT NULL +SYSALIASES |JAVACLASSNAME |4 |LONG VARCHAR NOT NULL +SYSALIASES |NAMESPACE |6 |CHAR(1) NOT NULL +SYSALIASES |SCHEMAID |3 |CHAR(36) +SYSALIASES |SPECIFICNAME |9 |VARCHAR(128) NOT NULL +SYSALIASES |SYSTEMALIAS |7 |BOOLEAN NOT NULL +SYSCHECKS |CHECKDEFINITION |2 |LONG VARCHAR NOT NULL +SYSCHECKS |CONSTRAINTID |1 |CHAR(36) NOT NULL +SYSCHECKS |REFERENCEDCOLUMNS |3 |org.apache.derby.catalog.ReferencedColumns NOT NULL +SYSCOLPERMS |COLUMNS |5 |org.apache.derby.iapi.services.io.FormatableBitSet NOT NULL +SYSCOLPERMS |GRANTEE |1 |VARCHAR(128) NOT NULL +SYSCOLPERMS |GRANTOR |2 |VARCHAR(128) NOT NULL +SYSCOLPERMS |TABLEID |3 |CHAR(36) NOT NULL +SYSCOLPERMS |TYPE |4 |CHAR(1) NOT NULL +SYSCOLUMNS |AUTOINCREMENTINC |9 |BIGINT +SYSCOLUMNS |AUTOINCREMENTSTART |8 |BIGINT +SYSCOLUMNS |AUTOINCREMENTVALUE |7 |BIGINT +SYSCOLUMNS |COLUMNDATATYPE |4 |org.apache.derby.catalog.TypeDescriptor NOT NULL +SYSCOLUMNS |COLUMNDEFAULT |5 |java.io.Serializable +SYSCOLUMNS |COLUMNDEFAULTID |6 |CHAR(36) +SYSCOLUMNS |COLUMNNAME |2 |VARCHAR(128) NOT NULL +SYSCOLUMNS |COLUMNNUMBER |3 |INTEGER NOT NULL +SYSCOLUMNS |REFERENCEID |1 |CHAR(36) NOT NULL +SYSCONGLOMERATES |CONGLOMERATEID |8 |CHAR(36) NOT NULL +SYSCONGLOMERATES |CONGLOMERATENAME |4 |VARCHAR(128) +SYSCONGLOMERATES |CONGLOMERATENUMBER |3 |BIGINT NOT NULL +SYSCONGLOMERATES |DESCRIPTOR |6 |org.apache.derby.catalog.IndexDescriptor +SYSCONGLOMERATES |ISCONSTRAINT |7 |BOOLEAN +SYSCONGLOMERATES |ISINDEX |5 |BOOLEAN NOT NULL +SYSCONGLOMERATES |SCHEMAID |1 |CHAR(36) NOT NULL +SYSCONGLOMERATES |TABLEID |2 |CHAR(36) NOT NULL +SYSCONSTRAINTS |CONSTRAINTID |1 |CHAR(36) NOT NULL +SYSCONSTRAINTS |CONSTRAINTNAME |3 |VARCHAR(128) NOT NULL +SYSCONSTRAINTS |REFERENCECOUNT |7 |INTEGER NOT NULL +SYSCONSTRAINTS |SCHEMAID |5 |CHAR(36) NOT NULL +SYSCONSTRAINTS |STATE |6 |CHAR(1) NOT NULL +SYSCONSTRAINTS |TABLEID |2 |CHAR(36) NOT NULL +SYSCONSTRAINTS |TYPE |4 |CHAR(1) NOT NULL +SYSDEPENDS |DEPENDENTFINDER |2 |org.apache.derby.catalog.DependableFinder NOT NULL +SYSDEPENDS |DEPENDENTID |1 |CHAR(36) NOT NULL +SYSDEPENDS |PROVIDERFINDER |4 |org.apache.derby.catalog.DependableFinder NOT NULL +SYSDEPENDS |PROVIDERID |3 |CHAR(36) NOT NULL +SYSDUMMY1 |IBMREQD |1 |CHAR(1) +SYSFILES |FILEID |1 |CHAR(36) NOT NULL +SYSFILES |FILENAME |3 |VARCHAR(128) NOT NULL +SYSFILES |GENERATIONID |4 |BIGINT NOT NULL +SYSFILES |SCHEMAID |2 |CHAR(36) NOT NULL +SYSFOREIGNKEYS |CONGLOMERATEID |2 |CHAR(36) NOT NULL +SYSFOREIGNKEYS |CONSTRAINTID |1 |CHAR(36) NOT NULL +SYSFOREIGNKEYS |DELETERULE |4 |CHAR(1) NOT NULL +SYSFOREIGNKEYS |KEYCONSTRAINTID |3 |CHAR(36) NOT NULL +SYSFOREIGNKEYS |UPDATERULE |5 |CHAR(1) NOT NULL +SYSKEYS |CONGLOMERATEID |2 |CHAR(36) NOT NULL +SYSKEYS |CONSTRAINTID |1 |CHAR(36) NOT NULL +SYSREQUIREDPERM |COLUMNS |5 |org.apache.derby.iapi.services.io.FormatableBitSet NOT NULL +SYSREQUIREDPERM |OBJECT |4 |CHAR(36) NOT NULL +SYSREQUIREDPERM |OPERATOR |1 |CHAR(36) NOT NULL +SYSREQUIREDPERM |OPERATORTYPE |2 |CHAR(1) NOT NULL +SYSREQUIREDPERM |PERMTYPE |3 |CHAR(1) NOT NULL +SYSROUTINEPERMS |ALIASID |3 |CHAR(36) NOT NULL +SYSROUTINEPERMS |GRANTEE |1 |VARCHAR(128) NOT NULL +SYSROUTINEPERMS |GRANTOPTION |4 |CHAR(1) NOT NULL +SYSROUTINEPERMS |GRANTOR |2 |VARCHAR(128) NOT NULL +SYSSCHEMAS |AUTHORIZATIONID |3 |VARCHAR(128) NOT NULL +SYSSCHEMAS |SCHEMAID |1 |CHAR(36) NOT NULL +SYSSCHEMAS |SCHEMANAME |2 |VARCHAR(128) NOT NULL +SYSSTATEMENTS |COMPILATIONSCHEMAID |8 |CHAR(36) NOT NULL +SYSSTATEMENTS |LASTCOMPILED |7 |TIMESTAMP +SYSSTATEMENTS |SCHEMAID |3 |CHAR(36) NOT NULL +SYSSTATEMENTS |STMTID |1 |CHAR(36) NOT NULL +SYSSTATEMENTS |STMTNAME |2 |VARCHAR(128) NOT NULL +SYSSTATEMENTS |TEXT |6 |LONG VARCHAR NOT NULL +SYSSTATEMENTS |TYPE |4 |CHAR(1) NOT NULL +SYSSTATEMENTS |USINGTEXT |9 |LONG VARCHAR +SYSSTATEMENTS |VALID |5 |BOOLEAN NOT NULL +SYSSTATISTICS |COLCOUNT |7 |INTEGER NOT NULL +SYSSTATISTICS |CREATIONTIMESTAMP |4 |TIMESTAMP NOT NULL +SYSSTATISTICS |REFERENCEID |2 |CHAR(36) NOT NULL +SYSSTATISTICS |STATID |1 |CHAR(36) NOT NULL +SYSSTATISTICS |STATISTICS |8 |org.apache.derby.catalog.Statistics NOT NULL +SYSSTATISTICS |TABLEID |3 |CHAR(36) NOT NULL +SYSSTATISTICS |TYPE |5 |CHAR(1) NOT NULL +SYSSTATISTICS |VALID |6 |BOOLEAN NOT NULL +SYSTABLEPERMS |DELETEPRIV |5 |CHAR(1) NOT NULL +SYSTABLEPERMS |GRANTEE |1 |VARCHAR(128) NOT NULL +SYSTABLEPERMS |GRANTOR |2 |VARCHAR(128) NOT NULL +SYSTABLEPERMS |INSERTPRIV |6 |CHAR(1) NOT NULL +SYSTABLEPERMS |REFERENCESPRIV |8 |CHAR(1) NOT NULL +SYSTABLEPERMS |SELECTPRIV |4 |CHAR(1) NOT NULL +SYSTABLEPERMS |TABLEID |3 |CHAR(36) NOT NULL +SYSTABLEPERMS |TRIGGERPRIV |9 |CHAR(1) NOT NULL +SYSTABLEPERMS |UPDATEPRIV |7 |CHAR(1) NOT NULL +SYSTABLES |LOCKGRANULARITY |5 |CHAR(1) NOT NULL +SYSTABLES |SCHEMAID |4 |CHAR(36) NOT NULL +SYSTABLES |TABLEID |1 |CHAR(36) NOT NULL +SYSTABLES |TABLENAME |2 |VARCHAR(128) NOT NULL +SYSTABLES |TABLETYPE |3 |CHAR(1) NOT NULL +SYSTRIGGERS |ACTIONSTMTID |11 |CHAR(36) +SYSTRIGGERS |CREATIONTIMESTAMP |4 |TIMESTAMP NOT NULL +SYSTRIGGERS |EVENT |5 |CHAR(1) NOT NULL +SYSTRIGGERS |FIRINGTIME |6 |CHAR(1) NOT NULL +SYSTRIGGERS |NEWREFERENCINGNAME |17 |VARCHAR(128) +SYSTRIGGERS |OLDREFERENCINGNAME |16 |VARCHAR(128) [... 453 lines stripped ...]