From derby-commits-return-916-apmail-db-derby-commits-archive=db.apache.org@db.apache.org Thu Jun 02 23:52:53 2005 Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 23749 invoked from network); 2 Jun 2005 23:52:53 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 2 Jun 2005 23:52:53 -0000 Received: (qmail 22249 invoked by uid 500); 2 Jun 2005 23:52:52 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 22138 invoked by uid 500); 2 Jun 2005 23:52:52 -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 22103 invoked by uid 500); 2 Jun 2005 23:52:51 -0000 Delivered-To: apmail-incubator-derby-cvs@incubator.apache.org Received: (qmail 22071 invoked by uid 99); 2 Jun 2005 23:52:51 -0000 X-ASF-Spam-Status: No, hits=-9.6 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME,UPPERCASE_25_50 X-Spam-Check-By: apache.org Received: from minotaur.apache.org (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.28) with SMTP; Thu, 02 Jun 2005 16:52:49 -0700 Received: (qmail 23634 invoked by uid 65534); 2 Jun 2005 23:52:48 -0000 Message-ID: <20050602235248.23632.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Subject: svn commit: r179674 [2/5] - in /incubator/derby/code/trunk/java: engine/org/apache/derby/catalog/types/ testing/org/apache/derbyTesting/functionTests/master/ testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ testing/org/apache/derbyTesting/functionTests/suites/ testing/org/apache/derbyTesting/functionTests/tests/lang/ Date: Thu, 02 Jun 2005 23:52:46 -0000 To: derby-cvs@incubator.apache.org From: bandaram@apache.org X-Mailer: svnmailer-1.0.0-dev X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/func= tionTests/master/DerbyNet/syscat.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/DerbyNet/syscat.out?rev=3D1796= 74&view=3Dauto =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNet/syscat.out (added) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNet/syscat.out Thu Jun 2 16:52:45 2005 @@ -0,0 +1,619 @@ +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.SYSTABLE= S'. +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 =3D 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 tab= lename'; +ERROR 42Y90: FOR UPDATE is not permitted on 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(1= 000) +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 VARCH= AR(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 = = = = = = =20 +----- +SYSALIASES |{ derby.storage.initialPages=3D1, derby.storage.minimumRecordS= ize=3D12, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize=3D409= 6, derby.storage.reusableRecordId=3Dfalse } = = = = =20 +SYSCHECKS |{ derby.storage.initialPages=3D1, derby.storage.minimumRecordSi= ze=3D12, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize=3D4096= , derby.storage.reusableRecordId=3Dfalse } = = = = =20 +SYSCOLUMNS |{ derby.storage.initialPages=3D1, derby.storage.minimumRecordS= ize=3D12, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize=3D409= 6, derby.storage.reusableRecordId=3Dfalse } = = = = =20 +SYSCONGLOMERATES |{ derby.storage.initialPages=3D1, derby.storage.minimumR= ecordSize=3D12, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dfalse } = = = = = =20 +SYSCONSTRAINTS |{ derby.storage.initialPages=3D1, derby.storage.minimumRec= ordSize=3D12, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dfalse } = = = = = =20 +SYSDEPENDS |{ derby.storage.initialPages=3D1, derby.storage.minimumRecordS= ize=3D12, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize=3D409= 6, derby.storage.reusableRecordId=3Dfalse } = = = = =20 +SYSDUMMY1 |{ } = = = = = = =20 +SYSFILES |{ derby.storage.initialPages=3D1, derby.storage.minimumRecordSiz= e=3D12, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize=3D4096,= derby.storage.reusableRecordId=3Dfalse } = = = = =20 +SYSFOREIGNKEYS |{ derby.storage.initialPages=3D1, derby.storage.minimumRec= ordSize=3D12, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dfalse } = = = = = =20 +SYSKEYS |{ derby.storage.initialPages=3D1, derby.storage.minimumRecordSize= =3D12, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize=3D4096, = derby.storage.reusableRecordId=3Dfalse } = = = = =20 +SYSSCHEMAS |{ derby.storage.initialPages=3D1, derby.storage.minimumRecordS= ize=3D12, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize=3D409= 6, derby.storage.reusableRecordId=3Dfalse } = = = = =20 +SYSSTATEMENTS |{ derby.storage.initialPages=3D1, derby.storage.minimumReco= rdSize=3D12, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize=3D= 4096, derby.storage.reusableRecordId=3Dfalse } = = = = =20 +SYSSTATISTICS |{ derby.storage.initialPages=3D1, derby.storage.minimumReco= rdSize=3D12, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize=3D= 4096, derby.storage.reusableRecordId=3Dfalse } = = = = =20 +SYSTABLES |{ derby.storage.initialPages=3D1, derby.storage.minimumRecordSi= ze=3D12, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize=3D4096= , derby.storage.reusableRecordId=3Dfalse } = = = = =20 +SYSTRIGGERS |{ derby.storage.initialPages=3D1, derby.storage.minimumRecord= Size=3D12, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize=3D40= 96, derby.storage.reusableRecordId=3Dfalse } = = = = =20 +SYSVIEWS |{ derby.storage.initialPages=3D1, derby.storage.minimumRecordSiz= e=3D12, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize=3D4096,= derby.storage.reusableRecordId=3Dfalse } = = = = =20 +ij> -- get the properties for the indexes +select conglomeratename, gaip('SYS', + conglomeratename) from sys.sysconglomerates +where isindex +order by conglomeratename; +CONGLOMERATENAME |2 = = = = = = =20 +----- +SYSALIASES_INDEX1 |{ derby.storage.initialPages=3D1, derby.storage.minimum= RecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSALIASES_INDEX2 |{ derby.storage.initialPages=3D1, derby.storage.minimum= RecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSALIASES_INDEX3 |{ derby.storage.initialPages=3D1, derby.storage.minimum= RecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSCHECKS_INDEX1 |{ derby.storage.initialPages=3D1, derby.storage.minimumR= ecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSCOLUMNS_INDEX1 |{ derby.storage.initialPages=3D1, derby.storage.minimum= RecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSCOLUMNS_INDEX2 |{ derby.storage.initialPages=3D1, derby.storage.minimum= RecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSCONGLOMERATES_INDEX1 |{ derby.storage.initialPages=3D1, derby.storage.m= inimumRecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pa= geSize=3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSCONGLOMERATES_INDEX2 |{ derby.storage.initialPages=3D1, derby.storage.m= inimumRecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pa= geSize=3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSCONGLOMERATES_INDEX3 |{ derby.storage.initialPages=3D1, derby.storage.m= inimumRecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pa= geSize=3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSCONSTRAINTS_INDEX1 |{ derby.storage.initialPages=3D1, derby.storage.min= imumRecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.page= Size=3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSCONSTRAINTS_INDEX2 |{ derby.storage.initialPages=3D1, derby.storage.min= imumRecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.page= Size=3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSCONSTRAINTS_INDEX3 |{ derby.storage.initialPages=3D1, derby.storage.min= imumRecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.page= Size=3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSDEPENDS_INDEX1 |{ derby.storage.initialPages=3D1, derby.storage.minimum= RecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSDEPENDS_INDEX2 |{ derby.storage.initialPages=3D1, derby.storage.minimum= RecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSFILES_INDEX1 |{ derby.storage.initialPages=3D1, derby.storage.minimumRe= cordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSFILES_INDEX2 |{ derby.storage.initialPages=3D1, derby.storage.minimumRe= cordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSFOREIGNKEYS_INDEX1 |{ derby.storage.initialPages=3D1, derby.storage.min= imumRecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.page= Size=3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSFOREIGNKEYS_INDEX2 |{ derby.storage.initialPages=3D1, derby.storage.min= imumRecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.page= Size=3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSKEYS_INDEX1 |{ derby.storage.initialPages=3D1, derby.storage.minimumRec= ordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize=3D= 4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSSCHEMAS_INDEX1 |{ derby.storage.initialPages=3D1, derby.storage.minimum= RecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSSCHEMAS_INDEX2 |{ derby.storage.initialPages=3D1, derby.storage.minimum= RecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSSTATEMENTS_INDEX1 |{ derby.storage.initialPages=3D1, derby.storage.mini= mumRecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageS= ize=3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSSTATEMENTS_INDEX2 |{ derby.storage.initialPages=3D1, derby.storage.mini= mumRecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageS= ize=3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSSTATISTICS_INDEX1 |{ derby.storage.initialPages=3D1, derby.storage.mini= mumRecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageS= ize=3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSTABLES_INDEX1 |{ derby.storage.initialPages=3D1, derby.storage.minimumR= ecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSTABLES_INDEX2 |{ derby.storage.initialPages=3D1, derby.storage.minimumR= ecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSTRIGGERS_INDEX1 |{ derby.storage.initialPages=3D1, derby.storage.minimu= mRecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSiz= e=3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSTRIGGERS_INDEX2 |{ derby.storage.initialPages=3D1, derby.storage.minimu= mRecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSiz= e=3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSTRIGGERS_INDEX3 |{ derby.storage.initialPages=3D1, derby.storage.minimu= mRecordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSiz= e=3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +SYSVIEWS_INDEX1 |{ derby.storage.initialPages=3D1, derby.storage.minimumRe= cordSize=3D1, derby.storage.pageReservedSpace=3D0, derby.storage.pageSize= =3D4096, derby.storage.reusableRecordId=3Dtrue } = = = = = =20 +ij> select TABLENAME, TABLETYPE from sys.systables; +TABLENAME |& +----- +SYSCONGLOMERATES |S +SYSTABLES |S +SYSCOLUMNS |S +SYSSCHEMAS |S +SYSCONSTRAINTS |S +SYSKEYS |S +SYSDEPENDS |S +SYSALIASES |S +SYSVIEWS |S +SYSCHECKS |S +SYSFOREIGNKEYS |S +SYSSTATEMENTS |S +SYSFILES |S +SYSTRIGGERS |S +SYSSTATISTICS |S +SYSDUMMY1 |S +ij> select TABLENAME, + COLUMNNAME, COLUMNNUMBER, + columndatatype +from sys.systables t, sys.syscolumns c +where t.TABLEID=3Dc.REFERENCEID +order by TABLENAME, COLUMNNAME; +TABLENAME |COLUMNNAME |COLUMNNUMB& |COLUMNDATATYPE = = = = = = = =20 +----- +SYSALIASES |ALIAS |2 |VARCHAR(128) NOT NULL = = = = = = =20 +SYSALIASES |ALIASID |1 |CHAR(36) NOT NULL = = = = = = =20 +SYSALIASES |ALIASINFO |8 |org.apache.derby.catalog.AliasInfo = = = = = = = =20 +SYSALIASES |ALIASTYPE |5 |CHAR(1) NOT NULL = = = = = = = =20 +SYSALIASES |JAVACLASSNAME |4 |LONG VARCHAR NOT NULL = = = = = = = =20 +SYSALIASES |NAMESPACE |6 |CHAR(1) NOT NULL = = = = = = = =20 +SYSALIASES |SCHEMAID |3 |CHAR(36) = = = = = = =20 +SYSALIASES |SPECIFICNAME |9 |VARCHAR(128) NOT NULL = = = = = = = =20 +SYSALIASES |SYSTEMALIAS |7 |BOOLEAN NOT NULL = = = = = = = =20 +SYSCHECKS |CHECKDEFINITION |2 |LONG VARCHAR NOT NULL = = = = = = = =20 +SYSCHECKS |CONSTRAINTID |1 |CHAR(36) NOT NULL = = = = = = = =20 +SYSCHECKS |REFERENCEDCOLUMNS |3 |org.apache.derby.catalog.ReferencedColumn= s NOT NULL = = = = = = =20 +SYSCOLUMNS |AUTOINCREMENTINC |9 |BIGINT = = = = = = = =20 +SYSCOLUMNS |AUTOINCREMENTSTART |8 |BIGINT = = = = = = = =20 +SYSCOLUMNS |AUTOINCREMENTVALUE |7 |BIGINT = = = = = = = =20 +SYSCOLUMNS |COLUMNDATATYPE |4 |org.apache.derby.catalog.TypeDescriptor NOT= NULL = = = = = = =20 +SYSCOLUMNS |COLUMNDEFAULT |5 |java.io.Serializable = = = = = = = =20 +SYSCOLUMNS |COLUMNDEFAULTID |6 |CHAR(36) = = = = = = = =20 +SYSCOLUMNS |COLUMNNAME |2 |VARCHAR(128) NOT NULL = = = = = = = =20 +SYSCOLUMNS |COLUMNNUMBER |3 |INTEGER NOT NULL = = = = = = = =20 +SYSCOLUMNS |REFERENCEID |1 |CHAR(36) NOT NULL = = = = = = = =20 +SYSCONGLOMERATES |CONGLOMERATEID |8 |CHAR(36) NOT NULL = = = = = = = =20 +SYSCONGLOMERATES |CONGLOMERATENAME |4 |VARCHAR(128) = = = = = = = =20 +SYSCONGLOMERATES |CONGLOMERATENUMBER |3 |BIGINT NOT NULL = = = = = = = =20 +SYSCONGLOMERATES |DESCRIPTOR |6 |org.apache.derby.catalog.IndexDescriptor = = = = = = = =20 +SYSCONGLOMERATES |ISCONSTRAINT |7 |BOOLEAN = = = = = = = =20 +SYSCONGLOMERATES |ISINDEX |5 |BOOLEAN NOT NULL = = = = = = = =20 +SYSCONGLOMERATES |SCHEMAID |1 |CHAR(36) NOT NULL = = = = = = = =20 +SYSCONGLOMERATES |TABLEID |2 |CHAR(36) NOT NULL = = = = = = = =20 +SYSCONSTRAINTS |CONSTRAINTID |1 |CHAR(36) NOT NULL = = = = = = = =20 +SYSCONSTRAINTS |CONSTRAINTNAME |3 |VARCHAR(128) NOT NULL = = = = = = = =20 +SYSCONSTRAINTS |REFERENCECOUNT |7 |INTEGER NOT NULL = = = = = = = =20 +SYSCONSTRAINTS |SCHEMAID |5 |CHAR(36) NOT NULL = = = = = = = =20 +SYSCONSTRAINTS |STATE |6 |CHAR(1) NOT NULL = = = = = = = =20 +SYSCONSTRAINTS |TABLEID |2 |CHAR(36) NOT NULL = = = = = = = =20 +SYSCONSTRAINTS |TYPE |4 |CHAR(1) NOT NULL = = = = = = =20 +SYSDEPENDS |DEPENDENTFINDER |2 |org.apache.derby.catalog.DependableFinder = NOT NULL = = = = = = =20 +SYSDEPENDS |DEPENDENTID |1 |CHAR(36) NOT NULL = = = = = = = =20 +SYSDEPENDS |PROVIDERFINDER |4 |org.apache.derby.catalog.DependableFinder N= OT NULL = = = = = = =20 +SYSDEPENDS |PROVIDERID |3 |CHAR(36) NOT NULL = = = = = = = =20 +SYSDUMMY1 |IBMREQD |1 |CHAR(1) = = = = = = =20 +SYSFILES |FILEID |1 |CHAR(36) NOT NULL = = = = = = =20 +SYSFILES |FILENAME |3 |VARCHAR(128) NOT NULL = = = = = = =20 +SYSFILES |GENERATIONID |4 |BIGINT NOT NULL = = = = = = = =20 +SYSFILES |SCHEMAID |2 |CHAR(36) NOT NULL = = = = = = =20 +SYSFOREIGNKEYS |CONGLOMERATEID |2 |CHAR(36) NOT NULL = = = = = = = =20 +SYSFOREIGNKEYS |CONSTRAINTID |1 |CHAR(36) NOT NULL = = = = = = = =20 +SYSFOREIGNKEYS |DELETERULE |4 |CHAR(1) NOT NULL = = = = = = = =20 +SYSFOREIGNKEYS |KEYCONSTRAINTID |3 |CHAR(36) NOT NULL = = = = = = = =20 +SYSFOREIGNKEYS |UPDATERULE |5 |CHAR(1) NOT NULL = = = = = = = =20 +SYSKEYS |CONGLOMERATEID |2 |CHAR(36) NOT NULL = = = = = = = =20 +SYSKEYS |CONSTRAINTID |1 |CHAR(36) NOT NULL = = = = = = = =20 +SYSSCHEMAS |AUTHORIZATIONID |3 |VARCHAR(128) NOT NULL = = = = = = = =20 +SYSSCHEMAS |SCHEMAID |1 |CHAR(36) NOT NULL = = = = = = =20 +SYSSCHEMAS |SCHEMANAME |2 |VARCHAR(128) NOT NULL = = = = = = = =20 +SYSSTATEMENTS |COMPILATIONSCHEMAID |8 |CHAR(36) NOT NULL = = = = = = = =20 +SYSSTATEMENTS |LASTCOMPILED |7 |TIMESTAMP = = = = = = = =20 +SYSSTATEMENTS |SCHEMAID |3 |CHAR(36) NOT NULL = = = = = = = =20 +SYSSTATEMENTS |STMTID |1 |CHAR(36) NOT NULL = = = = = = = =20 +SYSSTATEMENTS |STMTNAME |2 |VARCHAR(128) NOT NULL = = = = = = = =20 +SYSSTATEMENTS |TEXT |6 |LONG VARCHAR NOT NULL = = = = = = =20 +SYSSTATEMENTS |TYPE |4 |CHAR(1) NOT NULL = = = = = = =20 +SYSSTATEMENTS |USINGTEXT |9 |LONG VARCHAR = = = = = = = =20 +SYSSTATEMENTS |VALID |5 |BOOLEAN NOT NULL = = = = = = =20 +SYSSTATISTICS |COLCOUNT |7 |INTEGER NOT NULL = = = = = = = =20 +SYSSTATISTICS |CREATIONTIMESTAMP |4 |TIMESTAMP NOT NULL = = = = = = = =20 +SYSSTATISTICS |REFERENCEID |2 |CHAR(36) NOT NULL = = = = = = = =20 +SYSSTATISTICS |STATID |1 |CHAR(36) NOT NULL = = = = = = = =20 +SYSSTATISTICS |STATISTICS |8 |org.apache.derby.catalog.Statistics NOT NULL= = = = = = = =20 +SYSSTATISTICS |TABLEID |3 |CHAR(36) NOT NULL = = = = = = = =20 +SYSSTATISTICS |TYPE |5 |CHAR(1) NOT NULL = = = = = = =20 +SYSSTATISTICS |VALID |6 |BOOLEAN NOT NULL = = = = = = =20 +SYSTABLES |LOCKGRANULARITY |5 |CHAR(1) NOT NULL = = = = = = = =20 +SYSTABLES |SCHEMAID |4 |CHAR(36) NOT NULL = = = = = = =20 +SYSTABLES |TABLEID |1 |CHAR(36) NOT NULL = = = = = = =20 +SYSTABLES |TABLENAME |2 |VARCHAR(128) NOT NULL = = = = = = =20 +SYSTABLES |TABLETYPE |3 |CHAR(1) NOT NULL = = = = = = =20 +SYSTRIGGERS |ACTIONSTMTID |11 |CHAR(36) = = = = = = = =20 +SYSTRIGGERS |CREATIONTIMESTAMP |4 |TIMESTAMP NOT NULL = = = = = = = =20 +SYSTRIGGERS |EVENT |5 |CHAR(1) NOT NULL = = = = = = =20 +SYSTRIGGERS |FIRINGTIME |6 |CHAR(1) NOT NULL = = = = = = = =20 +SYSTRIGGERS |NEWREFERENCINGNAME |17 |VARCHAR(128) = = = = = = = =20 +SYSTRIGGERS |OLDREFERENCINGNAME |16 |VARCHAR(128) = = = = = = = =20 +SYSTRIGGERS |REFERENCEDCOLUMNS |12 |org.apache.derby.catalog.ReferencedCol= umns = = = = = = =20 +SYSTRIGGERS |REFERENCINGNEW |15 |BOOLEAN = = = = = = = =20 +SYSTRIGGERS |REFERENCINGOLD |14 |BOOLEAN = = = = = = = =20 +SYSTRIGGERS |SCHEMAID |3 |CHAR(36) NOT NULL = = = = = = = =20 +SYSTRIGGERS |STATE |8 |CHAR(1) NOT NULL = = = = = = =20 +SYSTRIGGERS |TABLEID |9 |CHAR(36) NOT NULL = = = = = = =20 +SYSTRIGGERS |TRIGGERDEFINITION |13 |LONG VARCHAR = = = = = = = =20 +SYSTRIGGERS |TRIGGERID |1 |CHAR(36) NOT NULL = = = = = = = =20 +SYSTRIGGERS |TRIGGERNAME |2 |VARCHAR(128) NOT NULL = = = = = = = =20 +SYSTRIGGERS |TYPE |7 |CHAR(1) NOT NULL = = = = = = =20 +SYSTRIGGERS |WHENSTMTID |10 |CHAR(36) = = = = = = = =20 +SYSVIEWS |CHECKOPTION |3 |CHAR(1) NOT NULL = = = = = = = =20 +SYSVIEWS |COMPILATIONSCHEMAID |4 |CHAR(36) NOT NULL = = = = = = = =20 +SYSVIEWS |TABLEID |1 |CHAR(36) NOT NULL = = = = = = =20 +SYSVIEWS |VIEWDEFINITION |2 |LONG VARCHAR NOT NULL = = = = = = = =20 +ij> select TABLENAME, ISINDEX=20 +from sys.systables t, sys.sysconglomerates c +where t.TABLEID=3Dc.TABLEID +order by TABLENAME, ISINDEX; +TABLENAME |ISIND& +----- +SYSALIASES |0 =20 +SYSALIASES |1 =20 +SYSALIASES |1 =20 +SYSALIASES |1 =20 +SYSCHECKS |0 =20 +SYSCHECKS |1 =20 +SYSCOLUMNS |0 =20 +SYSCOLUMNS |1 =20 +SYSCOLUMNS |1 =20 +SYSCONGLOMERATES |0 =20 +SYSCONGLOMERATES |1 =20 +SYSCONGLOMERATES |1 =20 +SYSCONGLOMERATES |1 =20 +SYSCONSTRAINTS |0 =20 +SYSCONSTRAINTS |1 =20 +SYSCONSTRAINTS |1 =20 +SYSCONSTRAINTS |1 =20 +SYSDEPENDS |0 =20 +SYSDEPENDS |1 =20 +SYSDEPENDS |1 =20 +SYSDUMMY1 |0 =20 +SYSFILES |0 =20 +SYSFILES |1 =20 +SYSFILES |1 =20 +SYSFOREIGNKEYS |0 =20 +SYSFOREIGNKEYS |1 =20 +SYSFOREIGNKEYS |1 =20 +SYSKEYS |0 =20 +SYSKEYS |1 =20 +SYSSCHEMAS |0 =20 +SYSSCHEMAS |1 =20 +SYSSCHEMAS |1 =20 +SYSSTATEMENTS |0 =20 +SYSSTATEMENTS |1 =20 +SYSSTATEMENTS |1 =20 +SYSSTATISTICS |0 =20 +SYSSTATISTICS |1 =20 +SYSTABLES |0 =20 +SYSTABLES |1 =20 +SYSTABLES |1 =20 +SYSTRIGGERS |0 =20 +SYSTRIGGERS |1 =20 +SYSTRIGGERS |1 =20 +SYSTRIGGERS |1 =20 +SYSVIEWS |0 =20 +SYSVIEWS |1 =20 +ij> create table t (i int, s smallint); +0 rows inserted/updated/deleted +ij> select TABLENAME, TABLETYPE from sys.systables; +TABLENAME |& +----- +SYSCONGLOMERATES |S +SYSTABLES |S +SYSCOLUMNS |S +SYSSCHEMAS |S +SYSCONSTRAINTS |S +SYSKEYS |S +SYSDEPENDS |S +SYSALIASES |S +SYSVIEWS |S +SYSCHECKS |S +SYSFOREIGNKEYS |S +SYSSTATEMENTS |S +SYSFILES |S +SYSTRIGGERS |S +SYSSTATISTICS |S +SYSDUMMY1 |S +T |T +ij> select TABLENAME, + COLUMNNAME, COLUMNNUMBER, + columndatatype +from sys.systables t, sys.syscolumns c +where t.TABLEID=3Dc.REFERENCEID +order by TABLENAME, COLUMNNAME; +TABLENAME |COLUMNNAME |COLUMNNUMB& |COLUMNDATATYPE = = = = = = = =20 +----- +SYSALIASES |ALIAS |2 |VARCHAR(128) NOT NULL = = = = = = =20 +SYSALIASES |ALIASID |1 |CHAR(36) NOT NULL = = = = = = =20 +SYSALIASES |ALIASINFO |8 |org.apache.derby.catalog.AliasInfo = = = = = = = =20 +SYSALIASES |ALIASTYPE |5 |CHAR(1) NOT NULL = = = = = = = =20 +SYSALIASES |JAVACLASSNAME |4 |LONG VARCHAR NOT NULL = = = = = = = =20 +SYSALIASES |NAMESPACE |6 |CHAR(1) NOT NULL = = = = = = = =20 +SYSALIASES |SCHEMAID |3 |CHAR(36) = = = = = = =20 +SYSALIASES |SPECIFICNAME |9 |VARCHAR(128) NOT NULL = = = = = = = =20 +SYSALIASES |SYSTEMALIAS |7 |BOOLEAN NOT NULL = = = = = = = =20 +SYSCHECKS |CHECKDEFINITION |2 |LONG VARCHAR NOT NULL = = = = = = = =20 +SYSCHECKS |CONSTRAINTID |1 |CHAR(36) NOT NULL = = = = = = = =20 +SYSCHECKS |REFERENCEDCOLUMNS |3 |org.apache.derby.catalog.ReferencedColumn= s NOT NULL = = = = = = =20 [=2E.. 297 lines stripped ...]