-= 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" ---- VARARGSDERBYSTYLE APP Foo F F false foo("A" INTEGER ... ) RETURNS INTEGER LANGUAGE JAVA PARAMETER STYLE DERBY NO SQL CALLED ON NULL INPUT ---- VARARGSDERBYSTYLE APP Foo P P false foo(IN "A" INTEGER ... ) LANGUAGE JAVA PARAMETER STYLE DERBY NO SQL ---- VARARGSTABLEFUNCTION APP Foo F F false foo("A" INTEGER ... ) RETURNS TABLE ( "B" INTEGER ) LANGUAGE JAVA PARAMETER STYLE DERBY_JDBC_RESULT_SET NO SQL CALLED ON NULL INPUT ---- 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 false ---- "tquoteTwo "iq2 2 INTEGER null null null null false ---- 'Single' and "double" quoted table name 'Single' and "double" quoted column name 1 INTEGER null null null null false ---- MULTI WORD NAME C 1 CHAR(2) null null null null false ---- REMOVED X 1 INTEGER null null null null false ---- T10 K 2 INTEGER NOT NULL null null null null false ---- T10 UK 3 CHAR(3) NOT NULL null null null null false ---- T10 VACH 1 VARCHAR(12) null null null null false ---- T11 LOLA 2 INTEGER null null null null false ---- T11 MYCHAR 1 CHAR(8) null null null null false ---- T1 C 2 CHAR(8) null null null null false ---- T1 C 2 CLOB(15) null null null null false ---- T1 D 3 DATE null null null null false ---- T1 F 4 DOUBLE NOT NULL null null null null false ---- T1 I 1 INTEGER null null null null false ---- T1 P1 1 VARCHAR(10) NOT NULL null null null null false ---- T2 B 2 BLOB(20) null null null null false ---- T2 C 3 CLOB(15) null null null null false ---- T2 P1 1 VARCHAR(10) null null null null false ---- T3 B 2 BLOB(20) null null null null false ---- T3 ID 3 INTEGER NOT NULL null null 2 4 false ---- T3 P1 1 VARCHAR(10) 'okie' null null false ---- T3_2 B 2 BLOB(20) null null null null false ---- T3_2 ID 3 INTEGER NOT NULL GENERATED_BY_DEFAULT 2 4 false ---- T3_2 P1 1 VARCHAR(10) 'okie' null null false ---- T4 I 1 INTEGER 2 null null false ---- T4 J 2 INTEGER NOT NULL null null null null false ---- T4 K 3 INTEGER NOT NULL null null 1 1 false ---- T4_2 I 1 INTEGER 2 null null false ---- T4_2 J 2 INTEGER NOT NULL null null null null false ---- T4_2 K 3 INTEGER NOT NULL GENERATED_BY_DEFAULT 1 1 false ---- T5 COST 1 DOUBLE null null null null false ---- T6 LETTER 2 CHAR(1) null null null null false ---- T6 NUM 1 INTEGER null null null null false ---- T7 DEUX 2 INTEGER null null null null false ---- T7 UN 1 INTEGER null null null null false ---- T8 FKCHAR 2 CHAR(5) null null null null false ---- T8 SOMEINT 1 INTEGER NOT NULL null null null null false ---- T8T1T4 C1 1 CHAR(4) 'okie' null null false ---- T8T1T4 C2 2 CHAR(4) 'doki' null null false ---- T9 CH 2 CHAR(8) NOT NULL null null null null false ---- T9 FKINT 1 INTEGER NOT NULL null null null null false ---- T_GENCOL_1 A 1 INTEGER null null null null false ---- T_GENCOL_1 B 2 INTEGER GENERATED ALWAYS AS ( 1 ) null null false ---- T_GENCOL_1 C 3 INTEGER null null null null false ---- T_GENCOL_2 A 1 INTEGER null null null null false ---- T_GENCOL_2 B 2 INTEGER null null false ---- T_GENCOL_2 C 3 INTEGER null null null null false ---- T_GENCOL_3 A 1 INTEGER null null null null false ---- T_GENCOL_3 B 2 INTEGER GENERATED ALWAYS AS ( a + c ) null null false ---- T_GENCOL_3 C 3 INTEGER null null null null false ---- V"3 I 1 INTEGER NOT NULL null null null null false ---- V1 DEE 2 CHAR(8) null null null null false ---- V1 DOKIE 3 VARCHAR(10) null null null null false ---- V1 DOO 1 INTEGER null null null null false ---- V1 DUM 1 DATE null null null null false ---- V1 DWA 2 CHAR(1) null null null null false ---- V2 C 2 CLOB(15) null null null null false ---- V2 P1 1 VARCHAR(10) NOT NULL null null null null false ---- X X 1 INTEGER null null null null false ---- tWithKeys C 1 CHAR(5) NOT NULL null null null null false ---- tWithKeys I 2 INTEGER null null null null false ---- tWithKeys VC 3 VARCHAR(10) null null null null false ---- tee""Hee N 1 CHAR(1) NOT NULL null null null null false ---- tquote"One i"q1 1 INTEGER NOT NULL null null null null false ---- tquote"One i"q2 2 INTEGER 8 null null false ---- tquoteThree" iq1" 1 INTEGER NOT NULL null null null null false ---- tquoteThree" iq2" 2 INTEGER null null null null false ---- viewTwo LOLA 2 INTEGER null null null null false ---- viewTwo MYCHAR 1 CHAR(8) null null null null false ---- --- 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 Conglomerate ---- APP.TRIGFOUR -> APP. Trigger StoredPreparedStatement ---- APP.TRIGFOUR ->

APP.REMOVED Trigger REMOVED Table ---- APP.TRIGFOUR ->

APP.X Trigger X Table ---- APP.TRIGONE -> BAR.T4 Trigger T4 ColumnsInTable ---- APP.TRIGONE -> APP. Trigger StoredPreparedStatement ---- APP.TRIGONE ->

BAR.T3 Trigger T3 Table ---- APP.TRIGWHEN ->

APP.T1 Trigger T1 Table ---- APP.TrigThree -> BAR.tWithKeys Trigger tWithKeys ColumnsInTable ---- 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 ---- APP. ->

APP.T1 StoredPreparedStatement T1 Table ---- APP. ->

APP.T1 StoredPreparedStatement T1 Table ---- APP.TRIGWHEN -> APP. Trigger StoredPreparedStatement ---- APP.TRIGWHEN -> APP. Trigger StoredPreparedStatement ---- ========== 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 "APP"."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 ---- APP T values 1 APP null ---- APP T VALUES exists (select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLD where i > 4) 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 null ---- REFTRIG BAR D A S E T8 null null select * from oldtable true false OLDTABLE null null ---- TRIG2 Foo Bar D B S E T1 null null values (1), (2) false false null null null ---- TRIGFOUR APP U A S E X null (1) insert into "APP"."REMOVED" select * from old where x not in (select x from new where x < 10) true true OLD NEW null ---- TRIGONE APP I A R E T3 null null update "BAR"."T4" set j=8 where i=2 false false null null null ---- TRIGWHEN APP U A S E T1 null values 1 true false OLD null exists (select * from old where i > 4) ---- TrigThree APP U A R E tWithKeys null (1,2) select c from "BAR"."tWithKeys" false false null 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. ]