📄 dblook_test.out

📁 derby database source code.good for you.
💻 OUT
📖 第 1 页 / 共 4 页
字号:
<systemid><StoredPreparedStatement>BAR.<sysname> -> <Table>BAR.T8StoredPreparedStatementT8Table----<systemid><StoredPreparedStatement>Foo Bar.<sysname> -> <Table>BAR.T1StoredPreparedStatementT1Table----<systemid><Trigger>"Quoted"Schema"."trig"One" -> <StoredPreparedStatement>"Quoted"Schema".<sysname>Trigger<systemid>StoredPreparedStatement----<systemid><Trigger>"Quoted"Schema"."trig"One" -> <Table>"Quoted"Schema".tee""HeeTriggertee""HeeTable----<systemid><Trigger>APP.TRIGFOUR -> <StoredPreparedStatement>APP.<sysname>Trigger<systemid>StoredPreparedStatement----<systemid><Trigger>APP.TRIGFOUR -> <Table>APP.XTriggerXTable----<systemid><Trigger>APP.TRIGONE -> <StoredPreparedStatement>APP.<sysname>Trigger<systemid>StoredPreparedStatement----<systemid><Trigger>APP.TRIGONE -> <Table>BAR.T3TriggerT3Table----<systemid><Trigger>APP.TrigThree -> <StoredPreparedStatement>APP.<sysname>Trigger<systemid>StoredPreparedStatement----<systemid><Trigger>APP.TrigThree -> <Table>BAR.tWithKeysTriggertWithKeysTable----<systemid><Trigger>BAR.REFTRIG -> <StoredPreparedStatement>BAR.<sysname>Trigger<systemid>StoredPreparedStatement----<systemid><Trigger>BAR.REFTRIG -> <Table>BAR.T8TriggerT8Table----<systemid><Trigger>Foo Bar.TRIG2 -> <StoredPreparedStatement>Foo Bar.<sysname>Trigger<systemid>StoredPreparedStatement----<systemid><Trigger>Foo Bar.TRIG2 -> <Table>BAR.T1TriggerT1Table----V1<View>APP.V1 -> <ColumnsInTable>APP.T1ViewT1ColumnsInTable----V1<View>APP.V1 -> <ColumnsInTable>BAR.T3ViewT3ColumnsInTable----V2<View>APP.V2 -> <ColumnsInTable>BAR.T1ViewT1ColumnsInTable----viewTwo<View>BAR.viewTwo -> <ColumnsInTable>APP.T11ViewT11ColumnsInTable----V1<View>FOO.V1 -> <ColumnsInTable>Foo Bar.T6ViewT6ColumnsInTable----<systemid><StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.<sysname>StoredPreparedStatement<systemid>Conglomerate----<systemid><StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.<sysname>StoredPreparedStatement<systemid>Conglomerate----========== SYSFILES ==========<systemid>FOOFOOJAR<systemnumber>----========== SYSFOREIGNKEYS ==========<systemname><systemid><systemname>UR----"effkay1<systemid>pee"kay1RR----fkOne<systemid><systemname>RS----<systemname><systemid>pkTwoRR----========== 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----APPAPPAPP----BARBARAPP----FOOFOOAPP----Foo BarFoo BarAPP----========== SYSSTATEMENTS ==========<systemid><systemname>APPT<validityflag>insert into removed select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLD  where x not in (select x from new org.apache.derby.catalog.TriggerNewTransitionRows() NEW  where x < 10)<systemid>APPnull----<systemid><systemname>APPT<validityflag>select c from bar."tWithKeys"<systemid>APPnull----<systemid><systemname>APPT<validityflag>update bar.t4 set j=8 where i=2<systemid>APPnull----<systemid><systemname>"Quoted"Schema"T<validityflag>values(8)<systemid>APPnull----<systemid><systemname>BART<validityflag>select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLDTABLE <systemid>APPnull----<systemid><systemname>Foo BarT<validityflag>values (1), (2)<systemid>APPnull----========== SYSTABLES =========="tquoteTwo"tquoteTwoTAPPR----MULTI WORD NAMEMULTI WORD NAMETBARR----REMOVEDREMOVEDTAPPR----SYNONYM1SYNONYM1AAPPR----SYNONYM2SYNONYM2ABARR----SYNONYM3SYNONYM3ABARR----T10T10TFOOR----T11T11TAPPR----T1T1TAPPR----T1T1TBARR----T2T2TAPPR----T3T3TBARR----T3_2T3_2TBARR----T4T4TBARR----T4_2T4_2TBARR----T5T5TFoo BarR----T6T6TFoo BarR----T7T7TFoo BarR----T8T1T4T8T1T4TAPPR----T8T8TBARR----T9T9TFOOR----V"3V"3VAPPR----V1V1VAPPR----V1V1VFOOR----V2V2VAPPR----XXTAPPR----tWithKeystWithKeysTBARR----tee""Heetee""HeeT"Quoted"Schema"R----tquote"Onetquote"OneTAPPR----tquoteThree"tquoteThree"TAPPR----viewTwoviewTwoVBARR----========== SYSTRIGGERS ==========<systemid>"trig"One""Quoted"Schema"<systemid>IAREtee""Heenull<systemid>nullvalues(8)falsefalsenullnull----<systemid>REFTRIGBAR<systemid>DASET8null<systemid>nullselect * from oldtabletruefalseOLDTABLEnull----<systemid>TRIG2Foo Bar<systemid>DBSET1null<systemid>nullvalues (1), (2)falsefalsenullnull----<systemid>TRIGFOURAPP<systemid>UASEXnull<systemid>(1)insert into removed select * from old where x not in (select x from new where x < 10)truetrueOLDNEW----<systemid>TRIGONEAPP<systemid>IARET3null<systemid>nullupdate bar.t4 set j=8 where i=2falsefalsenullnull----<systemid>TrigThreeAPP<systemid>UAREtWithKeysnull<systemid>(1,2)select c from bar."tWithKeys"falsefalsenullnull----========== SYSVIEWS ==========V"3create view "V""3"(i) as values (8), (28), (78)NAPP----V1create view v1 (dum, dee, dokie) as select a.d, a.c, b.p1 from t1 as a, bar.t3 as bNAPP----V1create view v1 (doo, dwa) as select num, letter from "Foo Bar".t6NFOO----V2create view v2 as select * from bar.t1NAPP----viewTwocreate view bar."viewTwo" as select * from app.t11NAPP------*******************************************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"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"
⌨️ 快捷键说明

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