db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ma...@apache.org
Subject svn commit: r634037 [2/3] - in /db/derby/code/trunk/java: testing/org/apache/derbyTesting/functionTests/master/ testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ testing/...
Date Wed, 05 Mar 2008 21:25:56 GMT
Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dblook_test_territory.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dblook_test_territory.out?rev=634037&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dblook_test_territory.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dblook_test_territory.out Wed Mar  5 13:25:53 2008
@@ -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 ==========
+<systemid>
+"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
+<systemname>
+----
+<systemid>
+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
+<systemname>
+----
+<systemid>
+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
+<systemname>
+----
+<systemid>
+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
+<systemname>
+----
+<systemid>
+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
+<systemname>
+----
+<systemid>
+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
+<systemname>
+----
+<systemid>
+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
+<systemname>
+----
+<systemid>
+SYNONYM1
+APP
+null
+S
+S
+false
+"APP"."T1"
+<systemname>
+----
+<systemid>
+SYNONYM2
+BAR
+null
+S
+S
+false
+"BAR"."MULTI WORD NAME"
+<systemname>
+----
+<systemid>
+SYNONYM3
+BAR
+null
+S
+S
+false
+"APP"."T11"
+<systemname>
+----
+<systemid>
+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
+<systemname>
+----
+========== SYSCHECKS ==========
+<systemname>
+(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
+<autoincval>
+null
+null
+----
+"tquoteTwo
+"iq2
+2
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+MULTI WORD NAME
+C
+1
+CHAR(2)
+null
+null
+<autoincval>
+null
+null
+----
+REMOVED
+X
+1
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+T10
+K
+2
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T10
+UK
+3
+CHAR(3) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T10
+VACH
+1
+VARCHAR(12)
+null
+null
+<autoincval>
+null
+null
+----
+T11
+LOLA
+2
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+T11
+MYCHAR
+1
+CHAR(8)
+null
+null
+<autoincval>
+null
+null
+----
+T1
+C
+2
+CHAR(8)
+null
+null
+<autoincval>
+null
+null
+----
+T1
+C
+2
+CLOB(15)
+null
+null
+<autoincval>
+null
+null
+----
+T1
+D
+3
+DATE
+null
+null
+<autoincval>
+null
+null
+----
+T1
+F
+4
+DOUBLE NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T1
+I
+1
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+T1
+P1
+1
+VARCHAR(10) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T2
+B
+2
+BLOB(20)
+null
+null
+<autoincval>
+null
+null
+----
+T2
+C
+3
+CLOB(15)
+null
+null
+<autoincval>
+null
+null
+----
+T2
+P1
+1
+VARCHAR(10)
+null
+null
+<autoincval>
+null
+null
+----
+T3
+B
+2
+BLOB(20)
+null
+null
+<autoincval>
+null
+null
+----
+T3
+ID
+3
+INTEGER NOT NULL
+null
+null
+<autoincval>
+2
+4
+----
+T3
+P1
+1
+VARCHAR(10)
+'okie'
+<systemid>
+<autoincval>
+null
+null
+----
+T3_2
+B
+2
+BLOB(20)
+null
+null
+<autoincval>
+null
+null
+----
+T3_2
+ID
+3
+INTEGER NOT NULL
+GENERATED_BY_DEFAULT
+<systemid>
+<autoincval>
+2
+4
+----
+T3_2
+P1
+1
+VARCHAR(10)
+'okie'
+<systemid>
+<autoincval>
+null
+null
+----
+T4
+I
+1
+INTEGER
+2
+<systemid>
+<autoincval>
+null
+null
+----
+T4
+J
+2
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T4
+K
+3
+INTEGER NOT NULL
+null
+null
+<autoincval>
+1
+1
+----
+T4_2
+I
+1
+INTEGER
+2
+<systemid>
+<autoincval>
+null
+null
+----
+T4_2
+J
+2
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T4_2
+K
+3
+INTEGER NOT NULL
+GENERATED_BY_DEFAULT
+<systemid>
+<autoincval>
+1
+1
+----
+T5
+COST
+1
+DOUBLE
+null
+null
+<autoincval>
+null
+null
+----
+T6
+LETTER
+2
+CHAR(1)
+null
+null
+<autoincval>
+null
+null
+----
+T6
+NUM
+1
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+T7
+DEUX
+2
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+T7
+UN
+1
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+T8
+FKCHAR
+2
+CHAR(5)
+null
+null
+<autoincval>
+null
+null
+----
+T8
+SOMEINT
+1
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T8T1T4
+C1
+1
+CHAR(4)
+'okie'
+<systemid>
+<autoincval>
+null
+null
+----
+T8T1T4
+C2
+2
+CHAR(4)
+'doki'
+<systemid>
+<autoincval>
+null
+null
+----
+T9
+CH
+2
+CHAR(8) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T9
+FKINT
+1
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+V"3
+I
+1
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+V1
+DEE
+2
+CHAR(8)
+null
+null
+<autoincval>
+null
+null
+----
+V1
+DOKIE
+3
+VARCHAR(10)
+null
+null
+<autoincval>
+null
+null
+----
+V1
+DOO
+1
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+V1
+DUM
+1
+DATE
+null
+null
+<autoincval>
+null
+null
+----
+V1
+DWA
+2
+CHAR(1)
+null
+null
+<autoincval>
+null
+null
+----
+V2
+C
+2
+CLOB(15)
+null
+null
+<autoincval>
+null
+null
+----
+V2
+P1
+1
+VARCHAR(10) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+X
+X
+1
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+tWithKeys
+C
+1
+CHAR(5) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+tWithKeys
+I
+2
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+tWithKeys
+VC
+3
+VARCHAR(10)
+null
+null
+<autoincval>
+null
+null
+----
+tee""Hee
+N
+1
+CHAR(1) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+tquote"One
+i"q1
+1
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+tquote"One
+i"q2
+2
+INTEGER
+8
+<systemid>
+<autoincval>
+null
+null
+----
+tquoteThree"
+iq1"
+1
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+tquoteThree"
+iq2"
+2
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+viewTwo
+LOLA
+2
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+viewTwo
+MYCHAR
+1
+CHAR(8)
+null
+null
+<autoincval>
+null
+null
+----
+--- Columns for Statements ---
+========== SYSCONGLOMERATES ==========
+"Quoted"Schema"
+tee""Hee
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+"Quoted"Schema"
+tee""Hee
+<systemnumber>
+Ix"5
+true
+BTREE (1 DESC)
+false
+<systemid>
+----
+"Quoted"Schema"
+tee""Hee
+<systemnumber>
+tee""Hee
+false
+null
+false
+<systemid>
+----
+APP
+"tquoteTwo
+<systemnumber>
+<systemname>
+true
+BTREE (1)
+true
+<systemid>
+----
+APP
+"tquoteTwo
+<systemnumber>
+"tquoteTwo
+false
+null
+false
+<systemid>
+----
+APP
+REMOVED
+<systemnumber>
+REMOVED
+false
+null
+false
+<systemid>
+----
+APP
+T11
+<systemnumber>
+<systemname>
+true
+BTREE (1, 2)
+true
+<systemid>
+----
+APP
+T11
+<systemnumber>
+T11
+false
+null
+false
+<systemid>
+----
+APP
+T1
+<systemnumber>
+IX1
+true
+BTREE (4, 1)
+false
+<systemid>
+----
+APP
+T1
+<systemnumber>
+T1
+false
+null
+false
+<systemid>
+----
+APP
+T2
+<systemnumber>
+T2
+false
+null
+false
+<systemid>
+----
+APP
+T8T1T4
+<systemnumber>
+T8T1T4
+false
+null
+false
+<systemid>
+----
+APP
+X
+<systemnumber>
+X
+false
+null
+false
+<systemid>
+----
+APP
+tquote"One
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+APP
+tquote"One
+<systemnumber>
+tquote"One
+false
+null
+false
+<systemid>
+----
+APP
+tquoteThree"
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+APP
+tquoteThree"
+<systemnumber>
+tquoteThree"
+false
+null
+false
+<systemid>
+----
+BAR
+MULTI WORD NAME
+<systemnumber>
+MULTI WORD NAME
+false
+null
+false
+<systemid>
+----
+BAR
+T1
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+BAR
+T1
+<systemnumber>
+T1
+false
+null
+false
+<systemid>
+----
+BAR
+T3
+<systemnumber>
+IX2
+true
+BTREE (1 DESC, 3 DESC)
+false
+<systemid>
+----
+BAR
+T3
+<systemnumber>
+T3
+false
+null
+false
+<systemid>
+----
+BAR
+T3_2
+<systemnumber>
+T3_2
+false
+null
+false
+<systemid>
+----
+BAR
+T4
+<systemnumber>
+IX4
+true
+UNIQUE BTREE (3)
+false
+<systemid>
+----
+BAR
+T4
+<systemnumber>
+T4
+false
+null
+false
+<systemid>
+----
+BAR
+T4_2
+<systemnumber>
+T4_2
+false
+null
+false
+<systemid>
+----
+BAR
+T8
+<systemnumber>
+<systemname>
+true
+BTREE (2)
+true
+<systemid>
+----
+BAR
+T8
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+BAR
+T8
+<systemnumber>
+T8
+false
+null
+false
+<systemid>
+----
+BAR
+tWithKeys
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+BAR
+tWithKeys
+<systemnumber>
+IX3
+true
+BTREE (1 DESC)
+false
+<systemid>
+----
+BAR
+tWithKeys
+<systemnumber>
+tWithKeys
+false
+null
+false
+<systemid>
+----
+FOO
+T10
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (2)
+true
+<systemid>
+----
+FOO
+T10
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (3)
+true
+<systemid>
+----
+FOO
+T10
+<systemnumber>
+T10
+false
+null
+false
+<systemid>
+----
+FOO
+T9
+<systemnumber>
+<systemname>
+true
+BTREE (1)
+true
+<systemid>
+----
+FOO
+T9
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (2, 1)
+true
+<systemid>
+----
+FOO
+T9
+<systemnumber>
+T9
+false
+null
+false
+<systemid>
+----
+Foo Bar
+T5
+<systemnumber>
+CostIndex
+true
+UNIQUE BTREE (1)
+false
+<systemid>
+----
+Foo Bar
+T5
+<systemnumber>
+T5
+false
+null
+false
+<systemid>
+----
+Foo Bar
+T6
+<systemnumber>
+T6
+false
+null
+false
+<systemid>
+----
+Foo Bar
+T7
+<systemnumber>
+T7
+false
+null
+false
+<systemid>
+----
+========== SYSCONSTRAINTS ==========
+"ck2
+"tquoteTwo
+"ck2
+C
+APP
+E
+0
+----
+"effkay1
+"tquoteTwo
+"effkay1
+F
+APP
+E
+0
+----
+<systemname>
+T10
+<systemname>
+P
+FOO
+E
+1
+----
+<systemname>
+T10
+<systemname>
+U
+FOO
+E
+0
+----
+<systemname>
+T8
+<systemname>
+F
+BAR
+E
+0
+----
+<systemname>
+T8
+<systemname>
+P
+BAR
+E
+0
+----
+<systemname>
+tWithKeys
+<systemname>
+C
+BAR
+E
+0
+----
+<systemname>
+tWithKeys
+<systemname>
+P
+BAR
+E
+1
+----
+NOTEVIL
+tWithKeys
+NOTEVIL
+C
+BAR
+E
+0
+----
+<systemname>
+T11
+<systemname>
+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
+----
+<systemname>
+tee""Hee
+<systemname>
+P
+"Quoted"Schema"
+E
+0
+----
+unqkay1"
+tquoteThree"
+unqkay1"
+U
+APP
+E
+0
+----
+========== SYSDEPENDS ==========
+"effkay1
+<Constraint>APP."effkay1 -> <Constraint>APP.pee"kay1
+Constraint
+pee"kay1
+Constraint
+----
+<systemname>
+<Constraint>APP.<sysname> -> <Constraint>FOO.pkTwo
+Constraint
+pkTwo
+Constraint
+----
+<systemname>
+<Constraint>BAR.<sysname> -> <Constraint>BAR.<sysname>
+Constraint
+<systemname>
+Constraint
+----
+fkOne
+<Constraint>FOO.fkOne -> <Constraint>FOO.<sysname>
+Constraint
+<systemname>
+Constraint
+----
+<systemid>
+<StoredPreparedStatement>"Quoted"Schema".<sysname> -> <Table>"Quoted"Schema".tee""Hee
+StoredPreparedStatement
+tee""Hee
+Table
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <ColumnsInTable>BAR.T4
+StoredPreparedStatement
+T4
+ColumnsInTable
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <ColumnsInTable>BAR.tWithKeys
+StoredPreparedStatement
+tWithKeys
+ColumnsInTable
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <Conglomerate>APP.<sysname>
+StoredPreparedStatement
+<systemid>
+Conglomerate
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <Table>APP.REMOVED
+StoredPreparedStatement
+REMOVED
+Table
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <Table>APP.X
+StoredPreparedStatement
+X
+Table
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <Table>BAR.T3
+StoredPreparedStatement
+T3
+Table
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <Table>BAR.tWithKeys
+StoredPreparedStatement
+tWithKeys
+Table
+----
+<systemid>
+<StoredPreparedStatement>BAR.<sysname> -> <Table>BAR.T8
+StoredPreparedStatement
+T8
+Table
+----
+<systemid>
+<StoredPreparedStatement>Foo Bar.<sysname> -> <Table>BAR.T1
+StoredPreparedStatement
+T1
+Table
+----
+<systemid>
+<Trigger>"Quoted"Schema"."trig"One" -> <StoredPreparedStatement>"Quoted"Schema".<sysname>
+Trigger
+<systemid>
+StoredPreparedStatement
+----
+<systemid>
+<Trigger>"Quoted"Schema"."trig"One" -> <Table>"Quoted"Schema".tee""Hee
+Trigger
+tee""Hee
+Table
+----
+<systemid>
+<Trigger>APP.TRIGFOUR -> <StoredPreparedStatement>APP.<sysname>
+Trigger
+<systemid>
+StoredPreparedStatement
+----
+<systemid>
+<Trigger>APP.TRIGFOUR -> <Table>APP.X
+Trigger
+X
+Table
+----
+<systemid>
+<Trigger>APP.TRIGONE -> <StoredPreparedStatement>APP.<sysname>
+Trigger
+<systemid>
+StoredPreparedStatement
+----
+<systemid>
+<Trigger>APP.TRIGONE -> <Table>BAR.T3
+Trigger
+T3
+Table
+----
+<systemid>
+<Trigger>APP.TrigThree -> <StoredPreparedStatement>APP.<sysname>
+Trigger
+<systemid>
+StoredPreparedStatement
+----
+<systemid>
+<Trigger>APP.TrigThree -> <Table>BAR.tWithKeys
+Trigger
+tWithKeys
+Table
+----
+<systemid>
+<Trigger>BAR.REFTRIG -> <StoredPreparedStatement>BAR.<sysname>
+Trigger
+<systemid>
+StoredPreparedStatement
+----
+<systemid>
+<Trigger>BAR.REFTRIG -> <Table>BAR.T8
+Trigger
+T8
+Table
+----
+<systemid>
+<Trigger>Foo Bar.TRIG2 -> <StoredPreparedStatement>Foo Bar.<sysname>
+Trigger
+<systemid>
+StoredPreparedStatement
+----
+<systemid>
+<Trigger>Foo Bar.TRIG2 -> <Table>BAR.T1
+Trigger
+T1
+Table
+----
+V1
+<View>APP.V1 -> <ColumnsInTable>APP.T1
+View
+T1
+ColumnsInTable
+----
+V1
+<View>APP.V1 -> <ColumnsInTable>BAR.T3
+View
+T3
+ColumnsInTable
+----
+V2
+<View>APP.V2 -> <ColumnsInTable>BAR.T1
+View
+T1
+ColumnsInTable
+----
+viewTwo
+<View>BAR.viewTwo -> <ColumnsInTable>APP.T11
+View
+T11
+ColumnsInTable
+----
+V1
+<View>FOO.V1 -> <ColumnsInTable>Foo Bar.T6
+View
+T6
+ColumnsInTable
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.<sysname>
+StoredPreparedStatement
+<systemid>
+Conglomerate
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.<sysname>
+StoredPreparedStatement
+<systemid>
+Conglomerate
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.<sysname>
+StoredPreparedStatement
+<systemid>
+Conglomerate
+----
+========== SYSFILES ==========
+<systemid>
+FOO
+FOOJAR
+<systemnumber>
+----
+========== SYSFOREIGNKEYS ==========
+<systemname>
+<systemid>
+<systemname>
+U
+R
+----
+"effkay1
+<systemid>
+pee"kay1
+R
+R
+----
+fkOne
+<systemid>
+<systemname>
+R
+S
+----
+<systemname>
+<systemid>
+pkTwo
+R
+R
+----
+========== SYSKEYS ==========
+<systemname>
+<systemid>
+----
+<systemname>
+<systemid>
+----
+<systemname>
+<systemid>
+----
+<systemname>
+<systemid>
+----
+<systemname>
+<systemid>
+----
+UNQ
+<systemid>
+----
+pee"kay1
+<systemid>
+----
+pkTwo
+<systemid>
+----
+unqkay1"
+<systemid>
+----
+========== SYSSCHEMAS ==========
+"Quoted"Schema"
+"Quoted"Schema"
+APP
+----
+APP
+APP
+APP
+----
+BAR
+BAR
+APP
+----
+FOO
+FOO
+APP
+----
+Foo Bar
+Foo Bar
+APP
+----
+========== SYSSTATEMENTS ==========
+<systemid>
+<systemname>
+APP
+T
+<validityflag>
+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)
+<systemid>
+APP
+null
+----
+<systemid>
+<systemname>
+APP
+T
+<validityflag>
+select c from bar."tWithKeys"
+<systemid>
+APP
+null
+----
+<systemid>
+<systemname>
+APP
+T
+<validityflag>
+update bar.t4 set j=8 where i=2
+<systemid>
+APP
+null
+----
+<systemid>
+<systemname>
+"Quoted"Schema"
+T
+<validityflag>
+values(8)
+<systemid>
+APP
+null
+----
+<systemid>
+<systemname>
+BAR
+T
+<validityflag>
+select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLDTABLE 
+<systemid>
+APP
+null
+----
+<systemid>
+<systemname>
+Foo Bar
+T
+<validityflag>
+values (1), (2)
+<systemid>
+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 ==========
+<systemid>
+"trig"One"
+"Quoted"Schema"
+<systemid>
+I
+A
+R
+E
+tee""Hee
+null
+<systemid>
+null
+values(8)
+false
+false
+null
+null
+----
+<systemid>
+REFTRIG
+BAR
+<systemid>
+D
+A
+S
+E
+T8
+null
+<systemid>
+null
+select * from oldtable
+true
+false
+OLDTABLE
+null
+----
+<systemid>
+TRIG2
+Foo Bar
+<systemid>
+D
+B
+S
+E
+T1
+null
+<systemid>
+null
+values (1), (2)
+false
+false
+null
+null
+----
+<systemid>
+TRIGFOUR
+APP
+<systemid>
+U
+A
+S
+E
+X
+null
+<systemid>
+(1)
+insert into removed select * from old where x not in (select x from new where x < 10)
+true
+true
+OLD
+NEW
+----
+<systemid>
+TRIGONE
+APP
+<systemid>
+I
+A
+R
+E
+T3
+null
+<systemid>
+null
+update bar.t4 set j=8 where i=2
+false
+false
+null
+null
+----
+<systemid>
+TrigThree
+APP
+<systemid>
+U
+A
+R
+E
+tWithKeys
+null
+<systemid>
+(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 ==========
+<systemid>
+"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
+<systemname>
+----
+<systemid>
+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
+<systemname>
+----
+<systemid>
+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
+<systemname>
+----
+<systemid>
+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
+<systemname>
+----
+<systemid>
+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
+<systemname>
+----
+<systemid>
+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
+<systemname>
+----
+<systemid>
+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
+<systemname>
+----
+<systemid>
+SYNONYM1
+APP
+null
+S
+S
+false
+"APP"."T1"
+<systemname>
+----
+<systemid>
+SYNONYM2
+BAR
+null
+S
+S
+false
+"BAR"."MULTI WORD NAME"
+<systemname>
+----
+<systemid>
+SYNONYM3
+BAR
+null
+S
+S
+false
+"APP"."T11"
+<systemname>
+----
+<systemid>
+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
+<systemname>
+----
+========== SYSCHECKS ==========
+<systemname>
+(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
+<autoincval>
+null
+null
+----
+"tquoteTwo
+"iq2
+2
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+MULTI WORD NAME
+C
+1
+CHAR(2)
+null
+null
+<autoincval>
+null
+null
+----
+REMOVED
+X
+1
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+T10
+K
+2
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T10
+UK
+3
+CHAR(3) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T10
+VACH
+1
+VARCHAR(12)
+null
+null
+<autoincval>
+null
+null
+----
+T11
+LOLA
+2
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+T11
+MYCHAR
+1
+CHAR(8)
+null
+null
+<autoincval>
+null
+null
+----
+T1
+C
+2
+CHAR(8)
+null
+null
+<autoincval>
+null
+null
+----
+T1
+C
+2
+CLOB(15)
+null
+null
+<autoincval>
+null
+null
+----
+T1
+D
+3
+DATE
+null
+null
+<autoincval>
+null
+null
+----
+T1
+F
+4
+DOUBLE NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T1
+I
+1
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+T1
+P1
+1
+VARCHAR(10) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T2
+B
+2
+BLOB(20)
+null
+null
+<autoincval>
+null
+null
+----
+T2
+C
+3
+CLOB(15)
+null
+null
+<autoincval>
+null
+null
+----
+T2
+P1
+1
+VARCHAR(10)
+null
+null
+<autoincval>
+null
+null
+----
+T3
+B
+2
+BLOB(20)
+null
+null
+<autoincval>
+null
+null
+----
+T3
+ID
+3
+INTEGER NOT NULL
+null
+null
+<autoincval>
+2
+4
+----
+T3
+P1
+1
+VARCHAR(10)
+'okie'
+<systemid>
+<autoincval>
+null
+null
+----
+T3_2
+B
+2
+BLOB(20)
+null
+null
+<autoincval>
+null
+null
+----
+T3_2
+ID
+3
+INTEGER NOT NULL
+GENERATED_BY_DEFAULT
+<systemid>
+<autoincval>
+2
+4
+----
+T3_2
+P1
+1
+VARCHAR(10)
+'okie'
+<systemid>
+<autoincval>
+null
+null
+----
+T4
+I
+1
+INTEGER
+2
+<systemid>
+<autoincval>
+null
+null
+----
+T4
+J
+2
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T4
+K
+3
+INTEGER NOT NULL
+null
+null
+<autoincval>
+1
+1
+----
+T4_2
+I
+1
+INTEGER
+2
+<systemid>
+<autoincval>
+null
+null
+----
+T4_2
+J
+2
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T4_2
+K
+3
+INTEGER NOT NULL
+GENERATED_BY_DEFAULT
+<systemid>
+<autoincval>
+1
+1
+----
+T5
+COST
+1
+DOUBLE
+null
+null
+<autoincval>
+null
+null
+----
+T6
+LETTER
+2
+CHAR(1)
+null
+null
+<autoincval>
+null
+null
+----
+T6
+NUM
+1
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+T7
+DEUX
+2
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+T7
+UN
+1
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+T8
+FKCHAR
+2
+CHAR(5)
+null
+null
+<autoincval>
+null
+null
+----
+T8
+SOMEINT
+1
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T8T1T4
+C1
+1
+CHAR(4)
+'okie'
+<systemid>
+<autoincval>
+null
+null
+----
+T8T1T4
+C2
+2
+CHAR(4)
+'doki'
+<systemid>
+<autoincval>
+null
+null
+----
+T9
+CH
+2
+CHAR(8) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T9
+FKINT
+1
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+V"3
+I
+1
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+V1
+DEE
+2
+CHAR(8)
+null
+null
+<autoincval>
+null
+null
+----
+V1
+DOKIE
+3
+VARCHAR(10)
+null
+null
+<autoincval>
+null
+null
+----
+V1
+DOO
+1
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+V1
+DUM
+1
+DATE
+null
+null
+<autoincval>
+null
+null
+----
+V1
+DWA
+2
+CHAR(1)
+null
+null
+<autoincval>
+null
+null
+----
+V2
+C
+2
+CLOB(15)
+null
+null
+<autoincval>
+null
+null
+----
+V2
+P1
+1
+VARCHAR(10) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+X
+X
+1
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+tWithKeys
+C
+1
+CHAR(5) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+tWithKeys
+I
+2
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+tWithKeys
+VC
+3
+VARCHAR(10)
+null
+null
+<autoincval>
+null
+null
+----
+tee""Hee
+N
+1
+CHAR(1) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+tquote"One
+i"q1
+1
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+tquote"One
+i"q2
+2
+INTEGER
+8
+<systemid>
+<autoincval>
+null
+null
+----
+tquoteThree"
+iq1"
+1
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+tquoteThree"
+iq2"
+2
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+viewTwo
+LOLA
+2
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+viewTwo
+MYCHAR
+1
+CHAR(8)
+null
+null
+<autoincval>
+null
+null
+----
+--- Columns for Statements ---
+========== SYSCONGLOMERATES ==========
+"Quoted"Schema"
+tee""Hee
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+"Quoted"Schema"
+tee""Hee
+<systemnumber>
+Ix"5
+true
+BTREE (1 DESC)
+false
+<systemid>
+----
+"Quoted"Schema"
+tee""Hee
+<systemnumber>
+tee""Hee
+false
+null
+false
+<systemid>
+----
+APP
+"tquoteTwo
+<systemnumber>
+<systemname>
+true
+BTREE (1)
+true
+<systemid>
+----
+APP
+"tquoteTwo
+<systemnumber>
+"tquoteTwo
+false
+null
+false
+<systemid>
+----
+APP
+REMOVED
+<systemnumber>
+REMOVED
+false
+null
+false
+<systemid>
+----
+APP
+T11
+<systemnumber>
+<systemname>
+true
+BTREE (1, 2)
+true
+<systemid>
+----
+APP
+T11
+<systemnumber>
+T11
+false
+null
+false
+<systemid>
+----
+APP
+T1
+<systemnumber>
+IX1
+true
+BTREE (4, 1)
+false
+<systemid>
+----
+APP
+T1
+<systemnumber>
+T1
+false
+null
+false
+<systemid>
+----
+APP
+T2
+<systemnumber>
+T2
+false
+null
+false
+<systemid>
+----
+APP
+T8T1T4
+<systemnumber>
+T8T1T4
+false
+null
+false
+<systemid>
+----
+APP
+X
+<systemnumber>
+X
+false
+null
+false
+<systemid>
+----
+APP
+tquote"One
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+APP
+tquote"One
+<systemnumber>
+tquote"One
+false
+null
+false
+<systemid>
+----
+APP
+tquoteThree"
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+APP
+tquoteThree"
+<systemnumber>
+tquoteThree"
+false
+null
+false
+<systemid>
+----
+BAR
+MULTI WORD NAME
+<systemnumber>
+MULTI WORD NAME
+false
+null
+false
+<systemid>
+----
+BAR
+T1
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+BAR
+T1
+<systemnumber>
+T1
+false
+null
+false
+<systemid>
+----
+BAR
+T3
+<systemnumber>
+IX2
+true
+BTREE (1 DESC, 3 DESC)
+false
+<systemid>
+----
+BAR
+T3
+<systemnumber>
+T3
+false
+null
+false
+<systemid>
+----
+BAR
+T3_2
+<systemnumber>
+T3_2
+false
+null
+false
+<systemid>
+----
+BAR
+T4
+<systemnumber>
+IX4
+true
+UNIQUE BTREE (3)
+false
+<systemid>
+----
+BAR
+T4
+<systemnumber>
+T4
+false
+null
+false
+<systemid>
+----
+BAR
+T4_2
+<systemnumber>
+T4_2
+false
+null
+false
+<systemid>
+----
+BAR
+T8
+<systemnumber>
+<systemname>
+true
+BTREE (2)
+true
+<systemid>
+----
+BAR
+T8
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+BAR
+T8
+<systemnumber>
+T8
+false
+null
+false
+<systemid>
+----
+BAR
+tWithKeys
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+BAR
+tWithKeys
+<systemnumber>
+IX3
+true
+BTREE (1 DESC)
+false
+<systemid>
+----
+BAR
+tWithKeys
+<systemnumber>
+tWithKeys
+false
+null
+false
+<systemid>
+----
+FOO
+T10
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (2)
+true
+<systemid>
+----
+FOO
+T10
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (3)
+true
+<systemid>
+----
+FOO
+T10
+<systemnumber>
+T10
+false
+null
+false
+<systemid>
+----
+FOO
+T9
+<systemnumber>
+<systemname>
+true
+BTREE (1)
+true
+<systemid>
+----
+FOO
+T9
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (2, 1)
+true
+<systemid>
+----
+FOO
+T9
+<systemnumber>
+T9
+false
+null
+false
+<systemid>
+----
+Foo Bar
+T5
+<systemnumber>
+CostIndex
+true
+UNIQUE BTREE (1)
+false
+<systemid>
+----
+Foo Bar
+T5
+<systemnumber>
+T5
+false
+null
+false
+<systemid>
+----
+Foo Bar
+T6
+<systemnumber>
+T6
+false
+null
+false
+<systemid>
+----
+Foo Bar
+T7
+<systemnumber>
+T7
+false
+null
+false
+<systemid>
+----
+========== SYSCONSTRAINTS ==========
+"ck2
+"tquoteTwo
+"ck2
+C
+APP
+E
+0
+----
+"effkay1
+"tquoteTwo
+"effkay1
+F
+APP
+E
+0
+----
+<systemname>
+T10
+<systemname>
+P
+FOO
+E
+1
+----
+<systemname>
+T10
+<systemname>
+U
+FOO
+E
+0
+----
+<systemname>
+T8
+<systemname>
+F
+BAR
+E
+0
+----
+<systemname>
+T8
+<systemname>
+P
+BAR
+E
+0
+----
+<systemname>
+tWithKeys
+<systemname>
+C
+BAR
+E
+0
+----
+<systemname>
+tWithKeys
+<systemname>
+P
+BAR
+E
+1
+----
+NOTEVIL
+tWithKeys
+NOTEVIL
+C
+BAR
+E
+0
+----
+<systemname>
+T11
+<systemname>
+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
+----
+<systemname>
+tee""Hee
+<systemname>
+P
+"Quoted"Schema"
+E
+0
+----
+unqkay1"
+tquoteThree"
+unqkay1"
+U
+APP
+E
+0
+----
+========== SYSDEPENDS ==========
+"effkay1
+<Constraint>APP."effkay1 -> <Constraint>APP.pee"kay1
+Constraint
+pee"kay1
+Constraint
+----
+<systemname>
+<Constraint>APP.<sysname> -> <Constraint>FOO.pkTwo
+Constraint
+pkTwo
+Constraint
+----
+<systemname>
+<Constraint>BAR.<sysname> -> <Constraint>BAR.<sysname>
+Constraint
+<systemname>
+Constraint
+----
+fkOne
+<Constraint>FOO.fkOne -> <Constraint>FOO.<sysname>
+Constraint
+<systemname>
+Constraint
+----
+<systemid>
+<StoredPreparedStatement>"Quoted"Schema".<sysname> -> <Table>"Quoted"Schema".tee""Hee
+StoredPreparedStatement
+tee""Hee
+Table
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <ColumnsInTable>BAR.T4
+StoredPreparedStatement
+T4
+ColumnsInTable
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <ColumnsInTable>BAR.tWithKeys
+StoredPreparedStatement
+tWithKeys
+ColumnsInTable
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <Conglomerate>APP.<sysname>
+StoredPreparedStatement
+<systemid>
+Conglomerate
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.IX3
+StoredPreparedStatement
+<systemid>
+Conglomerate
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <Table>APP.REMOVED
+StoredPreparedStatement
+REMOVED
+Table
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <Table>APP.X
+StoredPreparedStatement
+X
+Table
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <Table>BAR.T3
+StoredPreparedStatement
+T3
+Table
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <Table>BAR.tWithKeys
+StoredPreparedStatement
+tWithKeys
+Table
+----
+<systemid>
+<StoredPreparedStatement>BAR.<sysname> -> <Table>BAR.T8
+StoredPreparedStatement
+T8
+Table
+----
+<systemid>
+<StoredPreparedStatement>Foo Bar.<sysname> -> <Table>BAR.T1
+StoredPreparedStatement
+T1
+Table
+----
+<systemid>
+<Trigger>"Quoted"Schema"."trig"One" -> <StoredPreparedStatement>"Quoted"Schema".<sysname>
+Trigger
+<systemid>
+StoredPreparedStatement
+----
+<systemid>
+<Trigger>"Quoted"Schema"."trig"One" -> <Table>"Quoted"Schema".tee""Hee
+Trigger
+tee""Hee
+Table
+----
+<systemid>
+<Trigger>APP.TRIGFOUR -> <StoredPreparedStatement>APP.<sysname>
+Trigger
+<systemid>
+StoredPreparedStatement
+----
+<systemid>
+<Trigger>APP.TRIGFOUR -> <Table>APP.X
+Trigger
+X
+Table
+----
+<systemid>
+<Trigger>APP.TRIGONE -> <StoredPreparedStatement>APP.<sysname>
+Trigger
+<systemid>
+StoredPreparedStatement
+----
+<systemid>
+<Trigger>APP.TRIGONE -> <Table>BAR.T3
+Trigger
+T3
+Table
+----
+<systemid>
+<Trigger>APP.TrigThree -> <StoredPreparedStatement>APP.<sysname>
+Trigger
+<systemid>
+StoredPreparedStatement
+----
+<systemid>
+<Trigger>APP.TrigThree -> <Table>BAR.tWithKeys
+Trigger
+tWithKeys
+Table
+----
+<systemid>
+<Trigger>BAR.REFTRIG -> <StoredPreparedStatement>BAR.<sysname>
+Trigger
+<systemid>
+StoredPreparedStatement
+----
+<systemid>
+<Trigger>BAR.REFTRIG -> <Table>BAR.T8
+Trigger
+T8
+Table
+----
+<systemid>
+<Trigger>Foo Bar.TRIG2 -> <StoredPreparedStatement>Foo Bar.<sysname>
+Trigger
+<systemid>
+StoredPreparedStatement
+----
+<systemid>
+<Trigger>Foo Bar.TRIG2 -> <Table>BAR.T1
+Trigger
+T1
+Table
+----
+V1
+<View>APP.V1 -> <ColumnsInTable>APP.T1
+View
+T1
+ColumnsInTable
+----
+V1
+<View>APP.V1 -> <ColumnsInTable>BAR.T3
+View
+T3
+ColumnsInTable
+----
+V2
+<View>APP.V2 -> <ColumnsInTable>BAR.T1
+View
+T1
+ColumnsInTable
+----
+viewTwo
+<View>BAR.viewTwo -> <ColumnsInTable>APP.T11
+View
+T11
+ColumnsInTable
+----
+V1
+<View>FOO.V1 -> <ColumnsInTable>Foo Bar.T6
+View
+T6
+ColumnsInTable
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.<sysname>
+StoredPreparedStatement
+<systemid>
+Conglomerate
+----
+<systemid>
+<StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.<sysname>
+StoredPreparedStatement
+<systemid>
+Conglomerate
+----
+========== SYSFILES ==========
+<systemid>
+FOO
+FOOJAR
+<systemnumber>
+----
+========== SYSFOREIGNKEYS ==========
+<systemname>
+<systemid>
+<systemname>
+U
+R
+----
+"effkay1
+<systemid>
+pee"kay1
+R
+R
+----
+fkOne
+<systemid>
+<systemname>
+R
+S
+----
+<systemname>
+<systemid>
+pkTwo
+R
+R
+----
+========== SYSKEYS ==========
+<systemname>
+<systemid>
+----
+<systemname>
+<systemid>
+----
+<systemname>
+<systemid>
+----
+<systemname>
+<systemid>
+----
+<systemname>
+<systemid>
+----
+UNQ
+<systemid>
+----
+pee"kay1
+<systemid>
+----
+pkTwo
+<systemid>
+----
+unqkay1"
+<systemid>
+----
+========== SYSSCHEMAS ==========
+"Quoted"Schema"
+"Quoted"Schema"
+APP
+----
+APP
+APP
+APP
+----
+BAR
+BAR
+APP
+----
+FOO
+FOO
+APP
+----
+Foo Bar
+Foo Bar
+APP
+----
+========== SYSSTATEMENTS ==========
+<systemid>
+<systemname>
+APP
+T
+<validityflag>
+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)
+<systemid>
+APP
+null
+----
+<systemid>
+<systemname>
+APP
+T
+<validityflag>
+select c from bar."tWithKeys"
+<systemid>
+APP
+null
+----
+<systemid>
+<systemname>
+APP
+T
+<validityflag>
+update bar.t4 set j=8 where i=2
+<systemid>
+APP
+null
+----
+<systemid>
+<systemname>
+"Quoted"Schema"
+T
+<validityflag>
+values(8)
+<systemid>
+APP
+null
+----
+<systemid>
+<systemname>
+BAR
+T
+<validityflag>
+select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLDTABLE 
+<systemid>
+APP
+null
+----
+<systemid>
+<systemname>
+Foo Bar
+T
+<validityflag>
+values (1), (2)
+<systemid>
+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 ==========
+<systemid>
+"trig"One"
+"Quoted"Schema"
+<systemid>
+I
+A
+R
+E
+tee""Hee
+null
+<systemid>
+null
+values(8)
+false
+false
+null
+null
+----
+<systemid>
+REFTRIG
+BAR
+<systemid>
+D
+A
+S
+E
+T8
+null
+<systemid>
+null
+select * from oldtable
+true
+false
+OLDTABLE
+null
+----
+<systemid>
+TRIG2
+Foo Bar
+<systemid>
+D
+B
+S
+E
+T1
+null
+<systemid>
+null
+values (1), (2)
+false
+false
+null
+null
+----
+<systemid>
+TRIGFOUR
+APP
+<systemid>
+U
+A
+S
+E
+X
+null
+<systemid>
+(1)
+insert into removed select * from old where x not in (select x from new where x < 10)
+true
+true
+OLD
+NEW
+----
+<systemid>
+TRIGONE
+APP
+<systemid>
+I
+A
+R
+E
+T3
+null
+<systemid>
+null
+update bar.t4 set j=8 where i=2
+false
+false
+null
+null
+----
+<systemid>
+TrigThree
+APP
+<systemid>
+U
+A
+R
+E
+tWithKeys
+null
+<systemid>
+(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 ==========
+<systemid>
+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
+<systemname>
+----
+<systemid>
+SYNONYM2
+BAR
+null
+S
+S
+false
+"BAR"."MULTI WORD NAME"
+<systemname>
+----
+<systemid>
+SYNONYM3
+BAR
+null
+S
+S
+false
+"APP"."T11"
+<systemname>
+----
+========== SYSCHECKS ==========
+<systemname>
+(i > 0)
+(2)
+----
+NOTEVIL
+(vc != 'evil')
+(3)
+----
+========== SYSCOLUMNS ==========
+--- Columns for Tables ---
+MULTI WORD NAME
+C
+1
+CHAR(2)
+null
+null
+<autoincval>
+null
+null
+----
+T1
+C
+2
+CLOB(15)
+null
+null
+<autoincval>
+null
+null
+----
+T1
+P1
+1
+VARCHAR(10) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T3
+B
+2
+BLOB(20)
+null
+null
+<autoincval>
+null
+null
+----
+T3
+ID
+3
+INTEGER NOT NULL
+null
+null
+<autoincval>
+2
+4
+----
+T3
+P1
+1
+VARCHAR(10)
+'okie'
+<systemid>
+<autoincval>
+null
+null
+----
+T3_2
+B
+2
+BLOB(20)
+null
+null
+<autoincval>
+null
+null
+----
+T3_2
+ID
+3
+INTEGER NOT NULL
+GENERATED_BY_DEFAULT
+<systemid>
+<autoincval>
+2
+4
+----
+T3_2
+P1
+1
+VARCHAR(10)
+'okie'
+<systemid>
+<autoincval>
+null
+null
+----
+T4
+I
+1
+INTEGER
+2
+<systemid>
+<autoincval>
+null
+null
+----
+T4
+J
+2
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T4
+K
+3
+INTEGER NOT NULL
+null
+null
+<autoincval>
+1
+1
+----
+T4_2
+I
+1
+INTEGER
+2
+<systemid>
+<autoincval>
+null
+null
+----
+T4_2
+J
+2
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T4_2
+K
+3
+INTEGER NOT NULL
+GENERATED_BY_DEFAULT
+<systemid>
+<autoincval>
+1
+1
+----
+T8
+FKCHAR
+2
+CHAR(5)
+null
+null
+<autoincval>
+null
+null
+----
+T8
+SOMEINT
+1
+INTEGER NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+tWithKeys
+C
+1
+CHAR(5) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+tWithKeys
+I
+2
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+tWithKeys
+VC
+3
+VARCHAR(10)
+null
+null
+<autoincval>
+null
+null
+----
+--- Columns for Statements ---
+========== SYSCONGLOMERATES ==========
+BAR
+MULTI WORD NAME
+<systemnumber>
+MULTI WORD NAME
+false
+null
+false
+<systemid>
+----
+BAR
+T1
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+BAR
+T1
+<systemnumber>
+T1
+false
+null
+false
+<systemid>
+----
+BAR
+T3
+<systemnumber>
+IX2
+true
+BTREE (1 DESC, 3 DESC)
+false
+<systemid>
+----
+BAR
+T3
+<systemnumber>
+T3
+false
+null
+false
+<systemid>
+----
+BAR
+T3_2
+<systemnumber>
+T3_2
+false
+null
+false
+<systemid>
+----
+BAR
+T4
+<systemnumber>
+IX4
+true
+UNIQUE BTREE (3)
+false
+<systemid>
+----
+BAR
+T4
+<systemnumber>
+T4
+false
+null
+false
+<systemid>
+----
+BAR
+T4_2
+<systemnumber>
+T4_2
+false
+null
+false
+<systemid>
+----
+BAR
+T8
+<systemnumber>
+<systemname>
+true
+BTREE (2)
+true
+<systemid>
+----
+BAR
+T8
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+BAR
+T8
+<systemnumber>
+T8
+false
+null
+false
+<systemid>
+----
+BAR
+tWithKeys
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+BAR
+tWithKeys
+<systemnumber>
+IX3
+true
+BTREE (1 DESC)
+false
+<systemid>
+----
+BAR
+tWithKeys
+<systemnumber>
+tWithKeys
+false
+null
+false
+<systemid>
+----
+========== SYSCONSTRAINTS ==========
+<systemname>
+T8
+<systemname>
+F
+BAR
+E
+0
+----
+<systemname>
+T8
+<systemname>
+P
+BAR
+E
+0
+----
+<systemname>
+tWithKeys
+<systemname>
+C
+BAR
+E
+0
+----
+<systemname>
+tWithKeys
+<systemname>
+P
+BAR
+E
+1
+----
+NOTEVIL
+tWithKeys
+NOTEVIL
+C
+BAR
+E
+0
+----
+UNQ
+T1
+UNQ
+U
+BAR
+E
+0
+----
+========== SYSDEPENDS ==========
+<systemname>
+<Constraint>BAR.<sysname> -> <Constraint>BAR.<sysname>
+Constraint
+<systemname>
+Constraint
+----
+<systemid>
+<StoredPreparedStatement>BAR.<sysname> -> <Table>BAR.T8
+StoredPreparedStatement
+T8
+Table
+----
+<systemid>
+<Trigger>BAR.REFTRIG -> <StoredPreparedStatement>BAR.<sysname>
+Trigger
+<systemid>
+StoredPreparedStatement
+----
+<systemid>
+<Trigger>BAR.REFTRIG -> <Table>BAR.T8
+Trigger
+T8
+Table
+----
+========== SYSFILES ==========
+========== SYSFOREIGNKEYS ==========
+<systemname>
+<systemid>
+<systemname>
+U
+R
+----
+========== SYSKEYS ==========
+<systemname>
+<systemid>
+----
+<systemname>
+<systemid>
+----
+UNQ
+<systemid>
+----
+========== SYSSCHEMAS ==========
+APP
+APP
+APP
+----
+BAR
+BAR
+APP
+----
+========== SYSSTATEMENTS ==========
+<systemid>
+<systemname>
+BAR
+T
+<validityflag>
+select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLDTABLE 
+<systemid>
+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 ==========
+<systemid>
+REFTRIG
+BAR
+<systemid>
+D
+A
+S
+E
+T8
+null
+<systemid>
+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 ==========
+<systemid>
+SYNONYM2
+BAR
+null
+S
+S
+false
+"BAR"."MULTI WORD NAME"
+<systemname>
+----
+<systemid>
+SYNONYM3
+BAR
+null
+S
+S
+false
+"APP"."T11"
+<systemname>
+----
+========== SYSCHECKS ==========
+<systemname>
+(i > 0)
+(2)
+----
+NOTEVIL
+(vc != 'evil')
+(3)
+----
+========== SYSCOLUMNS ==========
+--- Columns for Tables ---
+MULTI WORD NAME
+C
+1
+CHAR(2)
+null
+null
+<autoincval>
+null
+null
+----
+T3
+B
+2
+BLOB(20)
+null
+null
+<autoincval>
+null
+null
+----
+T3
+ID
+3
+INTEGER NOT NULL
+null
+null
+<autoincval>
+2
+4
+----
+T3
+P1
+1
+VARCHAR(10)
+'okie'
+<systemid>
+<autoincval>
+null
+null
+----
+tWithKeys
+C
+1
+CHAR(5) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+tWithKeys
+I
+2
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+tWithKeys
+VC
+3
+VARCHAR(10)
+null
+null
+<autoincval>
+null
+null
+----
+--- Columns for Statements ---
+========== SYSCONGLOMERATES ==========
+BAR
+MULTI WORD NAME
+<systemnumber>
+MULTI WORD NAME
+false
+null
+false
+<systemid>
+----
+BAR
+T3
+<systemnumber>
+IX2
+true
+BTREE (1 DESC, 3 DESC)
+false
+<systemid>
+----
+BAR
+T3
+<systemnumber>
+T3
+false
+null
+false
+<systemid>
+----
+BAR
+tWithKeys
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+BAR
+tWithKeys
+<systemnumber>
+IX3
+true
+BTREE (1 DESC)
+false
+<systemid>
+----
+BAR
+tWithKeys
+<systemnumber>
+tWithKeys
+false
+null
+false
+<systemid>
+----
+========== SYSCONSTRAINTS ==========
+<systemname>
+tWithKeys
+<systemname>
+C
+BAR
+E
+0
+----
+<systemname>
+tWithKeys
+<systemname>
+P
+BAR
+E
+0
+----
+NOTEVIL
+tWithKeys
+NOTEVIL
+C
+BAR
+E
+0
+----
+========== SYSDEPENDS ==========
+========== SYSFILES ==========
+========== SYSFOREIGNKEYS ==========
+========== SYSKEYS ==========
+<systemname>
+<systemid>
+----
+========== 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 ==========
+<systemid>
+SYNONYM1
+APP
+null
+S
+S
+false
+"APP"."T1"
+<systemname>
+----
+<systemid>
+SYNONYM2
+BAR
+null
+S
+S
+false
+"BAR"."MULTI WORD NAME"
+<systemname>
+----
+<systemid>
+SYNONYM3
+BAR
+null
+S
+S
+false
+"APP"."T11"
+<systemname>
+----
+========== SYSCHECKS ==========
+========== SYSCOLUMNS ==========
+--- Columns for Tables ---
+T1
+C
+2
+CHAR(8)
+null
+null
+<autoincval>
+null
+null
+----
+T1
+C
+2
+CLOB(15)
+null
+null
+<autoincval>
+null
+null
+----
+T1
+D
+3
+DATE
+null
+null
+<autoincval>
+null
+null
+----
+T1
+F
+4
+DOUBLE NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+T1
+I
+1
+INTEGER
+null
+null
+<autoincval>
+null
+null
+----
+T1
+P1
+1
+VARCHAR(10) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+V2
+C
+2
+CLOB(15)
+null
+null
+<autoincval>
+null
+null
+----
+V2
+P1
+1
+VARCHAR(10) NOT NULL
+null
+null
+<autoincval>
+null
+null
+----
+--- Columns for Statements ---
+========== SYSCONGLOMERATES ==========
+APP
+T1
+<systemnumber>
+IX1
+true
+BTREE (4, 1)
+false
+<systemid>
+----
+APP
+T1
+<systemnumber>
+T1
+false
+null
+false
+<systemid>
+----
+BAR
+T1
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+BAR
+T1
+<systemnumber>
+T1
+false
+null
+false
+<systemid>
+----
+========== SYSCONSTRAINTS ==========
+UNQ
+T1
+UNQ
+U
+BAR
+E
+0
+----
+========== SYSDEPENDS ==========
+<systemid>
+<StoredPreparedStatement>Foo Bar.<sysname> -> <Table>BAR.T1
+StoredPreparedStatement
+T1
+Table
+----
+<systemid>
+<Trigger>Foo Bar.TRIG2 -> <StoredPreparedStatement>Foo Bar.<sysname>
+Trigger
+<systemid>
+StoredPreparedStatement
+----
+<systemid>
+<Trigger>Foo Bar.TRIG2 -> <Table>BAR.T1
+Trigger
+T1
+Table
+----
+V2
+<View>APP.V2 -> <ColumnsInTable>BAR.T1
+View
+T1
+ColumnsInTable
+----
+========== SYSFILES ==========
+========== SYSFOREIGNKEYS ==========
+========== SYSKEYS ==========
+UNQ
+<systemid>
+----
+========== SYSSCHEMAS ==========
+APP
+APP
+APP
+----
+BAR
+BAR
+APP
+----
+Foo Bar
+Foo Bar
+APP
+----
+========== SYSSTATEMENTS ==========
+<systemid>
+<systemname>
+Foo Bar
+T
+<validityflag>
+values (1), (2)
+<systemid>
+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 ==========
+<systemid>
+TRIG2
+Foo Bar
+<systemid>
+D
+B
+S
+E
+T1
+null
+<systemid>
+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
+<autoincval>
+null
+null
+----
+--- Columns for Statements ---
+========== SYSCONGLOMERATES ==========
+"Quoted"Schema"
+tee""Hee
+<systemnumber>
+<systemname>
+true
+UNIQUE BTREE (1)
+true
+<systemid>
+----
+"Quoted"Schema"
+tee""Hee
+<systemnumber>
+Ix"5
+true
+BTREE (1 DESC)
+false
+<systemid>
+----
+"Quoted"Schema"
+tee""Hee
+<systemnumber>
+tee""Hee
+false
+null
+false
+<systemid>
+----
+========== SYSCONSTRAINTS ==========
+<systemname>
+tee""Hee
+<systemname>
+P
+"Quoted"Schema"
+E
+0
+----
+========== SYSDEPENDS ==========
+<systemid>
+<StoredPreparedStatement>"Quoted"Schema".<sysname> -> <Table>"Quoted"Schema".tee""Hee
+StoredPreparedStatement
+tee""Hee
+Table
+----
+<systemid>
+<Trigger>"Quoted"Schema"."trig"One" -> <StoredPreparedStatement>"Quoted"Schema".<sysname>
+Trigger
+<systemid>
+StoredPreparedStatement
+----
+<systemid>
+<Trigger>"Quoted"Schema"."trig"One" -> <Table>"Quoted"Schema".tee""Hee
+Trigger
+tee""Hee
+Table
+----
+========== SYSFILES ==========
+========== SYSFOREIGNKEYS ==========
+========== SYSKEYS ==========
+<systemname>
+<systemid>
+----
+========== SYSSCHEMAS ==========
+"Quoted"Schema"
+"Quoted"Schema"
+APP
+----
+APP
+APP
+APP
+----
+========== SYSSTATEMENTS ==========
+<systemid>
+<systemname>
+"Quoted"Schema"
+T
+<validityflag>
+values(8)
+<systemid>
+APP
+null
+----
+========== SYSTABLES ==========
+tee""Hee
+tee""Hee
+T
+"Quoted"Schema"
+R
+----
+========== SYSTRIGGERS ==========
+<systemid>
+"trig"One"
+"Quoted"Schema"
+<systemid>
+I
+A
+R
+E
+tee""Hee
+null
+<systemid>
+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: <dbPath>
+-- Connection URL is: <dbURL>
+-- 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(<maskedOutJarDesc>)
+-- ----------------------------------------------
+-- 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: <dbPath>
+-- Connection URL is: <dbURL>
+-- 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 <sourceDBUrl> [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 <schemaName> to specify a schema to which the DDL generation
+ 	 should be limited.  Only database objects with that schema will have
+ 	 their DDL generated.
+ 	-t <tableOne> <tableTwo> ... to specify a list of tables for which
+ 	 the DDL will be generated; any tables not in the list will be ignored.
+ 	-td <value> 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 <filename> 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: <dbPath>
+-- Connection URL is: <dbURL>
+-- 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(<maskedOutJarDesc>)
+-- ----------------------------------------------
+-- 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 <jarFilePath>
+java.io.FileNotFoundException: <filePath>
+############## End File Contents ################
+[ Done. ]

Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dblook_test_territory.out
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetClientRemote.exclude
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetClientRemote.exclude?rev=634037&r1=634036&r2=634037&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetClientRemote.exclude (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetClientRemote.exclude Wed Mar  5 13:25:53 2008
@@ -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

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetClientUseprocess.exclude
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetClientUseprocess.exclude?rev=634037&r1=634036&r2=634037&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetClientUseprocess.exclude (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetClientUseprocess.exclude Wed Mar  5 13:25:53 2008
@@ -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

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetRemote.exclude
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetRemote.exclude?rev=634037&r1=634036&r2=634037&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetRemote.exclude (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetRemote.exclude Wed Mar  5 13:25:53 2008
@@ -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

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetUseprocess.exclude
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetUseprocess.exclude?rev=634037&r1=634036&r2=634037&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetUseprocess.exclude (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetUseprocess.exclude Wed Mar  5 13:25:53 2008
@@ -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

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.runall
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.runall?rev=634037&r1=634036&r2=634037&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.runall (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.runall Wed Mar  5 13:25:53 2008
@@ -1,4 +1,5 @@
 derbynet/dblook_test_net.java
+derbynet/dblook_test_net_territory.java
 derbynet/DerbyNetAutoStart.java
 derbynet/getCurrentProperties.java
 derbynet/maxthreads.java

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbytools.runall
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbytools.runall?rev=634037&r1=634036&r2=634037&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbytools.runall (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbytools.runall Wed Mar  5 13:25:53 2008
@@ -1,4 +1,5 @@
 tools/dblook_test.java
+tools/dblook_test_territory.java
 tools/derbyrunjartest.java
 tools/importExportThruIJ.sql
 tools/ij.sql

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/j9derbynetmats.runall
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/j9derbynetmats.runall?rev=634037&r1=634036&r2=634037&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/j9derbynetmats.runall (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/j9derbynetmats.runall Wed Mar  5 13:25:53 2008
@@ -1,4 +1,5 @@
 derbynet/dblook_test_net.java
+derbynet/dblook_test_net_territory.java
 derbynet/getCurrentProperties.java
 derbynet/maxthreads.java
 derbynet/runtimeinfo.java

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/NetHarnessJavaTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/NetHarnessJavaTest.java?rev=634037&r1=634036&r2=634037&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/NetHarnessJavaTest.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/NetHarnessJavaTest.java Wed Mar  5 13:25:53 2008
@@ -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

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net.java?rev=634037&r1=634036&r2=634037&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net.java Wed Mar  5 13:25:53 2008
@@ -35,6 +35,7 @@
 		testDirectory = "dblook_test_net/";
 		new dblook_test_net().doTest();
 		System.out.println("\n[ Done. ]\n");
+		renameDbLookLog("dblook_test_net");
 
 	}
 

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory.java?rev=634037&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory.java (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory.java Wed Mar  5 13:25:53 2008
@@ -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();
+		}
+
+	}
+
+}

Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory.java
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory_app.properties
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory_app.properties?rev=634037&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory_app.properties (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory_app.properties Wed Mar  5 13:25:53 2008
@@ -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
+

Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory_app.properties
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test.java?rev=634037&r1=634036&r2=634037&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test.java Wed Mar  5 13:25:53 2008
@@ -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,7 +723,29 @@
 		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.
@@ -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 =
@@ -1503,6 +1528,39 @@
 
 		return;
 
+	}
+
+	/* **********************************************
+	 * 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);
+			}
+		}
 	}
 
 	/* **********************************************

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory.java?rev=634037&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory.java (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory.java Wed Mar  5 13:25:53 2008
@@ -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");
+
+	}
+
+}

Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory.java
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory_app.properties
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory_app.properties?rev=634037&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory_app.properties (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory_app.properties Wed Mar  5 13:25:53 2008
@@ -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

Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory_app.properties
------------------------------------------------------------------------------
    svn:eol-style = native



Mime
View raw message