Index: java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/dblook_test_net_territory.out =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/dblook_test_net_territory.out (revision 0) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/dblook_test_net_territory.out (revision 0) @@ -0,0 +1,1954 @@ +-----= 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 + +----- + +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 + +----- + +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" + +----- + +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 +----- +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 +----- +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 + +----- +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 +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 +----- +APP +APP +APP +----- +BAR +BAR +APP +----- +FOO +FOO +APP +----- +Foo Bar +Foo Bar +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 +----- +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 +----- +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 + +null +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 +----- +Database 'wombat_new' deleted. +[ Done. ] Index: java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/dblook_test_net_territory.out =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/dblook_test_net_territory.out (revision 0) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/dblook_test_net_territory.out (revision 0) @@ -0,0 +1,1954 @@ +-----= 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 + +----- + +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 + +----- + +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" + +----- + +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 +----- +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 +----- +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 + +----- +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 +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 +----- +APP +APP +APP +----- +BAR +BAR +APP +----- +FOO +FOO +APP +----- +Foo Bar +Foo Bar +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 +----- +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 +----- +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 + +null +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 +----- +Database 'wombat_new' deleted. +[ Done. ] Index: java/testing/org/apache/derbyTesting/functionTests/master/dblook_test_territory.out =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/master/dblook_test_territory.out (revision 0) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/master/dblook_test_territory.out (revision 0) @@ -0,0 +1,5409 @@ +-= Start dblook Functional Tests. =- +Creating database 'wombat' from ddl script 'dblook_makeDB.sql' +Dumping system tables for 'wombat' +----------------=================--------------- +System Tables for: wombat +----------------=================--------------- +========== 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 + +---- + +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 + +---- + +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" + +---- + +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 +---- +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 +---- +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 + +---- +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 +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. ->
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 +---- + +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 +---- +APP +APP +APP +---- +BAR +BAR +APP +---- +FOO +FOO +APP +---- +Foo Bar +Foo Bar +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 +---- +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 +---- +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 + +null +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 +---- +-- +******************************************* +Dumping full schema for 'wombat' +to file 'wombat.sql': +******************************************* +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 + +---- + +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 + +---- + +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" + +---- + +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 +---- +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 +---- +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 + +---- +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 +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 +---- +APP +APP +APP +---- +BAR +BAR +APP +---- +FOO +FOO +APP +---- +Foo Bar +Foo Bar +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 +---- +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 +---- +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 + +null +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 +---- +Database 'wombat_new' deleted. +-- +******************************************* +Dumping DDL for all objects with schema +'BAR', excluding views: +******************************************* +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 ========== + +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 + +---- + +SYNONYM2 +BAR +null +S +S +false +"BAR"."MULTI WORD NAME" + +---- + +SYNONYM3 +BAR +null +S +S +false +"APP"."T11" + +---- +========== SYSCHECKS ========== + +(i > 0) +(2) +---- +NOTEVIL +(vc != 'evil') +(3) +---- +========== SYSCOLUMNS ========== +--- Columns for Tables --- +MULTI WORD NAME +C +1 +CHAR(2) +null +null + +null +null +---- +T1 +C +2 +CLOB(15) +null +null + +null +null +---- +T1 +P1 +1 +VARCHAR(10) NOT NULL +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 +---- +T8 +FKCHAR +2 +CHAR(5) +null +null + +null +null +---- +T8 +SOMEINT +1 +INTEGER NOT NULL +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 +---- +--- Columns for Statements --- +========== SYSCONGLOMERATES ========== +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 + +---- +========== SYSCONSTRAINTS ========== + +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 +---- +UNQ +T1 +UNQ +U +BAR +E +0 +---- +========== SYSDEPENDS ========== + +BAR. -> BAR. +Constraint + +Constraint +---- + +BAR. ->
BAR.T8 +StoredPreparedStatement +T8 +Table +---- + +BAR.REFTRIG -> BAR. +Trigger + +StoredPreparedStatement +---- + +BAR.REFTRIG ->
BAR.T8 +Trigger +T8 +Table +---- +========== SYSFILES ========== +========== SYSFOREIGNKEYS ========== + + + +U +R +---- +========== SYSKEYS ========== + + +---- + + +---- +UNQ + +---- +========== SYSSCHEMAS ========== +APP +APP +APP +---- +BAR +BAR +APP +---- +========== SYSSTATEMENTS ========== + + +BAR +T + +select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLDTABLE + +APP +null +---- +========== SYSTABLES ========== +MULTI WORD NAME +MULTI WORD NAME +T +BAR +R +---- +SYNONYM2 +SYNONYM2 +A +BAR +R +---- +SYNONYM3 +SYNONYM3 +A +BAR +R +---- +T1 +T1 +T +BAR +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 +---- +T8 +T8 +T +BAR +R +---- +tWithKeys +tWithKeys +T +BAR +R +---- +========== SYSTRIGGERS ========== + +REFTRIG +BAR + +D +A +S +E +T8 +null + +null +select * from oldtable +true +false +OLDTABLE +null +---- +========== SYSVIEWS ========== +Database 'wombat_new' deleted. +-- +******************************************* +Dumping DDL for all objects with schema 'BAR' +that are related to tables 'T3', 'tWithKeys', +and 'MULTI WORD NAME': +******************************************* +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 ========== + +SYNONYM2 +BAR +null +S +S +false +"BAR"."MULTI WORD NAME" + +---- + +SYNONYM3 +BAR +null +S +S +false +"APP"."T11" + +---- +========== SYSCHECKS ========== + +(i > 0) +(2) +---- +NOTEVIL +(vc != 'evil') +(3) +---- +========== SYSCOLUMNS ========== +--- Columns for Tables --- +MULTI WORD NAME +C +1 +CHAR(2) +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 +---- +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 +---- +--- Columns for Statements --- +========== SYSCONGLOMERATES ========== +BAR +MULTI WORD NAME + +MULTI WORD NAME +false +null +false + +---- +BAR +T3 + +IX2 +true +BTREE (1 DESC, 3 DESC) +false + +---- +BAR +T3 + +T3 +false +null +false + +---- +BAR +tWithKeys + + +true +UNIQUE BTREE (1) +true + +---- +BAR +tWithKeys + +IX3 +true +BTREE (1 DESC) +false + +---- +BAR +tWithKeys + +tWithKeys +false +null +false + +---- +========== SYSCONSTRAINTS ========== + +tWithKeys + +C +BAR +E +0 +---- + +tWithKeys + +P +BAR +E +0 +---- +NOTEVIL +tWithKeys +NOTEVIL +C +BAR +E +0 +---- +========== SYSDEPENDS ========== +========== SYSFILES ========== +========== SYSFOREIGNKEYS ========== +========== SYSKEYS ========== + + +---- +========== SYSSCHEMAS ========== +APP +APP +APP +---- +BAR +BAR +APP +---- +========== SYSSTATEMENTS ========== +========== SYSTABLES ========== +MULTI WORD NAME +MULTI WORD NAME +T +BAR +R +---- +SYNONYM2 +SYNONYM2 +A +BAR +R +---- +SYNONYM3 +SYNONYM3 +A +BAR +R +---- +T3 +T3 +T +BAR +R +---- +tWithKeys +tWithKeys +T +BAR +R +---- +========== SYSTRIGGERS ========== +========== SYSVIEWS ========== +Database 'wombat_new' deleted. +-- +******************************************* +Dumping DDL for all objects related to 'T1' +and 'TWITHKEYS': +******************************************* +File dblook.log was empty. +Creating database 'wombat_new' from ddl script 'wombat.sql' +FAILED: to execute cmd from DDL script: +create view v1 (dum, dee, dokie) as select a.d, a.c, b.p1 from t1 as a, bar.t3 as b +Table/View 'BAR.T3' does not exist. +Dumping system tables for 'wombat_new' +----------------=================--------------- +System Tables for: wombat_new +----------------=================--------------- +========== SYSALIASES ========== + +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" + +---- +========== SYSCHECKS ========== +========== SYSCOLUMNS ========== +--- Columns for Tables --- +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 +---- +V2 +C +2 +CLOB(15) +null +null + +null +null +---- +V2 +P1 +1 +VARCHAR(10) NOT NULL +null +null + +null +null +---- +--- Columns for Statements --- +========== SYSCONGLOMERATES ========== +APP +T1 + +IX1 +true +BTREE (4, 1) +false + +---- +APP +T1 + +T1 +false +null +false + +---- +BAR +T1 + + +true +UNIQUE BTREE (1) +true + +---- +BAR +T1 + +T1 +false +null +false + +---- +========== SYSCONSTRAINTS ========== +UNQ +T1 +UNQ +U +BAR +E +0 +---- +========== SYSDEPENDS ========== + +Foo Bar. ->
BAR.T1 +StoredPreparedStatement +T1 +Table +---- + +Foo Bar.TRIG2 -> Foo Bar. +Trigger + +StoredPreparedStatement +---- + +Foo Bar.TRIG2 ->
BAR.T1 +Trigger +T1 +Table +---- +V2 +APP.V2 -> BAR.T1 +View +T1 +ColumnsInTable +---- +========== SYSFILES ========== +========== SYSFOREIGNKEYS ========== +========== SYSKEYS ========== +UNQ + +---- +========== SYSSCHEMAS ========== +APP +APP +APP +---- +BAR +BAR +APP +---- +Foo Bar +Foo Bar +APP +---- +========== SYSSTATEMENTS ========== + + +Foo Bar +T + +values (1), (2) + +APP +null +---- +========== SYSTABLES ========== +SYNONYM1 +SYNONYM1 +A +APP +R +---- +SYNONYM2 +SYNONYM2 +A +BAR +R +---- +SYNONYM3 +SYNONYM3 +A +BAR +R +---- +T1 +T1 +T +APP +R +---- +T1 +T1 +T +BAR +R +---- +V2 +V2 +V +APP +R +---- +========== SYSTRIGGERS ========== + +TRIG2 +Foo Bar + +D +B +S +E +T1 +null + +null +values (1), (2) +false +false +null +null +---- +========== SYSVIEWS ========== +V2 +create view v2 as select * from bar.t1 +N +APP +---- +Database 'wombat_new' deleted. +-- +******************************************* +Dumping DDL for all objects with schema +'"Quoted"Schema"': +******************************************* +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 ========== +========== SYSCHECKS ========== +========== SYSCOLUMNS ========== +--- Columns for Tables --- +tee""Hee +N +1 +CHAR(1) NOT NULL +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 + +---- +========== SYSCONSTRAINTS ========== + +tee""Hee + +P +"Quoted"Schema" +E +0 +---- +========== SYSDEPENDS ========== + +"Quoted"Schema". ->
"Quoted"Schema".tee""Hee +StoredPreparedStatement +tee""Hee +Table +---- + +"Quoted"Schema"."trig"One" -> "Quoted"Schema". +Trigger + +StoredPreparedStatement +---- + +"Quoted"Schema"."trig"One" ->
"Quoted"Schema".tee""Hee +Trigger +tee""Hee +Table +---- +========== SYSFILES ========== +========== SYSFOREIGNKEYS ========== +========== SYSKEYS ========== + + +---- +========== SYSSCHEMAS ========== +"Quoted"Schema" +"Quoted"Schema" +APP +---- +APP +APP +APP +---- +========== SYSSTATEMENTS ========== + + +"Quoted"Schema" +T + +values(8) + +APP +null +---- +========== SYSTABLES ========== +tee""Hee +tee""Hee +T +"Quoted"Schema" +R +---- +========== SYSTRIGGERS ========== + +"trig"One" +"Quoted"Schema" + +I +A +R +E +tee""Hee +null + +null +values(8) +false +false +null +null +---- +========== SYSVIEWS ========== +Database 'wombat_new' deleted. +-- +******************************************* +Dumping DDL w/ invalid url, and writing +error to the log: +******************************************* +File dblook.log was NOT empty. Contents are: +############## Begin File Contents ################ +java.sql.SQLException: No suitable driver +-- **--> DEBUG: No suitable driver +############## End File Contents ################ +Creating database 'wombat_new' from ddl script 'wombat.sql' +Dumping system tables for 'wombat_new' +----------------=================--------------- +System Tables for: wombat_new +----------------=================--------------- +========== SYSALIASES ========== +========== SYSCHECKS ========== +========== SYSCOLUMNS ========== +--- Columns for Tables --- +--- Columns for Statements --- +========== SYSCONGLOMERATES ========== +========== SYSCONSTRAINTS ========== +========== SYSDEPENDS ========== +========== SYSFILES ========== +========== SYSFOREIGNKEYS ========== +========== SYSKEYS ========== +========== SYSSCHEMAS ========== +APP +APP +APP +---- +========== SYSSTATEMENTS ========== +========== SYSTABLES ========== +========== SYSTRIGGERS ========== +========== SYSVIEWS ========== +Database 'wombat_new' deleted. +-= Start dblook Message Tests =- +Database 'wombat' deleted. +Creating database 'wombat' from ddl script 'dblook_makeDB_2.sql' +************ +Msg Test 1 +************ +-- +******************************************* +Dumping full schema for 'wombat' +to file 'wombat.sql': +******************************************* +File wombat.sql was NOT empty. Contents are: +############## Begin File Contents ################ +-- ============================ +-- This file was created using Derby's dblook utility. +-- Timestamp: xxxxxxFILTERED-TIMESTAMPxxxxx +-- Source database is: +-- Connection URL is: +-- appendLogs: false +-- ---------------------------------------------- +-- DDL Statements for schemas +-- ---------------------------------------------- +CREATE SCHEMA "BAR" +-- ---------------------------------------------- +-- DDL Statements for jars +-- **** NOTE **** In order for jar files to be loaded correctly, +-- you must either 1) ensure that the DBJARS directory (created +-- automatically by dblook) exists where it was created (i.e. at +-- the path shown in the statements below), or else 2) change the +-- path in the statements below to reflect the current location of +-- DBJARS. If the DBJARS directory does not exist, or if it +-- has been moved and the path is not correct, the following DDL +-- statements will throw errors, and the jar files will NOT be +-- loaded. +-- ---------------------------------------------- +CALL SQLJ.INSTALL_JAR() +-- ---------------------------------------------- +-- DDL Statements for stored procedures +-- ---------------------------------------------- +CREATE PROCEDURE "APP"."PROC1" (INOUT A CHAR(10),IN B INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL DYNAMIC RESULT SETS 4 EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.inoutparams3' +-- ---------------------------------------------- +-- DDL Statements for functions +-- ---------------------------------------------- +CREATE FUNCTION "APP"."GATP" (SCH VARCHAR(128),TBL VARCHAR(128)) RETURNS VARCHAR(1000) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL CALLED ON NULL INPUT EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestPropertyInfo.getAllTableProperties' +-- ---------------------------------------------- +-- DDL Statements for tables +-- ---------------------------------------------- +CREATE TABLE "BAR"."T1" ("C" CHAR(5) NOT NULL, "I" INTEGER, "VC" VARCHAR(10), "FKCHAR" CHAR(5)) +-- ---------------------------------------------- +-- DDL Statements for indexes +-- ---------------------------------------------- +CREATE INDEX "BAR"."IX1" ON "BAR"."T1" ("I" DESC) +-- ---------------------------------------------- +-- DDL Statements for Synonyms +-- ---------------------------------------------- +CREATE SYNONYM "APP"."SYN1" FOR "BAR"."T1" +-- ---------------------------------------------- +-- DDL Statements for keys +-- ---------------------------------------------- +-- primary/unique +ALTER TABLE "BAR"."T1" ADD CONSTRAINT "xxxxGENERATED-IDxxxx" PRIMARY KEY ("C") +-- foreign +ALTER TABLE "BAR"."T1" ADD CONSTRAINT "xxxxGENERATED-IDxxxx" FOREIGN KEY ("FKCHAR") REFERENCES "BAR"."T1" ("C") ON DELETE NO ACTION ON UPDATE NO ACTION +-- ---------------------------------------------- +-- DDL Statements for checks +-- ---------------------------------------------- +ALTER TABLE "BAR"."T1" ADD CONSTRAINT "NOTEVIL" CHECK (vc != 'evil') +-- ---------------------------------------------- +-- DDL Statements for views +-- ---------------------------------------------- +SET SCHEMA "APP" +create view v1 (dum, dee, dokie) as select a.c, a.i, a.vc from bar.t1 as a +-- Reverting back to default schema 'APP' +SET SCHEMA "APP" +-- ---------------------------------------------- +-- DDL Statements for triggers +-- ---------------------------------------------- +CREATE TRIGGER "APP"."TRIGONE" AFTER INSERT ON "BAR"."T1" FOR EACH ROW update bar.t1 set i = 4 where i = 2 +############## End File Contents ################ +File dblook.log was empty. +************ +Msg Test 2 +************ +File wombat.sql was NOT empty. Contents are: +############## Begin File Contents ################ +-- ============================ +-- This file was created using Derby's dblook utility. +-- Timestamp: xxxxxxFILTERED-TIMESTAMPxxxxx +-- Source database is: +-- Connection URL is: +-- The dblook utility will consider only specified tables. +-- Specified schema is: bar +-- appendLogs: false +-- ---------------------------------------------- +-- DDL Statements for schemas +-- ---------------------------------------------- +CREATE SCHEMA "BAR"; +-- ---------------------------------------------- +-- DDL Statements for tables +-- ---------------------------------------------- +CREATE TABLE "BAR"."T1" ("C" CHAR(5) NOT NULL, "I" INTEGER, "VC" VARCHAR(10), "FKCHAR" CHAR(5)); +-- ---------------------------------------------- +-- DDL Statements for indexes +-- ---------------------------------------------- +CREATE INDEX "BAR"."IX1" ON "BAR"."T1" ("I" DESC); +-- ---------------------------------------------- +-- DDL Statements for keys +-- ---------------------------------------------- +-- primary/unique +ALTER TABLE "BAR"."T1" ADD CONSTRAINT "xxxxGENERATED-IDxxxx" PRIMARY KEY ("C"); +-- foreign +ALTER TABLE "BAR"."T1" ADD CONSTRAINT "xxxxGENERATED-IDxxxx" FOREIGN KEY ("FKCHAR") REFERENCES "BAR"."T1" ("C") ON DELETE NO ACTION ON UPDATE NO ACTION; +-- ---------------------------------------------- +-- DDL Statements for checks +-- ---------------------------------------------- +ALTER TABLE "BAR"."T1" ADD CONSTRAINT "NOTEVIL" CHECK (vc != 'evil'); +############## End File Contents ################ +File dblook.log was empty. +************ +Msg Test 3 +************ + USAGE: + java org.apache.derby.tools.dblook -d [OPTIONS] + where the source URL is the full URL, including the connection protocol + and any connection attributes that might apply. For example, use + 'jdbc:derby:myDB', or 'jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB;user=usr;'. + options include: + -z to specify a schema to which the DDL generation + should be limited. Only database objects with that schema will have + their DDL generated. + -t ... to specify a list of tables for which + the DDL will be generated; any tables not in the list will be ignored. + -td to specify what should be appended to the end + of each DDL statement. + This defaults to ';'. + -noview to prevent the generation of DDL for views. + -append to keep from overwriting the output files. + -verbose to have error messages printed to the console (in addition + to the log file). If not specified, errors will only be printed to the + log file. + -o to specify the file name to which the generated DDL + will be written. + If not specified, default is the console. +************ +Msg Test 4 +************ +-- Timestamp: xxxxxxFILTERED-TIMESTAMPxxxxx +-- Source database is: +-- Connection URL is: +-- appendLogs: false +-- ---------------------------------------------- +-- DDL Statements for schemas +-- ---------------------------------------------- +CREATE SCHEMA "BAR" # +-- ---------------------------------------------- +-- DDL Statements for jars +-- **** NOTE **** In order for jar files to be loaded correctly, +-- you must either 1) ensure that the DBJARS directory (created +-- automatically by dblook) exists where it was created (i.e. at +-- the path shown in the statements below), or else 2) change the +-- path in the statements below to reflect the current location of +-- DBJARS. If the DBJARS directory does not exist, or if it +-- has been moved and the path is not correct, the following DDL +-- statements will throw errors, and the jar files will NOT be +-- loaded. +-- ---------------------------------------------- +CALL SQLJ.INSTALL_JAR() +-- ---------------------------------------------- +-- DDL Statements for stored procedures +-- ---------------------------------------------- +CREATE PROCEDURE "APP"."PROC1" (INOUT A CHAR(10),IN B INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL DYNAMIC RESULT SETS 4 EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.inoutparams3' # +-- ---------------------------------------------- +-- DDL Statements for functions +-- ---------------------------------------------- +CREATE FUNCTION "APP"."GATP" (SCH VARCHAR(128),TBL VARCHAR(128)) RETURNS VARCHAR(1000) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL CALLED ON NULL INPUT EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestPropertyInfo.getAllTableProperties' # +-- ---------------------------------------------- +-- DDL Statements for tables +-- ---------------------------------------------- +CREATE TABLE "BAR"."T1" ("C" CHAR(5) NOT NULL, "I" INTEGER, "VC" VARCHAR(10), "FKCHAR" CHAR(5)) # +-- ---------------------------------------------- +-- DDL Statements for indexes +-- ---------------------------------------------- +CREATE INDEX "BAR"."IX1" ON "BAR"."T1" ("I" DESC) # +-- ---------------------------------------------- +-- DDL Statements for Synonyms +-- ---------------------------------------------- +CREATE SYNONYM "APP"."SYN1" FOR "BAR"."T1" # +-- ---------------------------------------------- +-- DDL Statements for keys +-- ---------------------------------------------- +-- primary/unique +ALTER TABLE "BAR"."T1" ADD CONSTRAINT "xxxxGENERATED-IDxxxx" PRIMARY KEY ("C") # +-- foreign +ALTER TABLE "BAR"."T1" ADD CONSTRAINT "xxxxGENERATED-IDxxxx" FOREIGN KEY ("FKCHAR") REFERENCES "BAR"."T1" ("C") ON DELETE NO ACTION ON UPDATE NO ACTION # +-- ---------------------------------------------- +-- DDL Statements for checks +-- ---------------------------------------------- +ALTER TABLE "BAR"."T1" ADD CONSTRAINT "NOTEVIL" CHECK (vc != 'evil') # +-- ---------------------------------------------- +-- DDL Statements for views +-- ---------------------------------------------- +SET SCHEMA "APP" # +create view v1 (dum, dee, dokie) as select a.c, a.i, a.vc from bar.t1 as a # +-- Reverting back to default schema 'APP' +SET SCHEMA "APP" # +-- ---------------------------------------------- +-- DDL Statements for triggers +-- ---------------------------------------------- +CREATE TRIGGER "APP"."TRIGONE" AFTER INSERT ON "BAR"."T1" FOR EACH ROW update bar.t1 set i = 4 where i = 2 # +************ +Msg Test 5 +************ +File dblook.log was NOT empty. Contents are: +############## Begin File Contents ################ +-- **--> DEBUG: Failed to load jar file +java.io.FileNotFoundException: +############## End File Contents ################ +[ Done. ] Index: java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetClientRemote.exclude =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetClientRemote.exclude (revision 630969) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetClientRemote.exclude (working copy) @@ -7,6 +7,8 @@ # a database cannot be loaded by 2 different instances. # derbynet/dblook_test_net because it tries to search derby.log, which is on # the server machine +# derbynet/dblook_test_net_territory because it tries to search derby.log, which is on +# the server machine # derbynet/getCurrentProperties for it exercises NetworkServerControl statements # that are only supported on localhost # derbynet/maxthreads - tries to use NetworkServerControl statements @@ -23,6 +25,7 @@ # store/bootLock.java derbynet/dblook_test_net.java +derbynet/dblook_test_net_territory.java derbynet/getCurrentProperties.java derbynet/maxthreads.java derbynet/runtimeinfo.java Index: java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetClientUseprocess.exclude =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetClientUseprocess.exclude (revision 630969) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetClientUseprocess.exclude (working copy) @@ -5,6 +5,7 @@ # junitTests/derbyNet/CompatibilityTest.java - exits the suite # derbynet/DerbyNetAutoStart.java - exits the suite... # derbynet/dblook_test_net.java - expects different dir structure +# derbynet/dblook_test_net_territory.java - expects different dir structure # stress/stress.multi - exits suite # derbynet/getCurrentProperties.java - fails, different sessions # derbynet/runtimeinfo.java - different sessions @@ -21,6 +22,7 @@ junitTests/derbyNet/CompatibilityTest.java derbynet/DerbyNetAutoStart.java derbynet/dblook_test_net.java +derbynet/dblook_test_net_territory.java derbynet/getCurrentProperties.java derbynet/runtimeinfo.java derbynet/sysinfo.java Index: java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetRemote.exclude =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetRemote.exclude (revision 630969) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetRemote.exclude (working copy) @@ -7,6 +7,8 @@ # a database cannot be loaded by 2 different instances. # derbynet/dblook_test_net because it tries to search derby.log, which is on # the server machine +# derbynet/dblook_test_net_territory because it tries to search derby.log, which is on +# the server machine # derbynet/getCurrentProperties for it exercises NetworkServerControl statements # that are only supported on localhost # derbynet/maxthreads - tries to use NetworkServerControl statements @@ -22,6 +24,7 @@ # store/bootLock.java derbynet/dblook_test_net.java +derbynet/dblook_test_net_territory.java derbynet/getCurrentProperties.java derbynet/maxthreads.java derbynet/runtimeinfo.java Index: java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetUseprocess.exclude =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetUseprocess.exclude (revision 630969) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetUseprocess.exclude (working copy) @@ -6,6 +6,7 @@ # derbynet/DerbyNetAutoStart.java - exits suite... # derbynet/getCurrentProperties.java - fails with different sessions # derbynet/dblook_test_net.java - fails, test misses properties +# derbynet/dblook_test_net_territory.java - fails, test misses properties # derbynet/runtimeinfo.java - fails with already existing threads (maybe intermittent) # derbynet/sysinfo.java - fails because not access to java.class.path # derbynet/sysinfo_withproperties.java - fails because not access to java.class.path @@ -19,6 +20,7 @@ derbynet/DerbyNetAutoStart.java derbynet/getCurrentProperties.java derbynet/dblook_test_net.java +derbynet/dblook_test_net_territory.java derbynet/runtimeinfo.java derbynet/sysinfo.java derbynet/sysinfo_withproperties.java Index: java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.runall =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.runall (revision 630969) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.runall (working copy) @@ -1,4 +1,5 @@ derbynet/dblook_test_net.java +derbynet/dblook_test_net_territory.java derbynet/DerbyNetAutoStart.java derbynet/getCurrentProperties.java derbynet/maxthreads.java Index: java/testing/org/apache/derbyTesting/functionTests/suites/derbytools.runall =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/suites/derbytools.runall (revision 630969) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/suites/derbytools.runall (working copy) @@ -1,4 +1,5 @@ tools/dblook_test.java +tools/dblook_test_territory.java tools/derbyrunjartest.java tools/importExportThruIJ.sql tools/ij.sql Index: java/testing/org/apache/derbyTesting/functionTests/suites/j9derbynetmats.runall =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/suites/j9derbynetmats.runall (revision 630969) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/suites/j9derbynetmats.runall (working copy) @@ -1,4 +1,5 @@ derbynet/dblook_test_net.java +derbynet/dblook_test_net_territory.java derbynet/getCurrentProperties.java derbynet/maxthreads.java derbynet/runtimeinfo.java Index: java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/NetHarnessJavaTest.java =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/NetHarnessJavaTest.java (revision 630969) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/NetHarnessJavaTest.java (working copy) @@ -37,6 +37,7 @@ * The following tests could not be run this way, reasons for the * * dblook_test_net - filters output + * dblook_test_net_territory - filters output * getCurrentProperties - ExceptionInInitializerError, needs investigation * maxthreads - forks VM * runtimeinfo" - filters output Index: java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net.java =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net.java (revision 630969) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net.java (working copy) @@ -35,6 +35,7 @@ testDirectory = "dblook_test_net/"; new dblook_test_net().doTest(); System.out.println("\n[ Done. ]\n"); + renameDbLookLog("dblook_test_net"); } Index: java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory.java =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory.java (revision 0) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory.java (revision 0) @@ -0,0 +1,74 @@ +/* + + Derby - Class org.apache.derbyTesting.functionTests.tests.derbynet.dblook_test_net_territory + + Licensed to the Apache Software Foundation (ASF) under one or more + contributor license agreements. See the NOTICE file distributed with + this work for additional information regarding copyright ownership. + The ASF licenses this file to You under the Apache License, Version 2.0 + (the "License"); you may not use this file except in compliance with + the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, software + distributed under the License is distributed on an "AS IS" BASIS, + WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + See the License for the specific language governing permissions and + limitations under the License. + + */ + +package org.apache.derbyTesting.functionTests.tests.derbynet; + +import java.io.File; + +import org.apache.derbyTesting.functionTests.tests.tools.dblook_test; + +public class dblook_test_net_territory extends dblook_test { + + // This test runs dblook on a test database using + // a connection to the Network Server. + + public static void main (String [] args) { + + System.out.println("\n-= Start dblook (net server) Test. =-"); + + territoryBased = ";territory=nl_NL;collation=TERRITORY_BASED"; + testDirectory = "territory_dblook_test_net/"; + expectedCollation = "TERRITORY_BASED"; + separator = System.getProperty("file.separator"); + new dblook_test_net_territory().doTest(); + System.out.println("\n[ Done. ]\n"); + renameDbLookLog("dblook_test_net_territory"); + + } + + /* ********************************************** + * doTest + * Run a test of the dblook utility using + * Network Server. + ****/ + + protected void doTest() { + + try { + + createTestDatabase(dbCreationScript_1); + + // Don't let error stream ruin the diff. + System.err.close(); + + // The only test we need to run is the one for + // Network Server; see functionTests/tools/ + // dblook_test.java. + runTest(3, testDBName, testDBName + "_new"); + + } catch (Exception e) { + System.out.println("-=- FAILED: to complete the test:"); + e.printStackTrace(); + } + + } + +} Property changes on: Z:\src\derby-dev\java\testing\org\apache\derbyTesting\functionTests\tests\derbynet\dblook_test_net_territory.java ___________________________________________________________________ Name: svn:mime-type + text/plain Index: java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory_app.properties =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory_app.properties (revision 0) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory_app.properties (revision 0) @@ -0,0 +1,20 @@ +# Licensed to the Apache Software Foundation (ASF) under one or more +# contributor license agreements. See the NOTICE file distributed with +# this work for additional information regarding copyright ownership. +# The ASF licenses this file to you under the Apache License, Version 2.0 +# (the "License"); you may not use this file except in compliance with +# the License. You may obtain a copy of the License at +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, software +# distributed under the License is distributed on an "AS IS" BASIS, +# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +# See the License for the specific language governing permissions and +# limitations under the License. + +supportfiles=tests/tools/dblook_makeDB.sql,tests/tools/dblook_test.jar + +# disable security manager for now - due to DERBY-537 +noSecurityManager=true + Property changes on: Z:\src\derby-dev\java\testing\org\apache\derbyTesting\functionTests\tests\derbynet\dblook_test_net_territory_app.properties ___________________________________________________________________ Name: svn:mime-type + text/plain Index: java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test.java =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test.java (revision 630969) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test.java (working copy) @@ -63,13 +63,15 @@ private static final char TEST_DELIMITER='#'; protected static String testDirectory = "dblook_test"; - protected static final String testDBName = "wombat"; + protected static String testDBName = "wombat"; protected static String separator; private static String dbPath; private static int duplicateCounter = 0; private static int sysNameCount = 0; private static String jdbcProtocol; + protected static String territoryBased = ""; + protected static String expectedCollation = "UCS_BASIC"; /* ********************************************** * main: @@ -80,6 +82,7 @@ separator = System.getProperty("file.separator"); new dblook_test().doTest(); System.out.println("\n[ Done. ]\n"); + renameDbLookLog("dblook_test"); } @@ -720,8 +723,30 @@ Connection conn = DriverManager.getConnection( "jdbc:derby:" + dbName); conn.setAutoCommit(false); + + // Set the system schema to ensure that UCS_BASIC collation is used. Statement stmt = conn.createStatement(); + stmt.executeUpdate("SET SCHEMA SYS"); + // Ensure that the database has the expected collation type. + ResultSet rs = null; + try { + rs = stmt.executeQuery("VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.database.collation')"); + rs.next(); + String collation = rs.getString(1); + if (collation == null || !collation.equals(expectedCollation)) { + throw new SQLException("Collation doesn't match with the expected type " + + expectedCollation); + } + } catch (Exception e) { + System.out.println("FAILED: incorrect database collation\n"); + System.out.println(e.getMessage()); + } finally { + if (rs != null) { + rs.close(); + } + } + // Load any id-to-name mappings that will be useful // when dumping the catalogs. HashMap idToNameMap = loadIdMappings(stmt, conn); @@ -731,7 +756,7 @@ // won't cause diffs. writeOut("\n========== SYSALIASES ==========\n"); - ResultSet rs = + rs = stmt.executeQuery("select schemaid, sys.sysaliases.* from sys.sysaliases"); dumpResultSet(rs, idToNameMap, null); @@ -1187,7 +1212,7 @@ "' from ddl script '" + scriptName + "'"); Connection conn = DriverManager.getConnection( - "jdbc:derby:" + newDBName + ";create=true"); + "jdbc:derby:" + newDBName + ";create=true" + territoryBased); Statement stmt = conn.createStatement(); BufferedReader ddlScript = @@ -1506,6 +1531,39 @@ } /* ********************************************** + * renameDbLookLog: + * Checks if the logfile of dblook exists and + * tries to rename it to prevent possible + * next tests from failing. The log should not be + * deleted because the output may be examined in + * case a test fails. + * The new name of dblook.log should be dblook_testname#.log, + * where # is a 'version' number. The 'version' number is + * needed because the same test may be run multiple + * times with different parameters. + * @param nameOfTest Name of the finished test. + ****/ + + protected static void renameDbLookLog(String nameOfTest) + { + File dbLookTestLog = new File("dblook.log"); + if (dbLookTestLog.exists()) { + int i = 0; + String renamedLogName = nameOfTest + i + ".log"; + File renamedLog = new File(renamedLogName); + while (renamedLog.exists()) { + i++; + renamedLogName = nameOfTest + i + ".log"; + renamedLog = new File(renamedLogName); + } + if (!dbLookTestLog.renameTo(renamedLog)) { + System.out.println("Failed to rename dblook.org to " + + renamedLogName); + } + } + } + + /* ********************************************** * dumpFileToSysOut: * Checks to see if the received file is empty, * and prints a message saying so. Index: java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory.java =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory.java (revision 0) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory.java (revision 0) @@ -0,0 +1,44 @@ +/* + + Derby - Class org.apache.derbyTesting.functionTests.tests.tools.dblook_test_territory + + Licensed to the Apache Software Foundation (ASF) under one or more + contributor license agreements. See the NOTICE file distributed with + this work for additional information regarding copyright ownership. + The ASF licenses this file to You under the Apache License, Version 2.0 + (the "License"); you may not use this file except in compliance with + the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, software + distributed under the License is distributed on an "AS IS" BASIS, + WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + See the License for the specific language governing permissions and + limitations under the License. + + */ + +package org.apache.derbyTesting.functionTests.tests.tools; + +import java.io.File; + +public class dblook_test_territory extends dblook_test { + + /* ********************************************** + * main: + ****/ + + public static void main (String[] args) { + + territoryBased = ";territory=nl_NL;collation=TERRITORY_BASED"; + testDirectory = "territory_" + testDirectory; + expectedCollation = "TERRITORY_BASED"; + separator = System.getProperty("file.separator"); + new dblook_test_territory().doTest(); + System.out.println("\n[ Done. ]\n"); + renameDbLookLog("dblook_test_territory"); + + } + +} Property changes on: Z:\src\derby-dev\java\testing\org\apache\derbyTesting\functionTests\tests\tools\dblook_test_territory.java ___________________________________________________________________ Name: svn:mime-type + text/plain Index: java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory_app.properties =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory_app.properties (revision 0) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory_app.properties (revision 0) @@ -0,0 +1,22 @@ +# Licensed to the Apache Software Foundation (ASF) under one or more +# contributor license agreements. See the NOTICE file distributed with +# this work for additional information regarding copyright ownership. +# The ASF licenses this file to you under the Apache License, Version 2.0 +# (the "License"); you may not use this file except in compliance with +# the License. You may obtain a copy of the License at +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, software +# distributed under the License is distributed on an "AS IS" BASIS, +# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +# See the License for the specific language governing permissions and +# limitations under the License. + +supportfiles=tests/tools/dblook_makeDB.sql,tests/tools/dblook_makeDB_2.sql,tests/tools/dblook_test.jar + +#Exclude for J2ME/Foundation - test requires java.sql.DriverManager +runwithfoundation=false + +# disable security manager for now - DERBY-537 +noSecurityManager=true Property changes on: Z:\src\derby-dev\java\testing\org\apache\derbyTesting\functionTests\tests\tools\dblook_test_territory_app.properties ___________________________________________________________________ Name: svn:mime-type + text/plain Index: java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory_sed.properties =================================================================== --- Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory_sed.properties (revision 0) +++ Z:/src/derby-dev/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory_sed.properties (revision 0) @@ -0,0 +1,27 @@ +# Licensed to the Apache Software Foundation (ASF) under one or more +# contributor license agreements. See the NOTICE file distributed with +# this work for additional information regarding copyright ownership. +# The ASF licenses this file to you under the Apache License, Version 2.0 +# (the "License"); you may not use this file except in compliance with +# the License. You may obtain a copy of the License at +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, software +# distributed under the License is distributed on an "AS IS" BASIS, +# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +# See the License for the specific language governing permissions and +# limitations under the License. + +# Filters and substitutes for SED +# Multiple patterns for DELETE: comma separated +# delete=pattern1,pattern2,...,patternn +# No commas can be allowed in the patterns. +# +# Multiple patterns for SUBSTITUTE: comma separated pair +# substitute=pattern1;substitute1,pattern2;substitute2,...,patternn;substitut +en +# No commas or semicolons can be allowed in the patterns/subsitutes. +------------------------------------------------------------------------------- +-- +substitute=Source database is:.*$;Source database is: ,Connection URL is:.*$;Connection URL is: ,Failed to load jar file.*$;Failed to load jar file ,java.io.FileNotFoundException: .*$;java.io.FileNotFoundException: ,CALL SQLJ.INSTALL_JAR.*$;CALL SQLJ.INSTALL_JAR(),java.sql.SQLException: Driver not found: wombat;java.sql.SQLException: No suitable driver,DEBUG: Driver not found: wombat;DEBUG: No suitable driver,SQL Exception: Driver not found: wombat;java.sql.SQLException: No suitable driver Property changes on: Z:\src\derby-dev\java\testing\org\apache\derbyTesting\functionTests\tests\tools\dblook_test_territory_sed.properties ___________________________________________________________________ Name: svn:mime-type + text/plain