You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by fu...@apache.org on 2006/06/09 23:12:09 UTC
svn commit: r413170 - in
/db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13:
dblook_test.out floattypes.out holdCursorIJ.out
Author: fuzzylogic
Date: Fri Jun 9 14:12:09 2006
New Revision: 413170
URL: http://svn.apache.org/viewvc?rev=413170&view=rev
Log:
DERBY-1366: master updates for j9.
Patch committed for Myrna Van Lunteren <m....@gmail.com>
Added:
db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dblook_test.out (with props)
db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/holdCursorIJ.out (with props)
Modified:
db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out
Added: db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dblook_test.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dblook_test.out?rev=413170&view=auto
==============================================================================
--- db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dblook_test.out (added)
+++ db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dblook_test.out Fri Jun 9 14:12:09 2006
@@ -0,0 +1,4863 @@
+-= 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>
+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>
+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
+----
+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
+----
+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
+T4
+<systemnumber>
+IX4
+true
+UNIQUE BTREE (3)
+false
+<systemid>
+----
+BAR
+T4
+<systemnumber>
+T4
+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
+----
+========== 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
+----
+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
+----
+T4
+T4
+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>
+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>
+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
+----
+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
+----
+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
+T4
+<systemnumber>
+IX4
+true
+UNIQUE BTREE (3)
+false
+<systemid>
+----
+BAR
+T4
+<systemnumber>
+T4
+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.<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
+----
+========== 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
+----
+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
+----
+T4
+T4
+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>
+----
+========== 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
+----
+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
+----
+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
+T4
+<systemnumber>
+IX4
+true
+UNIQUE BTREE (3)
+false
+<systemid>
+----
+BAR
+T4
+<systemnumber>
+T4
+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
+----
+T1
+T1
+T
+BAR
+R
+----
+T3
+T3
+T
+BAR
+R
+----
+T4
+T4
+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 ==========
+========== 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
+----
+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 'BAR.T3' does not exist.
+Dumping system tables for 'wombat_new'
+----------------=================---------------
+System Tables for: wombat_new
+----------------=================---------------
+========== SYSALIASES ==========
+========== 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 ==========
+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: Driver not found: wombat
+-- **--> DEBUG: Driver not found: wombat
+############## 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 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')
+-- ----------------------------------------------
+-- 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 MODE DB2SQL 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:net://localhost: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 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') #
+-- ----------------------------------------------
+-- 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 MODE DB2SQL 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/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/dblook_test.out
------------------------------------------------------------------------------
svn:eol-style = native
Modified: db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out?rev=413170&r1=413169&r2=413170&view=diff
==============================================================================
--- db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out (original)
+++ db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out Fri Jun 9 14:12:09 2006
@@ -2419,4 +2419,42 @@
1
--------------------------------
ERROR 22003: The resulting value is outside the range for the data type DECIMAL/NUMERIC(31,0).
+ij> create table tiger(d decimal(12,11));
+0 rows inserted/updated/deleted
+ij> insert into tiger values (1.234);
+1 row inserted/updated/deleted
+ij> insert into tiger values (0.1234);
+1 row inserted/updated/deleted
+ij> insert into tiger values (0.01234);
+1 row inserted/updated/deleted
+ij> insert into tiger values (0.001234);
+1 row inserted/updated/deleted
+ij> insert into tiger values (0.001234);
+1 row inserted/updated/deleted
+ij> insert into tiger values (0.0001234);
+1 row inserted/updated/deleted
+ij> insert into tiger values (0.00001234);
+1 row inserted/updated/deleted
+ij> insert into tiger values (0.000001234);
+1 row inserted/updated/deleted
+ij> insert into tiger values (0.0000001234);
+1 row inserted/updated/deleted
+ij> insert into tiger values (0.00000001234);
+1 row inserted/updated/deleted
+ij> insert into tiger values (0.00000001234);
+1 row inserted/updated/deleted
+ij> select d from tiger order by 1;
+D
+---------------
+0.00000001234
+0.00000001234
+0.00000012340
+0.00000123400
+0.00001234000
+0.00012340000
+0.00123400000
+0.00123400000
+0.01234000000
+0.12340000000
+1.23400000000
ij>
Added: db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/holdCursorIJ.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/holdCursorIJ.out?rev=413170&view=auto
==============================================================================
--- db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/holdCursorIJ.out (added)
+++ db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/holdCursorIJ.out Fri Jun 9 14:12:09 2006
@@ -0,0 +1,293 @@
+ij> -- create a table
+create table t1(c11 int, c12 int);
+0 rows inserted/updated/deleted
+ij> -- insert data into tables
+insert into t1 values(1,1);
+1 row inserted/updated/deleted
+ij> insert into t1 values(2,2);
+1 row inserted/updated/deleted
+ij> -- set autocommit off
+autocommit off;
+ij> -- first test - make sure that only cursors created with holdability true
+-- have open resultsets after commit
+-- declare 3 different kind of cursors one for each jdbc release so far
+get with nohold cursor jdk1 as 'SELECT * FROM t1';
+IJ ERROR: Holdability can not be changed using jdbc3.0 apis in JDKs lower than JDK1.4.
+ij> get scroll insensitive with nohold cursor jdk2 as 'SELECT * FROM t1';
+IJ ERROR: Holdability can not be changed using jdbc3.0 apis in JDKs lower than JDK1.4.
+ij> get with hold cursor jdk4 as 'SELECT * FROM t1';
+ij> -- do fetches from these cursors
+next jdk1;
+IJ ERROR: Unable to establish cursor
+ij> next jdk2;
+IJ ERROR: Unable to establish cursor
+ij> next jdk4;
+C11 |C12
+-----------------------
+1 |1
+ij> --commit
+commit;
+ij> -- now try the fetch on cursors again after commit
+-- cursors jdk1 and jdk2 will give errors
+next jdk1;
+IJ ERROR: Unable to establish cursor
+ij> next jdk2;
+IJ ERROR: Unable to establish cursor
+ij> next jdk4;
+C11 |C12
+-----------------------
+2 |2
+ij> -- end of resultset for jdk4, but try next again
+next jdk4;
+No current row
+ij> close jdk4;
+ij> next jdk4;
+IJ ERROR: Unable to establish cursor
+ij> -- second test - make sure that all the cursors (including holdability true)
+-- have their resultsets closed after rollback.
+-- declare the cursors again, this time, try with rollback
+get with nohold cursor jdk1 as 'SELECT * FROM t1';
+IJ ERROR: Holdability can not be changed using jdbc3.0 apis in JDKs lower than JDK1.4.
+ij> get scroll insensitive with nohold cursor jdk2 as 'SELECT * FROM t1';
+IJ ERROR: Holdability can not be changed using jdbc3.0 apis in JDKs lower than JDK1.4.
+ij> get with hold cursor jdk4 as 'SELECT * FROM t1';
+ij> -- do fetches from these cursors
+next jdk1;
+IJ ERROR: Unable to establish cursor
+ij> next jdk2;
+IJ ERROR: Unable to establish cursor
+ij> next jdk4;
+C11 |C12
+-----------------------
+1 |1
+ij> --rollback
+rollback;
+ij> -- now try the fetch on cursors again after rollback
+-- all the cursors will give errors
+next jdk1;
+IJ ERROR: Unable to establish cursor
+ij> next jdk2;
+IJ ERROR: Unable to establish cursor
+ij> next jdk4;
+ERROR XCL16: ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+ij> -- third test - Define a hold cursor on a table. Shouldn't be able to drop that
+-- table before & after commit. Have to close the cursor before table can be dropped.
+get with nohold cursor jdk1 as 'SELECT * FROM t1';
+IJ ERROR: Holdability can not be changed using jdbc3.0 apis in JDKs lower than JDK1.4.
+ij> get with hold cursor jdk4 as 'SELECT * FROM t1';
+ij> next jdk1;
+IJ ERROR: Unable to establish cursor
+ij> next jdk4;
+C11 |C12
+-----------------------
+1 |1
+ij> -- wont' be able to drop table because of cursors jdk1 and jdk4
+drop table t1;
+ERROR X0X95: Operation 'DROP TABLE' cannot be performed on object 'T1' because there is an open ResultSet dependent on that object.
+ij> commit;
+ij> -- drop table still won't work because jdk4 is still open after commit
+drop table t1;
+ERROR X0X95: Operation 'DROP TABLE' cannot be performed on object 'T1' because there is an open ResultSet dependent on that object.
+ij> -- close cursor jdk4 and try then deleting the table
+close jdk4;
+ij> drop table t1;
+0 rows inserted/updated/deleted
+ij> -- recreate and populate the table for next test
+create table t1(c11 int, c12 int);
+0 rows inserted/updated/deleted
+ij> insert into t1 values(1,1);
+1 row inserted/updated/deleted
+ij> insert into t1 values(2,2);
+1 row inserted/updated/deleted
+ij> -- fourth test - try to change the isolation level while there are
+-- held cursors
+get with nohold cursor jdk1 as 'SELECT * FROM t1';
+IJ ERROR: Holdability can not be changed using jdbc3.0 apis in JDKs lower than JDK1.4.
+ij> get with hold cursor jdk4 as 'SELECT * FROM t1';
+ij> next jdk1;
+IJ ERROR: Unable to establish cursor
+ij> next jdk4;
+C11 |C12
+-----------------------
+1 |1
+ij> -- try to change the isolation level. will give error because of jdk1 and jdk4
+set current isolation RR;
+ERROR X0X03: Invalid transaction state - held cursor requires same isolation level
+ij> commit;
+ij> -- attempt to change isolation level should give error because of jdk4 hold cursor
+set isolation = REPEATABLE READ;
+ERROR X0X03: Invalid transaction state - held cursor requires same isolation level
+ij> -- close jdk4 and then should be able to change isolation
+close jdk4;
+ij> set isolation to serializable;
+0 rows inserted/updated/deleted
+ij> -- fifth test - try isolation level change alongwith changing the isolation
+-- level of just one statement
+get with hold cursor jdk4 as 'SELECT * FROM t1';
+ij> get with nohold cursor jdk1 as 'SELECT * FROM t1 WITH CS';
+IJ ERROR: Holdability can not be changed using jdbc3.0 apis in JDKs lower than JDK1.4.
+ij> next jdk4;
+C11 |C12
+-----------------------
+1 |1
+ij> next jdk1;
+IJ ERROR: Unable to establish cursor
+ij> -- following should fail because of cursor jdk4
+set isolation RS;
+ERROR X0X03: Invalid transaction state - held cursor requires same isolation level
+ij> -- following should fail because of cursor jdk4
+set isolation UR;
+ERROR X0X03: Invalid transaction state - held cursor requires same isolation level
+ij> close jdk4;
+ij> -- should be able to change the isolation now
+set isolation READ UNCOMMITTED;
+0 rows inserted/updated/deleted
+ij> set isolation RS;
+0 rows inserted/updated/deleted
+ij> -- sixth test - try positioned update with hold cursor
+get with hold cursor jdk4 as 'SELECT * FROM t1 FOR UPDATE';
+ij> -- following should give error because cursor is not positioned on any row
+update t1 set c12=12 where current of jdk4;
+ERROR XCL08: Cursor 'JDK4' is not on a row.
+ij> select * from t1;
+C11 |C12
+-----------------------
+1 |1
+2 |2
+ij> next jdk4;
+C11 |C12
+-----------------------
+1 |1
+ij> update t1 set c12=12 where current of jdk4;
+1 row inserted/updated/deleted
+ij> select * from t1;
+C11 |C12
+-----------------------
+1 |12
+2 |2
+ij> commit;
+ij> -- after commit, the next transaction should do a fetch again before doing
+-- any positioned update
+update t1 set c12=123 where current of jdk4;
+ERROR 24000: Invalid cursor state - no current row.
+ij> select * from t1;
+C11 |C12
+-----------------------
+1 |12
+2 |2
+ij> next jdk4;
+C11 |C12
+-----------------------
+2 |2
+ij> update t1 set c12=23 where current of jdk4;
+1 row inserted/updated/deleted
+ij> select * from t1;
+C11 |C12
+-----------------------
+1 |12
+2 |23
+ij> close jdk4;
+ij> update t1 set c12=234 where current of jdk4;
+ERROR 42X30: Cursor 'JDK4' not found. Verify that autocommit is OFF.
+ij> select * from t1;
+C11 |C12
+-----------------------
+1 |12
+2 |23
+ij> -- seventh test - try positioned delete with hold cursor
+get with hold cursor jdk4 as 'SELECT * FROM t1 FOR UPDATE';
+ij> -- following should give error because cursor is not positioned on any row
+delete from t1 where current of jdk4;
+ERROR XCL08: Cursor 'JDK4' is not on a row.
+ij> select * from t1;
+C11 |C12
+-----------------------
+1 |12
+2 |23
+ij> next jdk4;
+C11 |C12
+-----------------------
+1 |12
+ij> delete from t1 where current of jdk4;
+1 row inserted/updated/deleted
+ij> select * from t1;
+C11 |C12
+-----------------------
+2 |23
+ij> commit;
+ij> -- after commit, the next transaction should do a fetch again before doing
+-- any positioned delete
+delete from t1 where current of jdk4;
+ERROR 24000: Invalid cursor state - no current row.
+ij> select * from t1;
+C11 |C12
+-----------------------
+2 |23
+ij> next jdk4;
+C11 |C12
+-----------------------
+2 |23
+ij> delete from t1 where current of jdk4;
+1 row inserted/updated/deleted
+ij> select * from t1;
+C11 |C12
+-----------------------
+ij> close jdk4;
+ij> delete from t1 where current of jdk4;
+ERROR XCL07: Cursor 'JDK4' is closed. Verify that autocommit is OFF.
+ij> select * from t1;
+C11 |C12
+-----------------------
+ij> -- populate the table for next test
+insert into t1 values(1,1);
+1 row inserted/updated/deleted
+ij> insert into t1 values(2,2);
+1 row inserted/updated/deleted
+ij> -- eighth test - scrollable cursors
+get scroll insensitive with hold cursor jdk4 as 'SELECT * FROM t1';
+ij> commit;
+ij> previous jdk4;
+No current row
+ij> after last jdk4;
+No current row
+ij> before first jdk4;
+No current row
+ij> first jdk4;
+C11 |C12
+-----------------------
+1 |1
+ij> last jdk4;
+C11 |C12
+-----------------------
+2 |2
+ij> next jdk4;
+No current row
+ij> previous jdk4;
+C11 |C12
+-----------------------
+2 |2
+ij> next jdk4;
+No current row
+ij> close jdk4;
+ij> first jdk4;
+IJ ERROR: Unable to establish cursor
+ij> -- ninth test - close the updateable holdable cursor after commit
+-- we get npe
+get with hold cursor jdk4 as 'SELECT * FROM T1 FOR UPDATE';
+ij> next jdk4;
+C11 |C12
+-----------------------
+1 |1
+ij> commit;
+ij> close jdk4;
+ij> -- tenth test - bug 4515 - have a more useful message
+-- update where current of fails in autocommit=true, held open cursor
+autocommit on;
+ij> get with hold cursor scrollCursor as 'select * from t1 for update of c12';
+ij> next scrollCursor;
+C11 |C12
+-----------------------
+1 |1
+ij> update t1 set c12=c12+1 where current of scrollCursor;
+ERROR 24000: Invalid cursor state - no current row.
+ij>
Propchange: db/derby/code/branches/10.0/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/holdCursorIJ.out
------------------------------------------------------------------------------
svn:eol-style = native