📄 dblook_test_net.out
字号:
-----= Start dblook (net server) Test. =-Creating database 'wombat' from ddl script 'dblook_makeDB.sql'-----*******************************************Dumping DDL for all objects, usingNetwork Server:*******************************************File dblook.log was empty.Creating database 'wombat_new' from ddl script 'wombat.sql'Dumping system tables for 'wombat_new'-----=================---------------System Tables for: wombat_new-----=================---------------========== SYSALIASES ==========<systemid>"proc "In Quotes with spaces"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>T4falsenull⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -