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 [1/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
Author: mamta
Date: Wed Mar  5 13:25:53 2008
New Revision: 634037

URL: http://svn.apache.org/viewvc?rev=634037&view=rev
Log:
DERBY-3458

Patch submitted by Stephan van Loendersloot. dblook should set the current schema to be
a system schema so that collation of system schema (UCS_BASIC) gets used when dealing
with queries using system table columns and character constants. Stephan has also
provided comprehensive test for the dblook code change.


Added:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/dblook_test_net_territory.out
  (with props)
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/dblook_test_net_territory.out
  (with props)
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dblook_test_territory.out
  (with props)
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory.java
  (with props)
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net_territory_app.properties
  (with props)
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory.java
  (with props)
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory_app.properties
  (with props)
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test_territory_sed.properties
  (with props)
Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetClientRemote.exclude
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetClientUseprocess.exclude
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetRemote.exclude
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/DerbyNetUseprocess.exclude
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.runall
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbytools.runall
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/j9derbynetmats.runall
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/NetHarnessJavaTest.java
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dblook_test_net.java
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test.java
    db/derby/code/trunk/java/tools/org/apache/derby/tools/dblook.java

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/dblook_test_net_territory.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/dblook_test_net_territory.out?rev=634037&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/dblook_test_net_territory.out
(added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/dblook_test_net_territory.out
Wed Mar  5 13:25:53 2008
@@ -0,0 +1,1954 @@
+-----= Start dblook (net server) Test. =-
+Creating database 'wombat' from ddl script 'dblook_makeDB.sql'
+-----
+*******************************************
+Dumping DDL for all objects, using
+Network Server:
+*******************************************
+File dblook.log was empty.
+Creating database 'wombat_new' from ddl script 'wombat.sql'
+Dumping system tables for 'wombat_new'
+-----=================---------------
+System Tables for: wombat_new
+-----=================---------------
+========== SYSALIASES ==========
+<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.
+[ Done. ]

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

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/dblook_test_net_territory.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/dblook_test_net_territory.out?rev=634037&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/dblook_test_net_territory.out
(added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/dblook_test_net_territory.out
Wed Mar  5 13:25:53 2008
@@ -0,0 +1,1954 @@
+-----= Start dblook (net server) Test. =-
+Creating database 'wombat' from ddl script 'dblook_makeDB.sql'
+-----
+*******************************************
+Dumping DDL for all objects, using
+Network Server:
+*******************************************
+File dblook.log was empty.
+Creating database 'wombat_new' from ddl script 'wombat.sql'
+Dumping system tables for 'wombat_new'
+-----=================---------------
+System Tables for: wombat_new
+-----=================---------------
+========== SYSALIASES ==========
+<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.
+[ Done. ]

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



Mime
View raw message