-----= Start dblook (net server) Test. =- Creating database 'wombat' from ddl script 'dblook_makeDB.sql' ----- ******************************************* Dumping DDL for all objects, using Network Server: ******************************************* File dblook.log was empty. Creating database 'wombat_new' from ddl script 'wombat.sql' Dumping system tables for 'wombat_new' -----=================--------------- System Tables for: wombat_new -----=================--------------- ========== SYSALIASES ========== "proc "In Quotes with spaces" APP org.apache.derbyTesting.functionTests.util.ProcedureTest P P false inoutparams3(INOUT "A" CHAR(10),IN "B" INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 2 ----- F_DEFINERS_RIGHTS APP foo.bar F F false wibble() RETURNS INTEGER LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL SECURITY DEFINER NO SQL CALLED ON NULL INPUT ----- F_DETERMINISTIC APP foo.bar F F false wibble() RETURNS INTEGER LANGUAGE JAVA PARAMETER STYLE JAVA DETERMINISTIC NO SQL CALLED ON NULL INPUT ----- F_NOT_DETERMINISTIC APP foo.bar F F false wibble() RETURNS INTEGER LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL CALLED ON NULL INPUT ----- GATP2 FOO org.apache.derbyTesting.functionTests.util.TestPropertyInfo F F false getAllTableProperties("SCH" VARCHAR(128),"TBL" VARCHAR(128)) RETURNS VARCHAR(1000) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA RETURNS NULL ON NULL INPUT ----- GATP APP org.apache.derbyTesting.functionTests.util.TestPropertyInfo F F false getAllTableProperties("SCH" VARCHAR(128),"TBL" VARCHAR(128)) RETURNS VARCHAR(1000) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL CALLED ON NULL INPUT ----- OP4 BAR org.apache.derbyTesting.functionTests.util.ProcedureTest P P false inoutparams4(OUT "A" DECIMAL(4,2),IN "B" VARCHAR(255)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA ----- PROC1 APP org.apache.derbyTesting.functionTests.util.ProcedureTest P P false inoutparams3(INOUT "A" CHAR(10),IN "B" INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL DYNAMIC RESULT SETS 4 ----- PROC2 Foo Bar org.apache.derbyTesting.functionTests.util.ProcedureTest P P false sqlControl(OUT "E1" VARCHAR(128),OUT "E2" VARCHAR(128),OUT "E3" VARCHAR(128),OUT "E4" VARCHAR(128),OUT "E5" VARCHAR(128),OUT "E6" VARCHAR(128),OUT "E7" VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA ----- P_DEFINERS_RIGHTS APP foo.bar P P false wibble() LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL SECURITY DEFINER MODIFIES SQL DATA ----- P_DETERMINISTIC APP foo.bar P P false wibble() LANGUAGE JAVA PARAMETER STYLE JAVA DETERMINISTIC MODIFIES SQL DATA ----- P_NOT_DETERMINISTIC APP foo.bar P P false wibble() LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA ----- SQQLCONTROL_1 FOO org.apache.derbyTesting.functionTests.util.ProcedureTest P P false sqlControl(OUT "E1" VARCHAR(128),OUT "E2" VARCHAR(128),OUT "E3" VARCHAR(128),OUT "E4" VARCHAR(128),OUT "E5" VARCHAR(128),OUT "E6" VARCHAR(128),OUT "E7" VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL ----- SYNONYM1 APP null S S false "APP"."T1" ----- SYNONYM2 BAR null S S false "BAR"."MULTI WORD NAME" ----- SYNONYM3 BAR null S S false "APP"."T11" ----- func "' schema "' java.lang.Integer F F false toString("col with quotes ""'" INTEGER) RETURNS VARCHAR(20) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA CALLED ON NULL INPUT ----- proc "' schema "' java.lang.Thread P P false sleep(IN "col with quotes ""'" BIGINT) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA ----- procTwo APP org.apache.derbyTesting.functionTests.util.ProcedureTest P P false inoutparams3(INOUT "A" CHAR(10),IN "B" INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 2 ----- ========== SYSCHECKS ========== (i > 0) (2) ----- "ck2 ("""iq2" > 0) (2) ----- NOTEVIL (vc != 'evil') (3) ----- c"k1 ("i""q2" > 4) (2) ----- chkOne (k < 0) (2) ----- ck2" ("iq2""" > 4) (2) ----- ========== SYSCOLUMNS ========== ----- Columns for Tables --- "tquoteTwo "iq1 1 INTEGER null null null null ----- "tquoteTwo "iq2 2 INTEGER null null null null ----- 'Single' and "double" quoted table name 'Single' and "double" quoted column name 1 INTEGER null null null null ----- MULTI WORD NAME C 1 CHAR(2) null null null null ----- REMOVED X 1 INTEGER null null null null ----- T10 K 2 INTEGER NOT NULL null null null null ----- T10 UK 3 CHAR(3) NOT NULL null null null null ----- T10 VACH 1 VARCHAR(12) null null null null ----- T11 LOLA 2 INTEGER null null null null ----- T11 MYCHAR 1 CHAR(8) null null null null ----- T1 C 2 CHAR(8) null null null null ----- T1 C 2 CLOB(15) null null null null ----- T1 D 3 DATE null null null null ----- T1 F 4 DOUBLE NOT NULL null null null null ----- T1 I 1 INTEGER null null null null ----- T1 P1 1 VARCHAR(10) NOT NULL null null null null ----- T2 B 2 BLOB(20) null null null null ----- T2 C 3 CLOB(15) null null null null ----- T2 P1 1 VARCHAR(10) null null null null ----- T3 B 2 BLOB(20) null null null null ----- T3 ID 3 INTEGER NOT NULL null null 2 4 ----- T3 P1 1 VARCHAR(10) 'okie' null null ----- T3_2 B 2 BLOB(20) null null null null ----- T3_2 ID 3 INTEGER NOT NULL GENERATED_BY_DEFAULT 2 4 ----- T3_2 P1 1 VARCHAR(10) 'okie' null null ----- T4 I 1 INTEGER 2 null null ----- T4 J 2 INTEGER NOT NULL null null null null ----- T4 K 3 INTEGER NOT NULL null null 1 1 ----- T4_2 I 1 INTEGER 2 null null ----- T4_2 J 2 INTEGER NOT NULL null null null null ----- T4_2 K 3 INTEGER NOT NULL GENERATED_BY_DEFAULT 1 1 ----- T5 COST 1 DOUBLE null null null null ----- T6 LETTER 2 CHAR(1) null null null null ----- T6 NUM 1 INTEGER null null null null ----- T7 DEUX 2 INTEGER null null null null ----- T7 UN 1 INTEGER null null null null ----- T8 FKCHAR 2 CHAR(5) null null null null ----- T8 SOMEINT 1 INTEGER NOT NULL null null null null ----- T8T1T4 C1 1 CHAR(4) 'okie' null null ----- T8T1T4 C2 2 CHAR(4) 'doki' null null ----- T9 CH 2 CHAR(8) NOT NULL null null null null ----- T9 FKINT 1 INTEGER NOT NULL null null null null ----- T_GENCOL_1 A 1 INTEGER null null null null ----- T_GENCOL_1 B 2 INTEGER GENERATED ALWAYS AS ( 1 ) null null ----- T_GENCOL_1 C 3 INTEGER null null null null ----- T_GENCOL_2 A 1 INTEGER null null null null ----- T_GENCOL_2 B 2 INTEGER null null ----- T_GENCOL_2 C 3 INTEGER null null null null ----- T_GENCOL_3 A 1 INTEGER null null null null ----- T_GENCOL_3 B 2 INTEGER GENERATED ALWAYS AS ( a + c ) null null ----- T_GENCOL_3 C 3 INTEGER null null null null ----- V"3 I 1 INTEGER NOT NULL null null null null ----- V1 DEE 2 CHAR(8) null null null null ----- V1 DOKIE 3 VARCHAR(10) null null null null ----- V1 DOO 1 INTEGER null null null null ----- V1 DUM 1 DATE null null null null ----- V1 DWA 2 CHAR(1) null null null null ----- V2 C 2 CLOB(15) null null null null ----- V2 P1 1 VARCHAR(10) NOT NULL null null null null ----- X X 1 INTEGER null null null null ----- tWithKeys C 1 CHAR(5) NOT NULL null null null null ----- tWithKeys I 2 INTEGER null null null null ----- tWithKeys VC 3 VARCHAR(10) null null null null ----- tee""Hee N 1 CHAR(1) NOT NULL null null null null ----- tquote"One i"q1 1 INTEGER NOT NULL null null null null ----- tquote"One i"q2 2 INTEGER 8 null null ----- tquoteThree" iq1" 1 INTEGER NOT NULL null null null null ----- tquoteThree" iq2" 2 INTEGER null null null null ----- viewTwo LOLA 2 INTEGER null null null null ----- viewTwo MYCHAR 1 CHAR(8) null null null null ----- ----- Columns for Statements --- ========== SYSCONGLOMERATES ========== "Quoted"Schema" tee""Hee true UNIQUE BTREE (1) true ----- "Quoted"Schema" tee""Hee Ix"5 true BTREE (1 DESC) false ----- "Quoted"Schema" tee""Hee tee""Hee false null false ----- 'Single' and "double" quoted schema name 'Single' and "double" quoted table name 'Single' and "double" quoted table name false null false ----- APP "tquoteTwo true BTREE (1) true ----- APP "tquoteTwo "tquoteTwo false null false ----- APP REMOVED REMOVED false null false ----- APP T11 true BTREE (1, 2) true ----- APP T11 T11 false null false ----- APP T1 IX1 true BTREE (4, 1) false ----- APP T1 T1 false null false ----- APP T2 T2 false null false ----- APP T8T1T4 T8T1T4 false null false ----- APP T_GENCOL_1 T_GENCOL_1 false null false ----- APP T_GENCOL_2 T_GENCOL_2 false null false ----- APP T_GENCOL_3 T_GENCOL_3 false null false ----- APP X X false null false ----- APP tquote"One true UNIQUE BTREE (1) true ----- APP tquote"One tquote"One false null false ----- APP tquoteThree" true UNIQUE BTREE (1) true ----- APP tquoteThree" tquoteThree" false null false ----- BAR MULTI WORD NAME MULTI WORD NAME false null false ----- BAR T1 true UNIQUE BTREE (1) true ----- BAR T1 T1 false null false ----- BAR T3 IX2 true BTREE (1 DESC, 3 DESC) false ----- BAR T3 T3 false null false ----- BAR T3_2 T3_2 false null false ----- BAR T4 IX4 true UNIQUE BTREE (3) false ----- BAR T4 T4 false null false ----- BAR T4_2 T4_2 false null false ----- BAR T8 true BTREE (2) true ----- BAR T8 true UNIQUE BTREE (1) true ----- BAR T8 T8 false null false ----- BAR tWithKeys true UNIQUE BTREE (1) true ----- BAR tWithKeys IX3 true BTREE (1 DESC) false ----- BAR tWithKeys tWithKeys false null false ----- FOO T10 true UNIQUE BTREE (2) true ----- FOO T10 true UNIQUE BTREE (3) true ----- FOO T10 T10 false null false ----- FOO T9 true BTREE (1) true ----- FOO T9 true UNIQUE BTREE (2, 1) true ----- FOO T9 T9 false null false ----- Foo Bar T5 CostIndex true UNIQUE BTREE (1) false ----- Foo Bar T5 T5 false null false ----- Foo Bar T6 T6 false null false ----- Foo Bar T7 T7 false null false ----- ========== SYSCONSTRAINTS ========== "ck2 "tquoteTwo "ck2 C APP E 0 ----- "effkay1 "tquoteTwo "effkay1 F APP E 0 ----- T10 P FOO E 1 ----- T10 U FOO E 0 ----- T8 F BAR E 0 ----- T8 P BAR E 0 ----- tWithKeys C BAR E 0 ----- tWithKeys P BAR E 1 ----- NOTEVIL tWithKeys NOTEVIL C BAR E 0 ----- T11 F APP E 0 ----- UNQ T1 UNQ U BAR E 0 ----- c"k1 tquote"One c"k1 C APP E 0 ----- chkOne T10 chkOne C FOO E 0 ----- ck2" tquoteThree" ck2" C APP E 0 ----- fkOne T9 fkOne F FOO E 0 ----- pee"kay1 tquote"One pee"kay1 P APP E 1 ----- pkTwo T9 pkTwo P FOO E 1 ----- tee""Hee P "Quoted"Schema" E 0 ----- unqkay1" tquoteThree" unqkay1" U APP E 0 ----- ========== SYSDEPENDS ========== "effkay1 APP."effkay1 -> APP.pee"kay1 Constraint pee"kay1 Constraint ----- APP. -> FOO.pkTwo Constraint pkTwo Constraint ----- BAR. -> BAR. Constraint Constraint ----- fkOne FOO.fkOne -> FOO. Constraint Constraint ----- "Quoted"Schema". -> "Quoted"Schema".tee""Hee StoredPreparedStatement tee""Hee Table ----- APP. -> BAR.T4 StoredPreparedStatement T4 ColumnsInTable ----- APP. -> BAR.tWithKeys StoredPreparedStatement tWithKeys ColumnsInTable ----- APP. -> APP. StoredPreparedStatement Conglomerate ----- APP. -> BAR.IX3 StoredPreparedStatement Conglomerate ----- APP. ->

APP.REMOVED StoredPreparedStatement REMOVED Table ----- APP. ->

APP.X StoredPreparedStatement X Table ----- APP. ->

BAR.T3 StoredPreparedStatement T3 Table ----- APP. ->

BAR.tWithKeys StoredPreparedStatement tWithKeys Table ----- BAR. ->

BAR.T8 StoredPreparedStatement T8 Table ----- Foo Bar. ->

BAR.T1 StoredPreparedStatement T1 Table ----- "Quoted"Schema"."trig"One" -> "Quoted"Schema". Trigger StoredPreparedStatement ----- "Quoted"Schema"."trig"One" ->

"Quoted"Schema".tee""Hee Trigger tee""Hee Table ----- APP.TRIGFOUR -> APP. Trigger StoredPreparedStatement ----- APP.TRIGFOUR ->

APP.X Trigger X Table ----- APP.TRIGONE -> APP. Trigger StoredPreparedStatement ----- APP.TRIGONE ->

BAR.T3 Trigger T3 Table ----- APP.TrigThree -> APP. Trigger StoredPreparedStatement ----- APP.TrigThree ->

BAR.tWithKeys Trigger tWithKeys Table ----- BAR.REFTRIG -> BAR. Trigger StoredPreparedStatement ----- BAR.REFTRIG ->

BAR.T8 Trigger T8 Table ----- Foo Bar.TRIG2 -> Foo Bar. Trigger StoredPreparedStatement ----- Foo Bar.TRIG2 ->

BAR.T1 Trigger T1 Table ----- V1 APP.V1 -> APP.T1 View T1 ColumnsInTable ----- V1 APP.V1 -> BAR.T3 View T3 ColumnsInTable ----- V2 APP.V2 -> BAR.T1 View T1 ColumnsInTable ----- viewTwo BAR.viewTwo -> APP.T11 View T11 ColumnsInTable ----- V1 FOO.V1 -> Foo Bar.T6 View T6 ColumnsInTable ----- APP. -> BAR. StoredPreparedStatement Conglomerate ----- APP. -> BAR. StoredPreparedStatement Conglomerate ----- ========== SYSFILES ========== FOO FOOJAR ----- ========== SYSFOREIGNKEYS ========== U R ----- "effkay1 pee"kay1 R R ----- fkOne R S ----- pkTwo R R ----- ========== SYSKEYS ========== ----- ----- ----- ----- ----- UNQ ----- pee"kay1 ----- pkTwo ----- unqkay1" ----- ========== SYSSCHEMAS ========== "Quoted"Schema" "Quoted"Schema" APP ----- 'Single' and "double" quoted schema name 'Single' and "double" quoted schema name APP ----- APP APP APP ----- BAR BAR APP ----- FOO FOO APP ----- Foo Bar Foo Bar APP ----- schema "' schema "' APP ----- ========== SYSSTATEMENTS ========== APP T insert into removed select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLD where x not in (select x from new org.apache.derby.catalog.TriggerNewTransitionRows() NEW where x < 10) APP null ----- APP T select c from bar."tWithKeys" APP null ----- APP T update bar.t4 set j=8 where i=2 APP null ----- "Quoted"Schema" T values(8) APP null ----- BAR T select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLDTABLE APP null ----- Foo Bar T values (1), (2) APP null ----- ========== SYSTABLES ========== "tquoteTwo "tquoteTwo T APP R ----- 'Single' and "double" quoted table name 'Single' and "double" quoted table name T 'Single' and "double" quoted schema name R ----- MULTI WORD NAME MULTI WORD NAME T BAR R ----- REMOVED REMOVED T APP R ----- SYNONYM1 SYNONYM1 A APP R ----- SYNONYM2 SYNONYM2 A BAR R ----- SYNONYM3 SYNONYM3 A BAR R ----- T10 T10 T FOO R ----- T11 T11 T APP R ----- T1 T1 T APP R ----- T1 T1 T BAR R ----- T2 T2 T APP R ----- T3 T3 T BAR R ----- T3_2 T3_2 T BAR R ----- T4 T4 T BAR R ----- T4_2 T4_2 T BAR R ----- T5 T5 T Foo Bar R ----- T6 T6 T Foo Bar R ----- T7 T7 T Foo Bar R ----- T8T1T4 T8T1T4 T APP R ----- T8 T8 T BAR R ----- T9 T9 T FOO R ----- T_GENCOL_1 T_GENCOL_1 T APP R ----- T_GENCOL_2 T_GENCOL_2 T APP R ----- T_GENCOL_3 T_GENCOL_3 T APP R ----- V"3 V"3 V APP R ----- V1 V1 V APP R ----- V1 V1 V FOO R ----- V2 V2 V APP R ----- X X T APP R ----- tWithKeys tWithKeys T BAR R ----- tee""Hee tee""Hee T "Quoted"Schema" R ----- tquote"One tquote"One T APP R ----- tquoteThree" tquoteThree" T APP R ----- viewTwo viewTwo V BAR R ----- ========== SYSTRIGGERS ========== "trig"One" "Quoted"Schema" I A R E tee""Hee null null values(8) false false null null ----- REFTRIG BAR D A S E T8 null (1,2) select * from oldtable true false OLDTABLE null ----- TRIG2 Foo Bar D B S E T1 null null values (1), (2) false false null null ----- TRIGFOUR APP U A S E X null (1) insert into removed select * from old where x not in (select x from new where x < 10) true true OLD NEW ----- TRIGONE APP I A R E T3 null null update bar.t4 set j=8 where i=2 false false null null ----- TrigThree APP U A R E tWithKeys null (1,2) select c from bar."tWithKeys" false false null null ----- ========== SYSVIEWS ========== V"3 create view "V""3"(i) as values (8), (28), (78) N APP ----- V1 create view v1 (dum, dee, dokie) as select a.d, a.c, b.p1 from t1 as a, bar.t3 as b N APP ----- V1 create view v1 (doo, dwa) as select num, letter from "Foo Bar".t6 N FOO ----- V2 create view v2 as select * from bar.t1 N APP ----- viewTwo create view bar."viewTwo" as select * from app.t11 N APP ----- ========== SYSROLES ========== "eve" APP _SYSTEM Y Y ----- "eve" B APP N N ----- A APP _SYSTEM Y Y ----- A B APP N N ----- B APP _SYSTEM Y Y ----- B WHOMEVER APP N N ----- Database 'wombat_new' deleted. [ Done. ]