📄 dblook_test.out

📁 derby database source code.good for you.
💻 OUT
📖 第 1 页 / 共 4 页
字号:
12 3 4 下一页
-= 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"APPorg.apache.derbyTesting.functionTests.util.ProcedureTestPPfalseinoutparams3(INOUT A CHAR(10),IN B INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 2<systemname>----<systemid>GATP2FOOorg.apache.derbyTesting.functionTests.util.TestPropertyInfoFFfalsegetAllTableProperties(SCH VARCHAR(128),TBL VARCHAR(128)) RETURNS VARCHAR(1000) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA RETURNS NULL ON NULL INPUT<systemname>----<systemid>GATPAPPorg.apache.derbyTesting.functionTests.util.TestPropertyInfoFFfalsegetAllTableProperties(SCH VARCHAR(128),TBL VARCHAR(128)) RETURNS VARCHAR(1000) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL CALLED ON NULL INPUT<systemname>----<systemid>OP4BARorg.apache.derbyTesting.functionTests.util.ProcedureTestPPfalseinoutparams4(OUT A DECIMAL(4,2),IN B VARCHAR(255)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA<systemname>----<systemid>PROC1APPorg.apache.derbyTesting.functionTests.util.ProcedureTestPPfalseinoutparams3(INOUT A CHAR(10),IN B INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL DYNAMIC RESULT SETS 4<systemname>----<systemid>PROC2Foo Barorg.apache.derbyTesting.functionTests.util.ProcedureTestPPfalsesqlControl(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA<systemname>----<systemid>SQQLCONTROL_1FOOorg.apache.derbyTesting.functionTests.util.ProcedureTestPPfalsesqlControl(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>SYNONYM1APPnullSSfalse"APP"."T1"<systemname>----<systemid>SYNONYM2BARnullSSfalse"BAR"."MULTI WORD NAME"<systemname>----<systemid>SYNONYM3BARnullSSfalse"APP"."T11"<systemname>----<systemid>procTwoAPPorg.apache.derbyTesting.functionTests.util.ProcedureTestPPfalseinoutparams3(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"iq11INTEGERnullnull<autoincval>nullnull----"tquoteTwo"iq22INTEGERnullnull<autoincval>nullnull----MULTI WORD NAMEC1CHAR(2)nullnull<autoincval>nullnull----REMOVEDX1INTEGERnullnull<autoincval>nullnull----T10K2INTEGER NOT NULLnullnull<autoincval>nullnull----T10UK3CHAR(3) NOT NULLnullnull<autoincval>nullnull----T10VACH1VARCHAR(12)nullnull<autoincval>nullnull----T11LOLA2INTEGERnullnull<autoincval>nullnull----T11MYCHAR1CHAR(8)nullnull<autoincval>nullnull----T1C2CHAR(8)nullnull<autoincval>nullnull----T1C2CLOB(15)nullnull<autoincval>nullnull----T1D3DATEnullnull<autoincval>nullnull----T1F4DOUBLE NOT NULLnullnull<autoincval>nullnull----T1I1INTEGERnullnull<autoincval>nullnull----T1P11VARCHAR(10) NOT NULLnullnull<autoincval>nullnull----T2B2BLOB(20)nullnull<autoincval>nullnull----T2C3CLOB(15)nullnull<autoincval>nullnull----T2P11VARCHAR(10)nullnull<autoincval>nullnull----T3B2BLOB(20)nullnull<autoincval>nullnull----T3ID3INTEGER NOT NULLnullnull<autoincval>24----T3P11VARCHAR(10)'okie'<systemid><autoincval>nullnull----T3_2B2BLOB(20)nullnull<autoincval>nullnull----T3_2ID3INTEGER NOT NULLGENERATED_BY_DEFAULT<systemid><autoincval>24----T3_2P11VARCHAR(10)'okie'<systemid><autoincval>nullnull----T4I1INTEGER2<systemid><autoincval>nullnull----T4J2INTEGER NOT NULLnullnull<autoincval>nullnull----T4K3INTEGER NOT NULLnullnull<autoincval>11----T4_2I1INTEGER2<systemid><autoincval>nullnull----T4_2J2INTEGER NOT NULLnullnull<autoincval>nullnull----T4_2K3INTEGER NOT NULLGENERATED_BY_DEFAULT<systemid><autoincval>11----T5COST1DOUBLEnullnull<autoincval>nullnull----T6LETTER2CHAR(1)nullnull<autoincval>nullnull----T6NUM1INTEGERnullnull<autoincval>nullnull----T7DEUX2INTEGERnullnull<autoincval>nullnull----T7UN1INTEGERnullnull<autoincval>nullnull----T8FKCHAR2CHAR(5)nullnull<autoincval>nullnull----T8SOMEINT1INTEGER NOT NULLnullnull<autoincval>nullnull----T8T1T4C11CHAR(4)'okie'<systemid><autoincval>nullnull----T8T1T4C22CHAR(4)'doki'<systemid><autoincval>nullnull----T9CH2CHAR(8) NOT NULLnullnull<autoincval>nullnull----T9FKINT1INTEGER NOT NULLnullnull<autoincval>nullnull----V"3I1INTEGER NOT NULLnullnull<autoincval>nullnull----V1DEE2CHAR(8)nullnull<autoincval>nullnull----V1DOKIE3VARCHAR(10)nullnull<autoincval>nullnull----V1DOO1INTEGERnullnull<autoincval>nullnull----V1DUM1DATEnullnull<autoincval>nullnull----V1DWA2CHAR(1)nullnull<autoincval>nullnull----V2C2CLOB(15)nullnull<autoincval>nullnull----V2P11VARCHAR(10) NOT NULLnullnull<autoincval>nullnull----XX1INTEGERnullnull<autoincval>nullnull----tWithKeysC1CHAR(5) NOT NULLnullnull<autoincval>nullnull----tWithKeysI2INTEGERnullnull<autoincval>nullnull----tWithKeysVC3VARCHAR(10)nullnull<autoincval>nullnull----tee""HeeN1CHAR(1) NOT NULLnullnull<autoincval>nullnull----tquote"Onei"q11INTEGER NOT NULLnullnull<autoincval>nullnull----tquote"Onei"q22INTEGER8<systemid><autoincval>nullnull----tquoteThree"iq1"1INTEGER NOT NULLnullnull<autoincval>nullnull----tquoteThree"iq2"2INTEGERnullnull<autoincval>nullnull----viewTwoLOLA2INTEGERnullnull<autoincval>nullnull----viewTwoMYCHAR1CHAR(8)nullnull<autoincval>nullnull------- Columns for Statements ---========== SYSCONGLOMERATES =========="Quoted"Schema"tee""Hee<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----"Quoted"Schema"tee""Hee<systemnumber>Ix"5trueBTREE (1 DESC)false<systemid>----"Quoted"Schema"tee""Hee<systemnumber>tee""Heefalsenullfalse<systemid>----APP"tquoteTwo<systemnumber><systemname>trueBTREE (1)true<systemid>----APP"tquoteTwo<systemnumber>"tquoteTwofalsenullfalse<systemid>----APPREMOVED<systemnumber>REMOVEDfalsenullfalse<systemid>----APPT11<systemnumber><systemname>trueBTREE (1, 2)true<systemid>----APPT11<systemnumber>T11falsenullfalse<systemid>----APPT1<systemnumber>IX1trueBTREE (4, 1)false<systemid>----APPT1<systemnumber>T1falsenullfalse<systemid>----APPT2<systemnumber>T2falsenullfalse<systemid>----APPT8T1T4<systemnumber>T8T1T4falsenullfalse<systemid>----APPX<systemnumber>Xfalsenullfalse<systemid>----APPtquote"One<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----APPtquote"One<systemnumber>tquote"Onefalsenullfalse<systemid>----APPtquoteThree"<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----APPtquoteThree"<systemnumber>tquoteThree"falsenullfalse<systemid>----BARMULTI WORD NAME<systemnumber>MULTI WORD NAMEfalsenullfalse<systemid>----BART1<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----BART1<systemnumber>T1falsenullfalse<systemid>----BART3<systemnumber>IX2trueBTREE (1 DESC, 3 DESC)false<systemid>----BART3<systemnumber>T3falsenullfalse<systemid>----BART3_2<systemnumber>T3_2falsenullfalse<systemid>----BART4<systemnumber>IX4trueUNIQUE BTREE (3)false<systemid>----BART4<systemnumber>T4falsenullfalse<systemid>----BART4_2<systemnumber>T4_2falsenullfalse<systemid>----BART8<systemnumber><systemname>trueBTREE (2)true<systemid>----BART8<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----BART8<systemnumber>T8falsenullfalse<systemid>----BARtWithKeys<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----BARtWithKeys<systemnumber>IX3trueBTREE (1 DESC)false<systemid>----BARtWithKeys<systemnumber>tWithKeysfalsenullfalse<systemid>----FOOT10<systemnumber><systemname>trueUNIQUE BTREE (2)true<systemid>----FOOT10<systemnumber><systemname>trueUNIQUE BTREE (3)true<systemid>----FOOT10<systemnumber>T10falsenullfalse<systemid>----FOOT9<systemnumber><systemname>trueBTREE (1)true<systemid>----FOOT9<systemnumber><systemname>trueUNIQUE BTREE (2, 1)true<systemid>----FOOT9<systemnumber>T9falsenullfalse<systemid>----Foo BarT5<systemnumber>CostIndextrueUNIQUE BTREE (1)false<systemid>----Foo BarT5<systemnumber>T5falsenullfalse<systemid>----Foo BarT6<systemnumber>T6falsenullfalse<systemid>----Foo BarT7<systemnumber>T7falsenullfalse<systemid>----========== SYSCONSTRAINTS =========="ck2"tquoteTwo"ck2CAPPE0----"effkay1"tquoteTwo"effkay1FAPPE0----<systemname>T10<systemname>PFOOE1----<systemname>T10<systemname>UFOOE0----<systemname>T8<systemname>FBARE0----<systemname>T8<systemname>PBARE0----<systemname>tWithKeys<systemname>CBARE0----<systemname>tWithKeys<systemname>PBARE1----NOTEVILtWithKeysNOTEVILCBARE0----<systemname>T11<systemname>FAPPE0----UNQT1UNQUBARE0----c"k1tquote"Onec"k1CAPPE0----chkOneT10chkOneCFOOE0----ck2"tquoteThree"ck2"CAPPE0----fkOneT9fkOneFFOOE0----pee"kay1tquote"Onepee"kay1PAPPE1----pkTwoT9pkTwoPFOOE1----<systemname>tee""Hee<systemname>P"Quoted"Schema"E0----unqkay1"tquoteThree"unqkay1"UAPPE0----========== SYSDEPENDS =========="effkay1<Constraint>APP."effkay1 -> <Constraint>APP.pee"kay1Constraintpee"kay1Constraint----<systemname><Constraint>APP.<sysname> -> <Constraint>FOO.pkTwoConstraintpkTwoConstraint----<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""HeeStoredPreparedStatementtee""HeeTable----<systemid><StoredPreparedStatement>APP.<sysname> -> <ColumnsInTable>BAR.T4StoredPreparedStatementT4ColumnsInTable----<systemid><StoredPreparedStatement>APP.<sysname> -> <ColumnsInTable>BAR.tWithKeysStoredPreparedStatementtWithKeysColumnsInTable----<systemid><StoredPreparedStatement>APP.<sysname> -> <Conglomerate>APP.<sysname>StoredPreparedStatement<systemid>Conglomerate----<systemid><StoredPreparedStatement>APP.<sysname> -> <Table>APP.REMOVEDStoredPreparedStatementREMOVEDTable----<systemid><StoredPreparedStatement>APP.<sysname> -> <Table>APP.XStoredPreparedStatementXTable----<systemid><StoredPreparedStatement>APP.<sysname> -> <Table>BAR.T3StoredPreparedStatementT3Table----<systemid><StoredPreparedStatement>APP.<sysname> -> <Table>BAR.tWithKeysStoredPreparedStatementtWithKeysTable----
12 3 4 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -