| -= 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> |
| F_DEFINERS_RIGHTS |
| APP |
| foo.bar |
| F |
| F |
| false |
| wibble() RETURNS INTEGER LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL SECURITY DEFINER NO SQL CALLED ON NULL INPUT |
| <systemname> |
| ---- |
| <systemid> |
| F_DETERMINISTIC |
| APP |
| foo.bar |
| F |
| F |
| false |
| wibble() RETURNS INTEGER LANGUAGE JAVA PARAMETER STYLE JAVA DETERMINISTIC NO SQL CALLED ON NULL INPUT |
| <systemname> |
| ---- |
| <systemid> |
| F_NOT_DETERMINISTIC |
| APP |
| foo.bar |
| F |
| F |
| false |
| wibble() RETURNS INTEGER LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL CALLED ON NULL INPUT |
| <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> |
| P_DEFINERS_RIGHTS |
| APP |
| foo.bar |
| P |
| P |
| false |
| wibble() LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL SECURITY DEFINER MODIFIES SQL DATA |
| <systemname> |
| ---- |
| <systemid> |
| P_DETERMINISTIC |
| APP |
| foo.bar |
| P |
| P |
| false |
| wibble() LANGUAGE JAVA PARAMETER STYLE JAVA DETERMINISTIC MODIFIES SQL DATA |
| <systemname> |
| ---- |
| <systemid> |
| P_NOT_DETERMINISTIC |
| APP |
| foo.bar |
| P |
| P |
| false |
| wibble() LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES 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> |
| VARARGSDERBYSTYLE |
| APP |
| Foo |
| F |
| F |
| false |
| foo("A" INTEGER ... ) RETURNS INTEGER LANGUAGE JAVA PARAMETER STYLE DERBY NO SQL CALLED ON NULL INPUT |
| <systemname> |
| ---- |
| <systemid> |
| VARARGSDERBYSTYLE |
| APP |
| Foo |
| P |
| P |
| false |
| foo(IN "A" INTEGER ... ) LANGUAGE JAVA PARAMETER STYLE DERBY NO SQL |
| <systemname> |
| ---- |
| <systemid> |
| VARARGSTABLEFUNCTION |
| APP |
| Foo |
| F |
| F |
| false |
| foo("A" INTEGER ... ) RETURNS TABLE ( "B" INTEGER ) LANGUAGE JAVA PARAMETER STYLE DERBY_JDBC_RESULT_SET NO SQL CALLED ON NULL INPUT |
| <systemname> |
| ---- |
| <systemid> |
| func "' |
| schema "' |
| java.lang.Integer |
| F |
| F |
| false |
| toString("col with quotes ""'" INTEGER) RETURNS VARCHAR(20) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA CALLED ON NULL INPUT |
| <systemname> |
| ---- |
| <systemid> |
| proc "' |
| schema "' |
| java.lang.Thread |
| P |
| P |
| false |
| sleep(IN "col with quotes ""'" BIGINT) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA |
| <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 |
| ---- |
| 'Single' and "double" quoted table name |
| 'Single' and "double" quoted column name |
| 1 |
| 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 |
| ---- |
| T_GENCOL_1 |
| A |
| 1 |
| INTEGER |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T_GENCOL_1 |
| B |
| 2 |
| INTEGER |
| GENERATED ALWAYS AS ( 1 ) |
| <systemid> |
| <autoincval> |
| null |
| null |
| ---- |
| T_GENCOL_1 |
| C |
| 3 |
| INTEGER |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T_GENCOL_2 |
| A |
| 1 |
| INTEGER |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T_GENCOL_2 |
| B |
| 2 |
| INTEGER |
| <systemid> |
| <systemid> |
| <autoincval> |
| null |
| null |
| ---- |
| T_GENCOL_2 |
| C |
| 3 |
| INTEGER |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T_GENCOL_3 |
| A |
| 1 |
| INTEGER |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T_GENCOL_3 |
| B |
| 2 |
| INTEGER |
| GENERATED ALWAYS AS ( a + c ) |
| <systemid> |
| <autoincval> |
| null |
| null |
| ---- |
| T_GENCOL_3 |
| C |
| 3 |
| INTEGER |
| 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> |
| ---- |
| 'Single' and "double" quoted schema name |
| 'Single' and "double" quoted table name |
| <systemnumber> |
| 'Single' and "double" quoted table name |
| 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 |
| T_GENCOL_1 |
| <systemnumber> |
| T_GENCOL_1 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| APP |
| T_GENCOL_2 |
| <systemnumber> |
| T_GENCOL_2 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| APP |
| T_GENCOL_3 |
| <systemnumber> |
| T_GENCOL_3 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| APP |
| X |
| <systemnumber> |
| X |
| false |
| null |
| false |
| <systemid> |
| ---- |
| APP |
| tquote"One |
| <systemnumber> |
| <systemname> |
| true |
| UNIQUE BTREE (1) |
| true |
| <systemid> |
| ---- |
| APP |
| tquote"One |
| <systemnumber> |
| tquote"One |
| false |
| null |
| false |
| <systemid> |
| ---- |
| APP |
| tquoteThree" |
| <systemnumber> |
| <systemname> |
| true |
| UNIQUE BTREE (1) |
| true |
| <systemid> |
| ---- |
| APP |
| tquoteThree" |
| <systemnumber> |
| tquoteThree" |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| MULTI WORD NAME |
| <systemnumber> |
| MULTI WORD NAME |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| T1 |
| <systemnumber> |
| <systemname> |
| true |
| UNIQUE BTREE (1) |
| true |
| <systemid> |
| ---- |
| BAR |
| T1 |
| <systemnumber> |
| T1 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| T3 |
| <systemnumber> |
| IX2 |
| true |
| BTREE (1 DESC, 3 DESC) |
| false |
| <systemid> |
| ---- |
| BAR |
| T3 |
| <systemnumber> |
| T3 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| T3_2 |
| <systemnumber> |
| T3_2 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| T4 |
| <systemnumber> |
| IX4 |
| true |
| UNIQUE BTREE (3) |
| false |
| <systemid> |
| ---- |
| BAR |
| T4 |
| <systemnumber> |
| T4 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| T4_2 |
| <systemnumber> |
| T4_2 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| T8 |
| <systemnumber> |
| <systemname> |
| true |
| BTREE (2) |
| true |
| <systemid> |
| ---- |
| BAR |
| T8 |
| <systemnumber> |
| <systemname> |
| true |
| UNIQUE BTREE (1) |
| true |
| <systemid> |
| ---- |
| BAR |
| T8 |
| <systemnumber> |
| T8 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| tWithKeys |
| <systemnumber> |
| <systemname> |
| true |
| UNIQUE BTREE (1) |
| true |
| <systemid> |
| ---- |
| BAR |
| tWithKeys |
| <systemnumber> |
| IX3 |
| true |
| BTREE (1 DESC) |
| false |
| <systemid> |
| ---- |
| BAR |
| tWithKeys |
| <systemnumber> |
| tWithKeys |
| false |
| null |
| false |
| <systemid> |
| ---- |
| FOO |
| T10 |
| <systemnumber> |
| <systemname> |
| true |
| UNIQUE BTREE (2) |
| true |
| <systemid> |
| ---- |
| FOO |
| T10 |
| <systemnumber> |
| <systemname> |
| true |
| UNIQUE BTREE (3) |
| true |
| <systemid> |
| ---- |
| FOO |
| T10 |
| <systemnumber> |
| T10 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| FOO |
| T9 |
| <systemnumber> |
| <systemname> |
| true |
| BTREE (1) |
| true |
| <systemid> |
| ---- |
| FOO |
| T9 |
| <systemnumber> |
| <systemname> |
| true |
| UNIQUE BTREE (2, 1) |
| true |
| <systemid> |
| ---- |
| FOO |
| T9 |
| <systemnumber> |
| T9 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| Foo Bar |
| T5 |
| <systemnumber> |
| CostIndex |
| true |
| UNIQUE BTREE (1) |
| false |
| <systemid> |
| ---- |
| Foo Bar |
| T5 |
| <systemnumber> |
| T5 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| Foo Bar |
| T6 |
| <systemnumber> |
| T6 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| Foo Bar |
| T7 |
| <systemnumber> |
| T7 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| ========== SYSCONSTRAINTS ========== |
| "ck2 |
| "tquoteTwo |
| "ck2 |
| C |
| APP |
| E |
| 0 |
| ---- |
| "effkay1 |
| "tquoteTwo |
| "effkay1 |
| F |
| APP |
| E |
| 0 |
| ---- |
| <systemname> |
| T10 |
| <systemname> |
| P |
| FOO |
| E |
| 1 |
| ---- |
| <systemname> |
| T10 |
| <systemname> |
| U |
| FOO |
| E |
| 0 |
| ---- |
| <systemname> |
| T8 |
| <systemname> |
| F |
| BAR |
| E |
| 0 |
| ---- |
| <systemname> |
| T8 |
| <systemname> |
| P |
| BAR |
| E |
| 0 |
| ---- |
| <systemname> |
| tWithKeys |
| <systemname> |
| C |
| BAR |
| E |
| 0 |
| ---- |
| <systemname> |
| tWithKeys |
| <systemname> |
| P |
| BAR |
| E |
| 1 |
| ---- |
| NOTEVIL |
| tWithKeys |
| NOTEVIL |
| C |
| BAR |
| E |
| 0 |
| ---- |
| <systemname> |
| T11 |
| <systemname> |
| F |
| APP |
| E |
| 0 |
| ---- |
| UNQ |
| T1 |
| UNQ |
| U |
| BAR |
| E |
| 0 |
| ---- |
| c"k1 |
| tquote"One |
| c"k1 |
| C |
| APP |
| E |
| 0 |
| ---- |
| chkOne |
| T10 |
| chkOne |
| C |
| FOO |
| E |
| 0 |
| ---- |
| ck2" |
| tquoteThree" |
| ck2" |
| C |
| APP |
| E |
| 0 |
| ---- |
| fkOne |
| T9 |
| fkOne |
| F |
| FOO |
| E |
| 0 |
| ---- |
| pee"kay1 |
| tquote"One |
| pee"kay1 |
| P |
| APP |
| E |
| 1 |
| ---- |
| pkTwo |
| T9 |
| pkTwo |
| P |
| FOO |
| E |
| 1 |
| ---- |
| <systemname> |
| tee""Hee |
| <systemname> |
| P |
| "Quoted"Schema" |
| E |
| 0 |
| ---- |
| unqkay1" |
| tquoteThree" |
| unqkay1" |
| U |
| APP |
| E |
| 0 |
| ---- |
| ========== SYSDEPENDS ========== |
| "effkay1 |
| <Constraint>APP."effkay1 -> <Constraint>APP.pee"kay1 |
| Constraint |
| pee"kay1 |
| Constraint |
| ---- |
| <systemname> |
| <Constraint>APP.<sysname> -> <Constraint>FOO.pkTwo |
| Constraint |
| pkTwo |
| Constraint |
| ---- |
| <systemname> |
| <Constraint>BAR.<sysname> -> <Constraint>BAR.<sysname> |
| Constraint |
| <systemname> |
| Constraint |
| ---- |
| fkOne |
| <Constraint>FOO.fkOne -> <Constraint>FOO.<sysname> |
| Constraint |
| <systemname> |
| Constraint |
| ---- |
| <systemid> |
| <StoredPreparedStatement>"Quoted"Schema".<sysname> -> <Table>"Quoted"Schema".tee""Hee |
| StoredPreparedStatement |
| tee""Hee |
| Table |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <ColumnsInTable>BAR.T4 |
| StoredPreparedStatement |
| T4 |
| ColumnsInTable |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <ColumnsInTable>BAR.tWithKeys |
| StoredPreparedStatement |
| tWithKeys |
| ColumnsInTable |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <Conglomerate>APP.<sysname> |
| StoredPreparedStatement |
| <systemid> |
| Conglomerate |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <Table>APP.REMOVED |
| StoredPreparedStatement |
| REMOVED |
| Table |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <Table>APP.X |
| StoredPreparedStatement |
| X |
| Table |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <Table>BAR.T3 |
| StoredPreparedStatement |
| T3 |
| Table |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <Table>BAR.tWithKeys |
| StoredPreparedStatement |
| tWithKeys |
| Table |
| ---- |
| <systemid> |
| <StoredPreparedStatement>BAR.<sysname> -> <Table>BAR.T8 |
| StoredPreparedStatement |
| T8 |
| Table |
| ---- |
| <systemid> |
| <StoredPreparedStatement>Foo Bar.<sysname> -> <Table>BAR.T1 |
| StoredPreparedStatement |
| T1 |
| Table |
| ---- |
| <systemid> |
| <Trigger>"Quoted"Schema"."trig"One" -> <StoredPreparedStatement>"Quoted"Schema".<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| <systemid> |
| <Trigger>"Quoted"Schema"."trig"One" -> <Table>"Quoted"Schema".tee""Hee |
| Trigger |
| tee""Hee |
| Table |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGFOUR -> <Conglomerate>APP.<sysname> |
| Trigger |
| <systemid> |
| Conglomerate |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGFOUR -> <StoredPreparedStatement>APP.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGFOUR -> <Table>APP.REMOVED |
| Trigger |
| REMOVED |
| Table |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGFOUR -> <Table>APP.X |
| Trigger |
| X |
| Table |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGONE -> <ColumnsInTable>BAR.T4 |
| Trigger |
| T4 |
| ColumnsInTable |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGONE -> <StoredPreparedStatement>APP.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGONE -> <Table>BAR.T3 |
| Trigger |
| T3 |
| Table |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGWHEN -> <Table>APP.T1 |
| Trigger |
| T1 |
| Table |
| ---- |
| <systemid> |
| <Trigger>APP.TrigThree -> <ColumnsInTable>BAR.tWithKeys |
| Trigger |
| tWithKeys |
| ColumnsInTable |
| ---- |
| <systemid> |
| <Trigger>APP.TrigThree -> <StoredPreparedStatement>APP.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| <systemid> |
| <Trigger>APP.TrigThree -> <Table>BAR.tWithKeys |
| Trigger |
| tWithKeys |
| Table |
| ---- |
| <systemid> |
| <Trigger>BAR.REFTRIG -> <StoredPreparedStatement>BAR.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| <systemid> |
| <Trigger>BAR.REFTRIG -> <Table>BAR.T8 |
| Trigger |
| T8 |
| Table |
| ---- |
| <systemid> |
| <Trigger>Foo Bar.TRIG2 -> <StoredPreparedStatement>Foo Bar.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| <systemid> |
| <Trigger>Foo Bar.TRIG2 -> <Table>BAR.T1 |
| Trigger |
| T1 |
| Table |
| ---- |
| V1 |
| <View>APP.V1 -> <ColumnsInTable>APP.T1 |
| View |
| T1 |
| ColumnsInTable |
| ---- |
| V1 |
| <View>APP.V1 -> <ColumnsInTable>BAR.T3 |
| View |
| T3 |
| ColumnsInTable |
| ---- |
| V2 |
| <View>APP.V2 -> <ColumnsInTable>BAR.T1 |
| View |
| T1 |
| ColumnsInTable |
| ---- |
| viewTwo |
| <View>BAR.viewTwo -> <ColumnsInTable>APP.T11 |
| View |
| T11 |
| ColumnsInTable |
| ---- |
| V1 |
| <View>FOO.V1 -> <ColumnsInTable>Foo Bar.T6 |
| View |
| T6 |
| ColumnsInTable |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.<sysname> |
| StoredPreparedStatement |
| <systemid> |
| Conglomerate |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.<sysname> |
| StoredPreparedStatement |
| <systemid> |
| Conglomerate |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.<sysname> |
| StoredPreparedStatement |
| <systemid> |
| Conglomerate |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <Table>APP.T1 |
| StoredPreparedStatement |
| T1 |
| Table |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <Table>APP.T1 |
| StoredPreparedStatement |
| T1 |
| Table |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGWHEN -> <StoredPreparedStatement>APP.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGWHEN -> <StoredPreparedStatement>APP.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| ========== 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 |
| ---- |
| 'Single' and "double" quoted schema name |
| 'Single' and "double" quoted schema name |
| APP |
| ---- |
| APP |
| APP |
| APP |
| ---- |
| BAR |
| BAR |
| APP |
| ---- |
| FOO |
| FOO |
| APP |
| ---- |
| Foo Bar |
| Foo Bar |
| APP |
| ---- |
| schema "' |
| schema "' |
| APP |
| ---- |
| ========== SYSSTATEMENTS ========== |
| <systemid> |
| <systemname> |
| APP |
| T |
| <validityflag> |
| insert into "APP"."REMOVED" select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLD where x not in (select x from new org.apache.derby.catalog.TriggerNewTransitionRows() NEW where x < 10) |
| <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> |
| APP |
| T |
| <validityflag> |
| values 1 |
| <systemid> |
| APP |
| null |
| ---- |
| <systemid> |
| <systemid> |
| APP |
| T |
| <validityflag> |
| VALUES exists (select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLD where i > 4) |
| <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 |
| ---- |
| 'Single' and "double" quoted table name |
| 'Single' and "double" quoted table name |
| T |
| 'Single' and "double" quoted schema name |
| R |
| ---- |
| MULTI WORD NAME |
| MULTI WORD NAME |
| T |
| BAR |
| R |
| ---- |
| REMOVED |
| REMOVED |
| T |
| APP |
| R |
| ---- |
| SYNONYM1 |
| SYNONYM1 |
| A |
| APP |
| R |
| ---- |
| SYNONYM2 |
| SYNONYM2 |
| A |
| BAR |
| R |
| ---- |
| SYNONYM3 |
| SYNONYM3 |
| A |
| BAR |
| R |
| ---- |
| T10 |
| T10 |
| T |
| FOO |
| R |
| ---- |
| T11 |
| T11 |
| T |
| APP |
| R |
| ---- |
| T1 |
| T1 |
| T |
| APP |
| R |
| ---- |
| T1 |
| T1 |
| T |
| BAR |
| R |
| ---- |
| T2 |
| T2 |
| T |
| APP |
| R |
| ---- |
| T3 |
| T3 |
| T |
| BAR |
| R |
| ---- |
| T3_2 |
| T3_2 |
| T |
| BAR |
| R |
| ---- |
| T4 |
| T4 |
| T |
| BAR |
| R |
| ---- |
| T4_2 |
| T4_2 |
| T |
| BAR |
| R |
| ---- |
| T5 |
| T5 |
| T |
| Foo Bar |
| R |
| ---- |
| T6 |
| T6 |
| T |
| Foo Bar |
| R |
| ---- |
| T7 |
| T7 |
| T |
| Foo Bar |
| R |
| ---- |
| T8T1T4 |
| T8T1T4 |
| T |
| APP |
| R |
| ---- |
| T8 |
| T8 |
| T |
| BAR |
| R |
| ---- |
| T9 |
| T9 |
| T |
| FOO |
| R |
| ---- |
| T_GENCOL_1 |
| T_GENCOL_1 |
| T |
| APP |
| R |
| ---- |
| T_GENCOL_2 |
| T_GENCOL_2 |
| T |
| APP |
| R |
| ---- |
| T_GENCOL_3 |
| T_GENCOL_3 |
| T |
| APP |
| R |
| ---- |
| V"3 |
| V"3 |
| V |
| APP |
| R |
| ---- |
| V1 |
| V1 |
| V |
| APP |
| R |
| ---- |
| V1 |
| V1 |
| V |
| FOO |
| R |
| ---- |
| V2 |
| V2 |
| V |
| APP |
| R |
| ---- |
| X |
| X |
| T |
| APP |
| R |
| ---- |
| tWithKeys |
| tWithKeys |
| T |
| BAR |
| R |
| ---- |
| tee""Hee |
| tee""Hee |
| T |
| "Quoted"Schema" |
| R |
| ---- |
| tquote"One |
| tquote"One |
| T |
| APP |
| R |
| ---- |
| tquoteThree" |
| tquoteThree" |
| T |
| APP |
| R |
| ---- |
| viewTwo |
| viewTwo |
| V |
| BAR |
| R |
| ---- |
| ========== SYSTRIGGERS ========== |
| <systemid> |
| "trig"One" |
| "Quoted"Schema" |
| <systemid> |
| I |
| A |
| R |
| E |
| tee""Hee |
| null |
| <systemid> |
| null |
| values(8) |
| false |
| false |
| null |
| null |
| null |
| ---- |
| <systemid> |
| REFTRIG |
| BAR |
| <systemid> |
| D |
| A |
| S |
| E |
| T8 |
| null |
| <systemid> |
| null |
| select * from oldtable |
| true |
| false |
| OLDTABLE |
| null |
| null |
| ---- |
| <systemid> |
| TRIG2 |
| Foo Bar |
| <systemid> |
| D |
| B |
| S |
| E |
| T1 |
| null |
| <systemid> |
| null |
| values (1), (2) |
| false |
| false |
| null |
| null |
| null |
| ---- |
| <systemid> |
| TRIGFOUR |
| APP |
| <systemid> |
| U |
| A |
| S |
| E |
| X |
| null |
| <systemid> |
| (1) |
| insert into "APP"."REMOVED" select * from old where x not in (select x from new where x < 10) |
| true |
| true |
| OLD |
| NEW |
| null |
| ---- |
| <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 |
| null |
| ---- |
| <systemid> |
| TRIGWHEN |
| APP |
| <systemid> |
| U |
| A |
| S |
| E |
| T1 |
| <systemid> |
| <systemid> |
| null |
| values 1 |
| true |
| false |
| OLD |
| null |
| exists (select * from old where i > 4) |
| ---- |
| <systemid> |
| TrigThree |
| APP |
| <systemid> |
| U |
| A |
| R |
| E |
| tWithKeys |
| null |
| <systemid> |
| (1,2) |
| select c from "BAR"."tWithKeys" |
| false |
| false |
| null |
| null |
| null |
| ---- |
| ========== SYSVIEWS ========== |
| V"3 |
| create view "V""3"(i) as values (8), (28), (78) |
| N |
| APP |
| ---- |
| V1 |
| create view v1 (dum, dee, dokie) as select a.d, a.c, b.p1 from t1 as a, bar.t3 as b |
| N |
| APP |
| ---- |
| V1 |
| create view v1 (doo, dwa) as select num, letter from "Foo Bar".t6 |
| N |
| FOO |
| ---- |
| V2 |
| create view v2 as select * from bar.t1 |
| N |
| APP |
| ---- |
| viewTwo |
| create view bar."viewTwo" as select * from app.t11 |
| N |
| APP |
| ---- |
| ========== SYSROLES ========== |
| "eve" |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| "eve" |
| B |
| APP |
| N |
| N |
| ---- |
| A |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| A |
| B |
| APP |
| N |
| N |
| ---- |
| B |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| B |
| WHOMEVER |
| APP |
| N |
| N |
| ---- |
| -- |
| ******************************************* |
| 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> |
| F_DEFINERS_RIGHTS |
| APP |
| foo.bar |
| F |
| F |
| false |
| wibble() RETURNS INTEGER LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL SECURITY DEFINER NO SQL CALLED ON NULL INPUT |
| <systemname> |
| ---- |
| <systemid> |
| F_DETERMINISTIC |
| APP |
| foo.bar |
| F |
| F |
| false |
| wibble() RETURNS INTEGER LANGUAGE JAVA PARAMETER STYLE JAVA DETERMINISTIC NO SQL CALLED ON NULL INPUT |
| <systemname> |
| ---- |
| <systemid> |
| F_NOT_DETERMINISTIC |
| APP |
| foo.bar |
| F |
| F |
| false |
| wibble() RETURNS INTEGER LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL CALLED ON NULL INPUT |
| <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> |
| P_DEFINERS_RIGHTS |
| APP |
| foo.bar |
| P |
| P |
| false |
| wibble() LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL SECURITY DEFINER MODIFIES SQL DATA |
| <systemname> |
| ---- |
| <systemid> |
| P_DETERMINISTIC |
| APP |
| foo.bar |
| P |
| P |
| false |
| wibble() LANGUAGE JAVA PARAMETER STYLE JAVA DETERMINISTIC MODIFIES SQL DATA |
| <systemname> |
| ---- |
| <systemid> |
| P_NOT_DETERMINISTIC |
| APP |
| foo.bar |
| P |
| P |
| false |
| wibble() LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES 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> |
| VARARGSDERBYSTYLE |
| APP |
| Foo |
| F |
| F |
| false |
| foo("A" INTEGER ... ) RETURNS INTEGER LANGUAGE JAVA PARAMETER STYLE DERBY NO SQL CALLED ON NULL INPUT |
| <systemname> |
| ---- |
| <systemid> |
| VARARGSDERBYSTYLE |
| APP |
| Foo |
| P |
| P |
| false |
| foo(IN "A" INTEGER ... ) LANGUAGE JAVA PARAMETER STYLE DERBY NO SQL |
| <systemname> |
| ---- |
| <systemid> |
| VARARGSTABLEFUNCTION |
| APP |
| Foo |
| F |
| F |
| false |
| foo("A" INTEGER ... ) RETURNS TABLE ( "B" INTEGER ) LANGUAGE JAVA PARAMETER STYLE DERBY_JDBC_RESULT_SET NO SQL CALLED ON NULL INPUT |
| <systemname> |
| ---- |
| <systemid> |
| func "' |
| schema "' |
| java.lang.Integer |
| F |
| F |
| false |
| toString("col with quotes ""'" INTEGER) RETURNS VARCHAR(20) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA CALLED ON NULL INPUT |
| <systemname> |
| ---- |
| <systemid> |
| proc "' |
| schema "' |
| java.lang.Thread |
| P |
| P |
| false |
| sleep(IN "col with quotes ""'" BIGINT) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA |
| <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 |
| ---- |
| 'Single' and "double" quoted table name |
| 'Single' and "double" quoted column name |
| 1 |
| 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 |
| ---- |
| T_GENCOL_1 |
| A |
| 1 |
| INTEGER |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T_GENCOL_1 |
| B |
| 2 |
| INTEGER |
| GENERATED ALWAYS AS ( 1 ) |
| <systemid> |
| <autoincval> |
| null |
| null |
| ---- |
| T_GENCOL_1 |
| C |
| 3 |
| INTEGER |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T_GENCOL_2 |
| A |
| 1 |
| INTEGER |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T_GENCOL_2 |
| B |
| 2 |
| INTEGER |
| <systemid> |
| <systemid> |
| <autoincval> |
| null |
| null |
| ---- |
| T_GENCOL_2 |
| C |
| 3 |
| INTEGER |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T_GENCOL_3 |
| A |
| 1 |
| INTEGER |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T_GENCOL_3 |
| B |
| 2 |
| INTEGER |
| GENERATED ALWAYS AS ( a + c ) |
| <systemid> |
| <autoincval> |
| null |
| null |
| ---- |
| T_GENCOL_3 |
| C |
| 3 |
| INTEGER |
| 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> |
| ---- |
| 'Single' and "double" quoted schema name |
| 'Single' and "double" quoted table name |
| <systemnumber> |
| 'Single' and "double" quoted table name |
| 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 |
| T_GENCOL_1 |
| <systemnumber> |
| T_GENCOL_1 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| APP |
| T_GENCOL_2 |
| <systemnumber> |
| T_GENCOL_2 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| APP |
| T_GENCOL_3 |
| <systemnumber> |
| T_GENCOL_3 |
| 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 -> <Conglomerate>APP.<sysname> |
| Trigger |
| <systemid> |
| Conglomerate |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGFOUR -> <StoredPreparedStatement>APP.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGFOUR -> <Table>APP.REMOVED |
| Trigger |
| REMOVED |
| Table |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGFOUR -> <Table>APP.X |
| Trigger |
| X |
| Table |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGONE -> <ColumnsInTable>BAR.T4 |
| Trigger |
| T4 |
| ColumnsInTable |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGONE -> <StoredPreparedStatement>APP.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGONE -> <Table>BAR.T3 |
| Trigger |
| T3 |
| Table |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGWHEN -> <Table>APP.T1 |
| Trigger |
| T1 |
| Table |
| ---- |
| <systemid> |
| <Trigger>APP.TrigThree -> <ColumnsInTable>BAR.tWithKeys |
| Trigger |
| tWithKeys |
| ColumnsInTable |
| ---- |
| <systemid> |
| <Trigger>APP.TrigThree -> <StoredPreparedStatement>APP.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| <systemid> |
| <Trigger>APP.TrigThree -> <Table>BAR.tWithKeys |
| Trigger |
| tWithKeys |
| Table |
| ---- |
| <systemid> |
| <Trigger>BAR.REFTRIG -> <StoredPreparedStatement>BAR.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| <systemid> |
| <Trigger>BAR.REFTRIG -> <Table>BAR.T8 |
| Trigger |
| T8 |
| Table |
| ---- |
| <systemid> |
| <Trigger>Foo Bar.TRIG2 -> <StoredPreparedStatement>Foo Bar.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| <systemid> |
| <Trigger>Foo Bar.TRIG2 -> <Table>BAR.T1 |
| Trigger |
| T1 |
| Table |
| ---- |
| V1 |
| <View>APP.V1 -> <ColumnsInTable>APP.T1 |
| View |
| T1 |
| ColumnsInTable |
| ---- |
| V1 |
| <View>APP.V1 -> <ColumnsInTable>BAR.T3 |
| View |
| T3 |
| ColumnsInTable |
| ---- |
| V2 |
| <View>APP.V2 -> <ColumnsInTable>BAR.T1 |
| View |
| T1 |
| ColumnsInTable |
| ---- |
| viewTwo |
| <View>BAR.viewTwo -> <ColumnsInTable>APP.T11 |
| View |
| T11 |
| ColumnsInTable |
| ---- |
| V1 |
| <View>FOO.V1 -> <ColumnsInTable>Foo Bar.T6 |
| View |
| T6 |
| ColumnsInTable |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.<sysname> |
| StoredPreparedStatement |
| <systemid> |
| Conglomerate |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.<sysname> |
| StoredPreparedStatement |
| <systemid> |
| Conglomerate |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <Table>APP.T1 |
| StoredPreparedStatement |
| T1 |
| Table |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <Table>APP.T1 |
| StoredPreparedStatement |
| T1 |
| Table |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGWHEN -> <StoredPreparedStatement>APP.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGWHEN -> <StoredPreparedStatement>APP.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| ========== 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 |
| ---- |
| 'Single' and "double" quoted schema name |
| 'Single' and "double" quoted schema name |
| APP |
| ---- |
| APP |
| APP |
| APP |
| ---- |
| BAR |
| BAR |
| APP |
| ---- |
| FOO |
| FOO |
| APP |
| ---- |
| Foo Bar |
| Foo Bar |
| APP |
| ---- |
| schema "' |
| schema "' |
| APP |
| ---- |
| ========== SYSSTATEMENTS ========== |
| <systemid> |
| <systemname> |
| APP |
| T |
| <validityflag> |
| insert into "APP"."REMOVED" select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLD where x not in (select x from new org.apache.derby.catalog.TriggerNewTransitionRows() NEW where x < 10) |
| <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> |
| APP |
| T |
| <validityflag> |
| values 1 |
| <systemid> |
| APP |
| null |
| ---- |
| <systemid> |
| <systemid> |
| APP |
| T |
| <validityflag> |
| VALUES exists (select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLD where i > 4) |
| <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 |
| ---- |
| 'Single' and "double" quoted table name |
| 'Single' and "double" quoted table name |
| T |
| 'Single' and "double" quoted schema name |
| R |
| ---- |
| MULTI WORD NAME |
| MULTI WORD NAME |
| T |
| BAR |
| R |
| ---- |
| REMOVED |
| REMOVED |
| T |
| APP |
| R |
| ---- |
| SYNONYM1 |
| SYNONYM1 |
| A |
| APP |
| R |
| ---- |
| SYNONYM2 |
| SYNONYM2 |
| A |
| BAR |
| R |
| ---- |
| SYNONYM3 |
| SYNONYM3 |
| A |
| BAR |
| R |
| ---- |
| T10 |
| T10 |
| T |
| FOO |
| R |
| ---- |
| T11 |
| T11 |
| T |
| APP |
| R |
| ---- |
| T1 |
| T1 |
| T |
| APP |
| R |
| ---- |
| T1 |
| T1 |
| T |
| BAR |
| R |
| ---- |
| T2 |
| T2 |
| T |
| APP |
| R |
| ---- |
| T3 |
| T3 |
| T |
| BAR |
| R |
| ---- |
| T3_2 |
| T3_2 |
| T |
| BAR |
| R |
| ---- |
| T4 |
| T4 |
| T |
| BAR |
| R |
| ---- |
| T4_2 |
| T4_2 |
| T |
| BAR |
| R |
| ---- |
| T5 |
| T5 |
| T |
| Foo Bar |
| R |
| ---- |
| T6 |
| T6 |
| T |
| Foo Bar |
| R |
| ---- |
| T7 |
| T7 |
| T |
| Foo Bar |
| R |
| ---- |
| T8T1T4 |
| T8T1T4 |
| T |
| APP |
| R |
| ---- |
| T8 |
| T8 |
| T |
| BAR |
| R |
| ---- |
| T9 |
| T9 |
| T |
| FOO |
| R |
| ---- |
| T_GENCOL_1 |
| T_GENCOL_1 |
| T |
| APP |
| R |
| ---- |
| T_GENCOL_2 |
| T_GENCOL_2 |
| T |
| APP |
| R |
| ---- |
| T_GENCOL_3 |
| T_GENCOL_3 |
| T |
| APP |
| R |
| ---- |
| V"3 |
| V"3 |
| V |
| APP |
| R |
| ---- |
| V1 |
| V1 |
| V |
| APP |
| R |
| ---- |
| V1 |
| V1 |
| V |
| FOO |
| R |
| ---- |
| V2 |
| V2 |
| V |
| APP |
| R |
| ---- |
| X |
| X |
| T |
| APP |
| R |
| ---- |
| tWithKeys |
| tWithKeys |
| T |
| BAR |
| R |
| ---- |
| tee""Hee |
| tee""Hee |
| T |
| "Quoted"Schema" |
| R |
| ---- |
| tquote"One |
| tquote"One |
| T |
| APP |
| R |
| ---- |
| tquoteThree" |
| tquoteThree" |
| T |
| APP |
| R |
| ---- |
| viewTwo |
| viewTwo |
| V |
| BAR |
| R |
| ---- |
| ========== SYSTRIGGERS ========== |
| <systemid> |
| "trig"One" |
| "Quoted"Schema" |
| <systemid> |
| I |
| A |
| R |
| E |
| tee""Hee |
| null |
| <systemid> |
| null |
| values(8) |
| false |
| false |
| null |
| null |
| null |
| ---- |
| <systemid> |
| REFTRIG |
| BAR |
| <systemid> |
| D |
| A |
| S |
| E |
| T8 |
| null |
| <systemid> |
| null |
| select * from oldtable |
| true |
| false |
| OLDTABLE |
| null |
| null |
| ---- |
| <systemid> |
| TRIG2 |
| Foo Bar |
| <systemid> |
| D |
| B |
| S |
| E |
| T1 |
| null |
| <systemid> |
| null |
| values (1), (2) |
| false |
| false |
| null |
| null |
| null |
| ---- |
| <systemid> |
| TRIGFOUR |
| APP |
| <systemid> |
| U |
| A |
| S |
| E |
| X |
| null |
| <systemid> |
| (1) |
| insert into "APP"."REMOVED" select * from old where x not in (select x from new where x < 10) |
| true |
| true |
| OLD |
| NEW |
| null |
| ---- |
| <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 |
| null |
| ---- |
| <systemid> |
| TRIGWHEN |
| APP |
| <systemid> |
| U |
| A |
| S |
| E |
| T1 |
| <systemid> |
| <systemid> |
| null |
| values 1 |
| true |
| false |
| OLD |
| null |
| exists (select * from old where i > 4) |
| ---- |
| <systemid> |
| TrigThree |
| APP |
| <systemid> |
| U |
| A |
| R |
| E |
| tWithKeys |
| null |
| <systemid> |
| (1,2) |
| select c from "BAR"."tWithKeys" |
| false |
| false |
| null |
| null |
| null |
| ---- |
| ========== SYSVIEWS ========== |
| V"3 |
| create view "V""3"(i) as values (8), (28), (78) |
| N |
| APP |
| ---- |
| V1 |
| create view v1 (dum, dee, dokie) as select a.d, a.c, b.p1 from t1 as a, bar.t3 as b |
| N |
| APP |
| ---- |
| V1 |
| create view v1 (doo, dwa) as select num, letter from "Foo Bar".t6 |
| N |
| FOO |
| ---- |
| V2 |
| create view v2 as select * from bar.t1 |
| N |
| APP |
| ---- |
| viewTwo |
| create view bar."viewTwo" as select * from app.t11 |
| N |
| APP |
| ---- |
| ========== SYSROLES ========== |
| "eve" |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| "eve" |
| B |
| APP |
| N |
| N |
| ---- |
| A |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| A |
| B |
| APP |
| N |
| N |
| ---- |
| B |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| B |
| WHOMEVER |
| APP |
| N |
| N |
| ---- |
| Database 'wombat_new' deleted. |
| -- |
| ******************************************* |
| Dumping DDL for all objects with schema |
| 'BAR', excluding views: |
| ******************************************* |
| File dblook.log was empty. |
| Creating database 'wombat_new' from ddl script 'wombat.sql' |
| Dumping system tables for 'wombat_new' |
| ----------------=================--------------- |
| System Tables for: wombat_new |
| ----------------=================--------------- |
| ========== SYSALIASES ========== |
| <systemid> |
| OP4 |
| BAR |
| org.apache.derbyTesting.functionTests.util.ProcedureTest |
| P |
| P |
| false |
| inoutparams4(OUT "A" DECIMAL(4,2),IN "B" VARCHAR(255)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA |
| <systemname> |
| ---- |
| <systemid> |
| SYNONYM2 |
| BAR |
| null |
| S |
| S |
| false |
| "BAR"."MULTI WORD NAME" |
| <systemname> |
| ---- |
| <systemid> |
| SYNONYM3 |
| BAR |
| null |
| S |
| S |
| false |
| "APP"."T11" |
| <systemname> |
| ---- |
| ========== SYSCHECKS ========== |
| <systemname> |
| (i > 0) |
| (2) |
| ---- |
| NOTEVIL |
| (vc != 'evil') |
| (3) |
| ---- |
| ========== SYSCOLUMNS ========== |
| --- Columns for Tables --- |
| MULTI WORD NAME |
| C |
| 1 |
| CHAR(2) |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T1 |
| C |
| 2 |
| CLOB(15) |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T1 |
| P1 |
| 1 |
| VARCHAR(10) NOT NULL |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T3 |
| B |
| 2 |
| BLOB(20) |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T3 |
| ID |
| 3 |
| INTEGER NOT NULL |
| null |
| null |
| <autoincval> |
| 2 |
| 4 |
| ---- |
| T3 |
| P1 |
| 1 |
| VARCHAR(10) |
| 'okie' |
| <systemid> |
| <autoincval> |
| null |
| null |
| ---- |
| T3_2 |
| B |
| 2 |
| BLOB(20) |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T3_2 |
| ID |
| 3 |
| INTEGER NOT NULL |
| GENERATED_BY_DEFAULT |
| <systemid> |
| <autoincval> |
| 2 |
| 4 |
| ---- |
| T3_2 |
| P1 |
| 1 |
| VARCHAR(10) |
| 'okie' |
| <systemid> |
| <autoincval> |
| null |
| null |
| ---- |
| T4 |
| I |
| 1 |
| INTEGER |
| 2 |
| <systemid> |
| <autoincval> |
| null |
| null |
| ---- |
| T4 |
| J |
| 2 |
| INTEGER NOT NULL |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T4 |
| K |
| 3 |
| INTEGER NOT NULL |
| null |
| null |
| <autoincval> |
| 1 |
| 1 |
| ---- |
| T4_2 |
| I |
| 1 |
| INTEGER |
| 2 |
| <systemid> |
| <autoincval> |
| null |
| null |
| ---- |
| T4_2 |
| J |
| 2 |
| INTEGER NOT NULL |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T4_2 |
| K |
| 3 |
| INTEGER NOT NULL |
| GENERATED_BY_DEFAULT |
| <systemid> |
| <autoincval> |
| 1 |
| 1 |
| ---- |
| T8 |
| FKCHAR |
| 2 |
| CHAR(5) |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T8 |
| SOMEINT |
| 1 |
| INTEGER NOT NULL |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| tWithKeys |
| C |
| 1 |
| CHAR(5) NOT NULL |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| tWithKeys |
| I |
| 2 |
| INTEGER |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| tWithKeys |
| VC |
| 3 |
| VARCHAR(10) |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| --- Columns for Statements --- |
| ========== SYSCONGLOMERATES ========== |
| BAR |
| MULTI WORD NAME |
| <systemnumber> |
| MULTI WORD NAME |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| T1 |
| <systemnumber> |
| <systemname> |
| true |
| UNIQUE BTREE (1) |
| true |
| <systemid> |
| ---- |
| BAR |
| T1 |
| <systemnumber> |
| T1 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| T3 |
| <systemnumber> |
| IX2 |
| true |
| BTREE (1 DESC, 3 DESC) |
| false |
| <systemid> |
| ---- |
| BAR |
| T3 |
| <systemnumber> |
| T3 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| T3_2 |
| <systemnumber> |
| T3_2 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| T4 |
| <systemnumber> |
| IX4 |
| true |
| UNIQUE BTREE (3) |
| false |
| <systemid> |
| ---- |
| BAR |
| T4 |
| <systemnumber> |
| T4 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| T4_2 |
| <systemnumber> |
| T4_2 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| T8 |
| <systemnumber> |
| <systemname> |
| true |
| BTREE (2) |
| true |
| <systemid> |
| ---- |
| BAR |
| T8 |
| <systemnumber> |
| <systemname> |
| true |
| UNIQUE BTREE (1) |
| true |
| <systemid> |
| ---- |
| BAR |
| T8 |
| <systemnumber> |
| T8 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| tWithKeys |
| <systemnumber> |
| <systemname> |
| true |
| UNIQUE BTREE (1) |
| true |
| <systemid> |
| ---- |
| BAR |
| tWithKeys |
| <systemnumber> |
| IX3 |
| true |
| BTREE (1 DESC) |
| false |
| <systemid> |
| ---- |
| BAR |
| tWithKeys |
| <systemnumber> |
| tWithKeys |
| false |
| null |
| false |
| <systemid> |
| ---- |
| ========== SYSCONSTRAINTS ========== |
| <systemname> |
| T8 |
| <systemname> |
| F |
| BAR |
| E |
| 0 |
| ---- |
| <systemname> |
| T8 |
| <systemname> |
| P |
| BAR |
| E |
| 0 |
| ---- |
| <systemname> |
| tWithKeys |
| <systemname> |
| C |
| BAR |
| E |
| 0 |
| ---- |
| <systemname> |
| tWithKeys |
| <systemname> |
| P |
| BAR |
| E |
| 1 |
| ---- |
| NOTEVIL |
| tWithKeys |
| NOTEVIL |
| C |
| BAR |
| E |
| 0 |
| ---- |
| UNQ |
| T1 |
| UNQ |
| U |
| BAR |
| E |
| 0 |
| ---- |
| ========== SYSDEPENDS ========== |
| <systemname> |
| <Constraint>BAR.<sysname> -> <Constraint>BAR.<sysname> |
| Constraint |
| <systemname> |
| Constraint |
| ---- |
| <systemid> |
| <StoredPreparedStatement>BAR.<sysname> -> <Table>BAR.T8 |
| StoredPreparedStatement |
| T8 |
| Table |
| ---- |
| <systemid> |
| <Trigger>BAR.REFTRIG -> <StoredPreparedStatement>BAR.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| <systemid> |
| <Trigger>BAR.REFTRIG -> <Table>BAR.T8 |
| Trigger |
| T8 |
| Table |
| ---- |
| ========== SYSFILES ========== |
| ========== SYSFOREIGNKEYS ========== |
| <systemname> |
| <systemid> |
| <systemname> |
| U |
| R |
| ---- |
| ========== SYSKEYS ========== |
| <systemname> |
| <systemid> |
| ---- |
| <systemname> |
| <systemid> |
| ---- |
| UNQ |
| <systemid> |
| ---- |
| ========== SYSSCHEMAS ========== |
| APP |
| APP |
| APP |
| ---- |
| BAR |
| BAR |
| APP |
| ---- |
| ========== SYSSTATEMENTS ========== |
| <systemid> |
| <systemname> |
| BAR |
| T |
| <validityflag> |
| select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLDTABLE |
| <systemid> |
| APP |
| null |
| ---- |
| ========== SYSTABLES ========== |
| MULTI WORD NAME |
| MULTI WORD NAME |
| T |
| BAR |
| R |
| ---- |
| SYNONYM2 |
| SYNONYM2 |
| A |
| BAR |
| R |
| ---- |
| SYNONYM3 |
| SYNONYM3 |
| A |
| BAR |
| R |
| ---- |
| T1 |
| T1 |
| T |
| BAR |
| R |
| ---- |
| T3 |
| T3 |
| T |
| BAR |
| R |
| ---- |
| T3_2 |
| T3_2 |
| T |
| BAR |
| R |
| ---- |
| T4 |
| T4 |
| T |
| BAR |
| R |
| ---- |
| T4_2 |
| T4_2 |
| T |
| BAR |
| R |
| ---- |
| T8 |
| T8 |
| T |
| BAR |
| R |
| ---- |
| tWithKeys |
| tWithKeys |
| T |
| BAR |
| R |
| ---- |
| ========== SYSTRIGGERS ========== |
| <systemid> |
| REFTRIG |
| BAR |
| <systemid> |
| D |
| A |
| S |
| E |
| T8 |
| null |
| <systemid> |
| null |
| select * from oldtable |
| true |
| false |
| OLDTABLE |
| null |
| null |
| ---- |
| ========== SYSVIEWS ========== |
| ========== SYSROLES ========== |
| "eve" |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| "eve" |
| B |
| APP |
| N |
| N |
| ---- |
| A |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| A |
| B |
| APP |
| N |
| N |
| ---- |
| B |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| B |
| WHOMEVER |
| APP |
| N |
| N |
| ---- |
| Database 'wombat_new' deleted. |
| -- |
| ******************************************* |
| Dumping DDL for all objects with schema 'BAR' |
| that are related to tables 'T3', 'tWithKeys', |
| and 'MULTI WORD NAME': |
| ******************************************* |
| File dblook.log was empty. |
| Creating database 'wombat_new' from ddl script 'wombat.sql' |
| Dumping system tables for 'wombat_new' |
| ----------------=================--------------- |
| System Tables for: wombat_new |
| ----------------=================--------------- |
| ========== SYSALIASES ========== |
| <systemid> |
| SYNONYM2 |
| BAR |
| null |
| S |
| S |
| false |
| "BAR"."MULTI WORD NAME" |
| <systemname> |
| ---- |
| <systemid> |
| SYNONYM3 |
| BAR |
| null |
| S |
| S |
| false |
| "APP"."T11" |
| <systemname> |
| ---- |
| ========== SYSCHECKS ========== |
| <systemname> |
| (i > 0) |
| (2) |
| ---- |
| NOTEVIL |
| (vc != 'evil') |
| (3) |
| ---- |
| ========== SYSCOLUMNS ========== |
| --- Columns for Tables --- |
| MULTI WORD NAME |
| C |
| 1 |
| CHAR(2) |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T3 |
| B |
| 2 |
| BLOB(20) |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T3 |
| ID |
| 3 |
| INTEGER NOT NULL |
| null |
| null |
| <autoincval> |
| 2 |
| 4 |
| ---- |
| T3 |
| P1 |
| 1 |
| VARCHAR(10) |
| 'okie' |
| <systemid> |
| <autoincval> |
| null |
| null |
| ---- |
| tWithKeys |
| C |
| 1 |
| CHAR(5) NOT NULL |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| tWithKeys |
| I |
| 2 |
| INTEGER |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| tWithKeys |
| VC |
| 3 |
| VARCHAR(10) |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| --- Columns for Statements --- |
| ========== SYSCONGLOMERATES ========== |
| BAR |
| MULTI WORD NAME |
| <systemnumber> |
| MULTI WORD NAME |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| T3 |
| <systemnumber> |
| IX2 |
| true |
| BTREE (1 DESC, 3 DESC) |
| false |
| <systemid> |
| ---- |
| BAR |
| T3 |
| <systemnumber> |
| T3 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| tWithKeys |
| <systemnumber> |
| <systemname> |
| true |
| UNIQUE BTREE (1) |
| true |
| <systemid> |
| ---- |
| BAR |
| tWithKeys |
| <systemnumber> |
| IX3 |
| true |
| BTREE (1 DESC) |
| false |
| <systemid> |
| ---- |
| BAR |
| tWithKeys |
| <systemnumber> |
| tWithKeys |
| false |
| null |
| false |
| <systemid> |
| ---- |
| ========== SYSCONSTRAINTS ========== |
| <systemname> |
| tWithKeys |
| <systemname> |
| C |
| BAR |
| E |
| 0 |
| ---- |
| <systemname> |
| tWithKeys |
| <systemname> |
| P |
| BAR |
| E |
| 0 |
| ---- |
| NOTEVIL |
| tWithKeys |
| NOTEVIL |
| C |
| BAR |
| E |
| 0 |
| ---- |
| ========== SYSDEPENDS ========== |
| ========== SYSFILES ========== |
| ========== SYSFOREIGNKEYS ========== |
| ========== SYSKEYS ========== |
| <systemname> |
| <systemid> |
| ---- |
| ========== SYSSCHEMAS ========== |
| APP |
| APP |
| APP |
| ---- |
| BAR |
| BAR |
| APP |
| ---- |
| ========== SYSSTATEMENTS ========== |
| ========== SYSTABLES ========== |
| MULTI WORD NAME |
| MULTI WORD NAME |
| T |
| BAR |
| R |
| ---- |
| SYNONYM2 |
| SYNONYM2 |
| A |
| BAR |
| R |
| ---- |
| SYNONYM3 |
| SYNONYM3 |
| A |
| BAR |
| R |
| ---- |
| T3 |
| T3 |
| T |
| BAR |
| R |
| ---- |
| tWithKeys |
| tWithKeys |
| T |
| BAR |
| R |
| ---- |
| ========== SYSTRIGGERS ========== |
| ========== SYSVIEWS ========== |
| ========== SYSROLES ========== |
| "eve" |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| "eve" |
| B |
| APP |
| N |
| N |
| ---- |
| A |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| A |
| B |
| APP |
| N |
| N |
| ---- |
| B |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| B |
| WHOMEVER |
| APP |
| N |
| N |
| ---- |
| Database 'wombat_new' deleted. |
| -- |
| ******************************************* |
| Dumping DDL for all objects related to 'T1' |
| and 'TWITHKEYS': |
| ******************************************* |
| File dblook.log was empty. |
| Creating database 'wombat_new' from ddl script 'wombat.sql' |
| FAILED: to execute cmd from DDL script: |
| create view v1 (dum, dee, dokie) as select a.d, a.c, b.p1 from t1 as a, bar.t3 as b |
| Table/View 'BAR.T3' does not exist. |
| FAILED: to execute cmd from DDL script: |
| GRANT SELECT("'Single' and ""double"" quoted column name") ON "'Single' and ""double"" quoted schema name"."'Single' and ""double"" quoted table name" TO "SOMEONE" |
| Schema ''Single' and "double" quoted schema name' does not exist |
| Dumping system tables for 'wombat_new' |
| ----------------=================--------------- |
| System Tables for: wombat_new |
| ----------------=================--------------- |
| ========== SYSALIASES ========== |
| <systemid> |
| SYNONYM1 |
| APP |
| null |
| S |
| S |
| false |
| "APP"."T1" |
| <systemname> |
| ---- |
| <systemid> |
| SYNONYM2 |
| BAR |
| null |
| S |
| S |
| false |
| "BAR"."MULTI WORD NAME" |
| <systemname> |
| ---- |
| <systemid> |
| SYNONYM3 |
| BAR |
| null |
| S |
| S |
| false |
| "APP"."T11" |
| <systemname> |
| ---- |
| ========== SYSCHECKS ========== |
| ========== SYSCOLUMNS ========== |
| --- Columns for Tables --- |
| T1 |
| C |
| 2 |
| CHAR(8) |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T1 |
| C |
| 2 |
| CLOB(15) |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T1 |
| D |
| 3 |
| DATE |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T1 |
| F |
| 4 |
| DOUBLE NOT NULL |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T1 |
| I |
| 1 |
| INTEGER |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| T1 |
| P1 |
| 1 |
| VARCHAR(10) NOT NULL |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| V2 |
| C |
| 2 |
| CLOB(15) |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| V2 |
| P1 |
| 1 |
| VARCHAR(10) NOT NULL |
| null |
| null |
| <autoincval> |
| null |
| null |
| ---- |
| --- Columns for Statements --- |
| ========== SYSCONGLOMERATES ========== |
| APP |
| T1 |
| <systemnumber> |
| IX1 |
| true |
| BTREE (4, 1) |
| false |
| <systemid> |
| ---- |
| APP |
| T1 |
| <systemnumber> |
| T1 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| BAR |
| T1 |
| <systemnumber> |
| <systemname> |
| true |
| UNIQUE BTREE (1) |
| true |
| <systemid> |
| ---- |
| BAR |
| T1 |
| <systemnumber> |
| T1 |
| false |
| null |
| false |
| <systemid> |
| ---- |
| ========== SYSCONSTRAINTS ========== |
| UNQ |
| T1 |
| UNQ |
| U |
| BAR |
| E |
| 0 |
| ---- |
| ========== SYSDEPENDS ========== |
| <systemid> |
| <StoredPreparedStatement>Foo Bar.<sysname> -> <Table>BAR.T1 |
| StoredPreparedStatement |
| T1 |
| Table |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGWHEN -> <Table>APP.T1 |
| Trigger |
| 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 |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <Table>APP.T1 |
| StoredPreparedStatement |
| T1 |
| Table |
| ---- |
| <systemid> |
| <StoredPreparedStatement>APP.<sysname> -> <Table>APP.T1 |
| StoredPreparedStatement |
| T1 |
| Table |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGWHEN -> <StoredPreparedStatement>APP.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| <systemid> |
| <Trigger>APP.TRIGWHEN -> <StoredPreparedStatement>APP.<sysname> |
| Trigger |
| <systemid> |
| StoredPreparedStatement |
| ---- |
| ========== SYSFILES ========== |
| ========== SYSFOREIGNKEYS ========== |
| ========== SYSKEYS ========== |
| UNQ |
| <systemid> |
| ---- |
| ========== SYSSCHEMAS ========== |
| APP |
| APP |
| APP |
| ---- |
| BAR |
| BAR |
| APP |
| ---- |
| Foo Bar |
| Foo Bar |
| APP |
| ---- |
| ========== SYSSTATEMENTS ========== |
| <systemid> |
| <systemid> |
| APP |
| T |
| <validityflag> |
| VALUES exists (select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLD where i > 4) |
| <systemid> |
| APP |
| null |
| ---- |
| <systemid> |
| <systemname> |
| APP |
| T |
| <validityflag> |
| values 1 |
| <systemid> |
| APP |
| null |
| ---- |
| <systemid> |
| <systemname> |
| Foo Bar |
| T |
| <validityflag> |
| values (1), (2) |
| <systemid> |
| APP |
| null |
| ---- |
| ========== SYSTABLES ========== |
| SYNONYM1 |
| SYNONYM1 |
| A |
| APP |
| R |
| ---- |
| SYNONYM2 |
| SYNONYM2 |
| A |
| BAR |
| R |
| ---- |
| SYNONYM3 |
| SYNONYM3 |
| A |
| BAR |
| R |
| ---- |
| T1 |
| T1 |
| T |
| APP |
| R |
| ---- |
| T1 |
| T1 |
| T |
| BAR |
| R |
| ---- |
| V2 |
| V2 |
| V |
| APP |
| R |
| ---- |
| ========== SYSTRIGGERS ========== |
| <systemid> |
| TRIG2 |
| Foo Bar |
| <systemid> |
| D |
| B |
| S |
| E |
| T1 |
| null |
| <systemid> |
| null |
| values (1), (2) |
| false |
| false |
| null |
| null |
| null |
| ---- |
| <systemid> |
| TRIGWHEN |
| APP |
| <systemid> |
| U |
| A |
| S |
| E |
| T1 |
| <systemid> |
| <systemid> |
| null |
| values 1 |
| true |
| false |
| OLD |
| null |
| exists (select * from old where i > 4) |
| ---- |
| ========== SYSVIEWS ========== |
| V2 |
| create view v2 as select * from bar.t1 |
| N |
| APP |
| ---- |
| ========== SYSROLES ========== |
| "eve" |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| "eve" |
| B |
| APP |
| N |
| N |
| ---- |
| A |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| A |
| B |
| APP |
| N |
| N |
| ---- |
| B |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| B |
| WHOMEVER |
| APP |
| N |
| N |
| ---- |
| Database 'wombat_new' deleted. |
| -- |
| ******************************************* |
| 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 |
| null |
| ---- |
| ========== SYSVIEWS ========== |
| ========== SYSROLES ========== |
| "eve" |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| "eve" |
| B |
| APP |
| N |
| N |
| ---- |
| A |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| A |
| B |
| APP |
| N |
| N |
| ---- |
| B |
| APP |
| _SYSTEM |
| Y |
| Y |
| ---- |
| B |
| WHOMEVER |
| APP |
| N |
| N |
| ---- |
| Database 'wombat_new' deleted. |
| -- |
| ******************************************* |
| Dumping DDL w/ invalid url, and writing |
| error to the log: |
| ******************************************* |
| File dblook.log was NOT empty. Contents are: |
| ############## Begin File Contents ################ |
| java.sql.SQLException: No suitable driver |
| -- **--> DEBUG: No suitable driver |
| ############## End File Contents ################ |
| Creating database 'wombat_new' from ddl script 'wombat.sql' |
| Dumping system tables for 'wombat_new' |
| ----------------=================--------------- |
| System Tables for: wombat_new |
| ----------------=================--------------- |
| ========== SYSALIASES ========== |
| ========== SYSCHECKS ========== |
| ========== SYSCOLUMNS ========== |
| --- Columns for Tables --- |
| --- Columns for Statements --- |
| ========== SYSCONGLOMERATES ========== |
| ========== SYSCONSTRAINTS ========== |
| ========== SYSDEPENDS ========== |
| ========== SYSFILES ========== |
| ========== SYSFOREIGNKEYS ========== |
| ========== SYSKEYS ========== |
| ========== SYSSCHEMAS ========== |
| APP |
| APP |
| APP |
| ---- |
| ========== SYSSTATEMENTS ========== |
| ========== SYSTABLES ========== |
| ========== SYSTRIGGERS ========== |
| ========== SYSVIEWS ========== |
| ========== SYSROLES ========== |
| 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 sequences |
| -- ---------------------------------------------- |
| CREATE SEQUENCE "APP"."SEQUENCE_1" |
| AS INTEGER |
| START WITH -2147483648 |
| INCREMENT BY 1 |
| MAXVALUE 2147483647 |
| MINVALUE -2147483648 |
| NO CYCLE |
| -- ---------------------------------------------- |
| -- 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 user defined types |
| -- ---------------------------------------------- |
| CREATE TYPE "APP"."PRICE" EXTERNAL NAME 'org.apache.derbyTesting.functionTests.tests.lang.Price' LANGUAGE JAVA |
| -- ---------------------------------------------- |
| -- DDL Statements for stored procedures |
| -- ---------------------------------------------- |
| CREATE PROCEDURE "APP"."PROC1" (INOUT "A" CHAR(10),IN "B" INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL DYNAMIC RESULT SETS 4 EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.inoutparams3' |
| -- ---------------------------------------------- |
| -- DDL Statements for functions |
| -- ---------------------------------------------- |
| CREATE FUNCTION "APP"."GATP" ("SCH" VARCHAR(128),"TBL" VARCHAR(128)) RETURNS VARCHAR(1000) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL CALLED ON NULL INPUT EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestPropertyInfo.getAllTableProperties' |
| -- ---------------------------------------------- |
| -- DDL Statements for aggregates |
| -- ---------------------------------------------- |
| CREATE DERBY AGGREGATE "APP"."MODE" FOR INTEGER RETURNS INTEGER EXTERNAL NAME 'foo.bar.Wibble' |
| CREATE DERBY AGGREGATE "APP"."MODE2" FOR BIGINT RETURNS DOUBLE EXTERNAL NAME 'foo.bar.Wibble' |
| -- ---------------------------------------------- |
| -- DDL Statements for tables |
| -- ---------------------------------------------- |
| CREATE TABLE "BAR"."T1" ("C" CHAR(5) NOT NULL, "I" INTEGER, "VC" VARCHAR(10), "FKCHAR" CHAR(5)) |
| -- ---------------------------------------------- |
| -- DDL Statements for indexes |
| -- ---------------------------------------------- |
| CREATE INDEX "BAR"."IX1" ON "BAR"."T1" ("I" DESC) |
| -- ---------------------------------------------- |
| -- DDL Statements for Synonyms |
| -- ---------------------------------------------- |
| CREATE SYNONYM "APP"."SYN1" FOR "BAR"."T1" |
| -- ---------------------------------------------- |
| -- DDL Statements for keys |
| -- ---------------------------------------------- |
| -- PRIMARY/UNIQUE |
| ALTER TABLE "BAR"."T1" ADD CONSTRAINT "xxxxGENERATED-IDxxxx" PRIMARY KEY ("C") |
| -- FOREIGN |
| ALTER TABLE "BAR"."T1" ADD CONSTRAINT "xxxxGENERATED-IDxxxx" FOREIGN KEY ("FKCHAR") REFERENCES "BAR"."T1" ("C") ON DELETE NO ACTION ON UPDATE NO ACTION |
| -- ---------------------------------------------- |
| -- DDL Statements for checks |
| -- ---------------------------------------------- |
| ALTER TABLE "BAR"."T1" ADD CONSTRAINT "NOTEVIL" CHECK (vc != 'evil') |
| -- ---------------------------------------------- |
| -- DDL Statements for views |
| -- ---------------------------------------------- |
| SET SCHEMA "APP" |
| create view v1 (dum, dee, dokie) as select a.c, a.i, a.vc from bar.t1 as a |
| -- Reverting back to default schema 'APP' |
| SET SCHEMA "APP" |
| -- ---------------------------------------------- |
| -- DDL Statements for triggers |
| -- ---------------------------------------------- |
| CREATE TRIGGER "APP"."TRIGONE" AFTER INSERT ON "BAR"."T1" FOR EACH ROW update "BAR"."T1" set i = 4 where i = 2 |
| CREATE TRIGGER "APP"."TRIGTWO" AFTER INSERT ON "BAR"."T1" REFERENCING NEW AS NEW FOR EACH ROW WHEN (new.i > 4) delete from "BAR"."T1" 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 sequences |
| -- ---------------------------------------------- |
| CREATE SEQUENCE "APP"."SEQUENCE_1" |
| AS INTEGER |
| START WITH -2147483648 |
| INCREMENT BY 1 |
| MAXVALUE 2147483647 |
| MINVALUE -2147483648 |
| NO CYCLE |
| ; |
| -- ---------------------------------------------- |
| -- 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 <source database url> [options] |
| where the source URL is the full URL, including the connection protocol |
| and any connection attributes that might apply. For example, use |
| 'jdbc:derby:myDB', or 'jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/myDB;user=usr;'. |
| options include: |
| -z <schema name> to specify a schema to which the DDL generation |
| should be limited. Only database objects with that schema will have |
| their DDL generated. |
| -t <table one> <table two> ... 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 sequences |
| -- ---------------------------------------------- |
| CREATE SEQUENCE "APP"."SEQUENCE_1" |
| AS INTEGER |
| START WITH -2147483648 |
| INCREMENT BY 1 |
| MAXVALUE 2147483647 |
| MINVALUE -2147483648 |
| NO CYCLE |
| # |
| -- ---------------------------------------------- |
| -- 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 user defined types |
| -- ---------------------------------------------- |
| CREATE TYPE "APP"."PRICE" EXTERNAL NAME 'org.apache.derbyTesting.functionTests.tests.lang.Price' LANGUAGE JAVA # |
| -- ---------------------------------------------- |
| -- DDL Statements for stored procedures |
| -- ---------------------------------------------- |
| CREATE PROCEDURE "APP"."PROC1" (INOUT "A" CHAR(10),IN "B" INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL DYNAMIC RESULT SETS 4 EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.inoutparams3' # |
| -- ---------------------------------------------- |
| -- DDL Statements for functions |
| -- ---------------------------------------------- |
| CREATE FUNCTION "APP"."GATP" ("SCH" VARCHAR(128),"TBL" VARCHAR(128)) RETURNS VARCHAR(1000) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL CALLED ON NULL INPUT EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestPropertyInfo.getAllTableProperties' # |
| -- ---------------------------------------------- |
| -- DDL Statements for aggregates |
| -- ---------------------------------------------- |
| CREATE DERBY AGGREGATE "APP"."MODE" FOR INTEGER RETURNS INTEGER EXTERNAL NAME 'foo.bar.Wibble' # |
| CREATE DERBY AGGREGATE "APP"."MODE2" FOR BIGINT RETURNS DOUBLE EXTERNAL NAME 'foo.bar.Wibble' # |
| -- ---------------------------------------------- |
| -- DDL Statements for tables |
| -- ---------------------------------------------- |
| CREATE TABLE "BAR"."T1" ("C" CHAR(5) NOT NULL, "I" INTEGER, "VC" VARCHAR(10), "FKCHAR" CHAR(5)) # |
| -- ---------------------------------------------- |
| -- DDL Statements for indexes |
| -- ---------------------------------------------- |
| CREATE INDEX "BAR"."IX1" ON "BAR"."T1" ("I" DESC) # |
| -- ---------------------------------------------- |
| -- DDL Statements for Synonyms |
| -- ---------------------------------------------- |
| CREATE SYNONYM "APP"."SYN1" FOR "BAR"."T1" # |
| -- ---------------------------------------------- |
| -- DDL Statements for keys |
| -- ---------------------------------------------- |
| -- PRIMARY/UNIQUE |
| ALTER TABLE "BAR"."T1" ADD CONSTRAINT "xxxxGENERATED-IDxxxx" PRIMARY KEY ("C") # |
| -- FOREIGN |
| ALTER TABLE "BAR"."T1" ADD CONSTRAINT "xxxxGENERATED-IDxxxx" FOREIGN KEY ("FKCHAR") REFERENCES "BAR"."T1" ("C") ON DELETE NO ACTION ON UPDATE NO ACTION # |
| -- ---------------------------------------------- |
| -- DDL Statements for checks |
| -- ---------------------------------------------- |
| ALTER TABLE "BAR"."T1" ADD CONSTRAINT "NOTEVIL" CHECK (vc != 'evil') # |
| -- ---------------------------------------------- |
| -- DDL Statements for views |
| -- ---------------------------------------------- |
| SET SCHEMA "APP" # |
| create view v1 (dum, dee, dokie) as select a.c, a.i, a.vc from bar.t1 as a # |
| -- Reverting back to default schema 'APP' |
| SET SCHEMA "APP" # |
| -- ---------------------------------------------- |
| -- DDL Statements for triggers |
| -- ---------------------------------------------- |
| CREATE TRIGGER "APP"."TRIGONE" AFTER INSERT ON "BAR"."T1" FOR EACH ROW update "BAR"."T1" set i = 4 where i = 2 # |
| CREATE TRIGGER "APP"."TRIGTWO" AFTER INSERT ON "BAR"."T1" REFERENCING NEW AS NEW FOR EACH ROW WHEN (new.i > 4) delete from "BAR"."T1" 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 ################ |
| -= Start DERBY-6387 test. =- |
| Database 'wombat' deleted. |
| Creating database 'wombat' from ddl script 'dblook_makeDB_derby6387.sql' |
| -- |
| ******************************************* |
| Dumping full schema for 'wombat' |
| to file 'wombat.sql': |
| ******************************************* |
| File dblook.log was empty. |
| 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 tables |
| -- ---------------------------------------------- |
| CREATE TABLE "APP"."T1" ("X" INTEGER) |
| -- ---------------------------------------------- |
| -- DDL Statements for triggers |
| -- ---------------------------------------------- |
| CREATE TRIGGER "APP"."TR13" AFTER UPDATE ON "APP"."T1" REFERENCING NEW_TABLE AS NEW FOR EACH STATEMENT select * from "SYS"."SYSTABLES" natural join "SYS"."SYSSCHEMAS" where exists(select * from new where x > 100) |
| CREATE TRIGGER "APP"."TR14" AFTER UPDATE ON "APP"."T1" REFERENCING NEW_TABLE AS NEW FOR EACH STATEMENT select * from "SYS"."SYSTABLES" natural join "SYS"."SYSSCHEMAS" where exists(select * from new where x > 100) |
| CREATE TRIGGER "APP"."TR15" AFTER UPDATE ON "APP"."T1" REFERENCING NEW_TABLE AS NEW FOR EACH STATEMENT select * from "SYS"."SYSTABLES" natural join "SYS"."SYSSCHEMAS" where exists(select * from new where x > 100) |
| CREATE TRIGGER "APP"."TR16" AFTER UPDATE ON "APP"."T1" REFERENCING NEW_TABLE AS NEW FOR EACH STATEMENT select * from "SYS"."SYSTABLES" natural join "SYS"."SYSSCHEMAS" where exists(select * from new where x > 100) |
| CREATE TRIGGER "APP"."TR17" AFTER UPDATE ON "APP"."T1" REFERENCING NEW_TABLE AS NEW FOR EACH STATEMENT select * from "SYS"."SYSTABLES" natural join "SYS"."SYSSCHEMAS" where exists(select * from new where x > 100) |
| CREATE TRIGGER "APP"."TR18" AFTER UPDATE ON "APP"."T1" REFERENCING NEW_TABLE AS NEW FOR EACH STATEMENT select * from "SYS"."SYSTABLES" natural join "SYS"."SYSSCHEMAS" where exists(select * from new where x > 100) |
| CREATE TRIGGER "APP"."TR19" AFTER UPDATE ON "APP"."T1" REFERENCING NEW_TABLE AS NEW FOR EACH STATEMENT select * from "SYS"."SYSTABLES" natural join "SYS"."SYSSCHEMAS" where exists(select * from new where x > 100) |
| CREATE TRIGGER "APP"."TR20" AFTER UPDATE ON "APP"."T1" REFERENCING NEW_TABLE AS NEW FOR EACH STATEMENT select * from "SYS"."SYSTABLES" natural join "SYS"."SYSSCHEMAS" where exists(select * from new where x > 100) |
| CREATE TRIGGER "APP"."TR21" AFTER UPDATE ON "APP"."T1" REFERENCING NEW_TABLE AS NEW FOR EACH STATEMENT select * from "SYS"."SYSTABLES" natural join "SYS"."SYSSCHEMAS" where exists(select * from new where x > 100) |
| CREATE TRIGGER "APP"."TR22" AFTER UPDATE ON "APP"."T1" REFERENCING NEW_TABLE AS NEW FOR EACH STATEMENT select * from "SYS"."SYSTABLES" natural join "SYS"."SYSSCHEMAS" where exists(select * from new where x > 100) |
| CREATE TRIGGER "APP"."TR23" AFTER UPDATE ON "APP"."T1" REFERENCING NEW_TABLE AS NEW FOR EACH STATEMENT select * from "SYS"."SYSTABLES" natural join "SYS"."SYSSCHEMAS" where exists(select * from new where x > 100) |
| CREATE TRIGGER "APP"."TR24" AFTER UPDATE ON "APP"."T1" REFERENCING NEW_TABLE AS NEW FOR EACH STATEMENT select * from "SYS"."SYSTABLES" natural join "SYS"."SYSSCHEMAS" where exists(select * from new where x > 100) |
| ############## End File Contents ################ |
| [ Done. ] |