feat(需求增加): 高级查询增加了相关证件查询

luoyb

2021-04-23 860514b61a0edc0bc38b1b2e8d6f59c5a5aeba26

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
H:2,block:4,blockSize:1000,chunk:c,clean:1,created:1770a3e2d8b,format:1,version:c,fletcher:cc3e429f
H:2,block:4,blockSize:1000,chunk:c,clean:1,created:1770a3e2d8b,format:1,version:c,fletcher:cc3e429f
chunk:9,block:2,len:1,map:a,max:b00,next:3,pages:2,root:2400001d292,time:10aba3b,version:9,pinCount:0                                                                                    
#
1234567    
! &XSET CREATE_BUILD 200" " 2CREATE USER IF NOT EXISTS "" SALT '' HASH '' ADMIN#   ¥CREATE CACHED TABLE "PUBLIC"."TXC_UNDO_LOG"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQUENCE_1B510E9B_97AB_41E4_AF14_ECFFA6169B35" NOT NULL NULL_TO_DEFAULT SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_1B510E9B_97AB_41E4_AF14_ECFFA6169B35",
    "UNIT_ID" VARCHAR(32) NOT NULL,
    "GROUP_ID" VARCHAR(64) NOT NULL,
    "SQL_TYPE" INT NOT NULL,
    "ROLLBACK_INFO" BLOB NOT NULL,
    "CREATE_TIME" CHAR(23) NOT NULL
)$ # mCREATE SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_1B510E9B_97AB_41E4_AF14_ECFFA6169B35" START WITH 1 BELONGS_TO_TABLE% ! LCREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_B" ON "PUBLIC"."TXC_UNDO_LOG"("ID")& % {ALTER TABLE "PUBLIC"."TXC_UNDO_LOG" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_B" PRIMARY KEY("ID") INDEX "PUBLIC"."PRIMARY_KEY_B"'   åCREATE CACHED TABLE "PUBLIC"."TXLCN_LOG"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQUENCE_81B1AEC0_6C3F_4A81_B350_5A31B02CEA76" NOT NULL NULL_TO_DEFAULT SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_81B1AEC0_6C3F_4A81_B350_5A31B02CEA76",
    "UNIT_ID" VARCHAR(32) NOT NULL,
    "GROUP_ID" VARCHAR(64) NOT NULL,
    "METHOD_STR" VARCHAR(512) NOT NULL,
    "BYTES" BLOB NOT NULL,
    "GROUP_ID_HASH" BIGINT NOT NULL,
    "UNIT_ID_HASH" BIGINT NOT NULL,
    "TIME" BIGINT NOT NULL
)( # mCREATE SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_81B1AEC0_6C3F_4A81_B350_5A31B02CEA76" START WITH 1 BELONGS_TO_TABLE) ! ICREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_8" ON "PUBLIC"."TXLCN_LOG"("ID")* % xALTER TABLE "PUBLIC"."TXLCN_LOG" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_8" PRIMARY KEY("ID") INDEX "PUBLIC"."PRIMARY_KEY_8"ºùchunk.7chunk.8map.1map.3map.4map.5map.6map.7map.8map.aname.lobDataname.lobMapname.lobRefname.openTransactionsname.table.0name.table.3name.table.7name.undoLog.1root.3œ
chunk:7,block:5,len:1,liveMax:0,livePages:0,map:9,max:c00,next:6,pages:2,root:1c00001d294,time:1098566,unused:10aba3b,unusedAtVersion:8,version:7,pinCount:0œ
chunk:8,block:6,len:1,liveMax:0,livePages:0,map:a,max:400,next:7,pages:1,root:20000002e94,time:10ab9f9,unused:10aba3b,unusedAtVersion:8,version:8,pinCount:0name:openTransactionsname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:2name:table.7,createVersion:3name:undoLog.1,createVersion:7
6
4
5
1
3
7
8
a24000002e98chunk:9,block:2,version:9,fletcher:dcd0e5f6                                                                                    
chunk:b,block:3,len:1,map:a,max:400,next:6,pages:1,root:2c000002e94,time:10aba40,version:b,pinCount:0                                                                                    
Eôchunk.8chunk.9chunk.amap.1map.3map.4map.5map.6map.7map.8map.aname.lobDataname.lobMapname.lobRefname.openTransactionsname.table.0name.table.3name.table.7name.undoLog.1root.3•
chunk:8,block:4,len:1,liveMax:0,livePages:0,map:a,max:400,pages:1,root:20000002e94,time:10ab9f9,unused:10aba3b,unusedAtVersion:8,version:8,pinCount:0
chunk:9,block:2,len:1,liveMax:800,livePages:1,map:a,max:b00,next:3,pages:2,root:2400001d292,time:10aba3b,unusedAtVersion:9,version:9,pinCount:0•
chunk:a,block:5,len:1,liveMax:0,livePages:0,map:a,max:400,pages:1,root:28000002e94,time:10aba3f,unused:10aba40,unusedAtVersion:a,version:a,pinCount:0name:openTransactionsname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:2name:table.7,createVersion:3name:undoLog.1,createVersion:7
6
4
5
1
3
7
8
a24000002e98onsname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:2name:table.7,createVersion:3name:undoLog.1,createVersion:7
6
4
5
1
3
7
8
a1c000002e98chunk:b,block:3,version:b,fletcher:a5d238f7                                                                                    
chunk:c,block:4,len:1,map:a,max:c00,next:6,pages:2,root:3000001d294,time:10adec0,version:c,pinCount:0                                                                                    
&
1234567    
! &XSET CREATE_BUILD 200" " 2CREATE USER IF NOT EXISTS "" SALT '' HASH '' ADMIN#   ¥CREATE CACHED TABLE "PUBLIC"."TXC_UNDO_LOG"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQUENCE_1B510E9B_97AB_41E4_AF14_ECFFA6169B35" NOT NULL NULL_TO_DEFAULT SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_1B510E9B_97AB_41E4_AF14_ECFFA6169B35",
    "UNIT_ID" VARCHAR(32) NOT NULL,
    "GROUP_ID" VARCHAR(64) NOT NULL,
    "SQL_TYPE" INT NOT NULL,
    "ROLLBACK_INFO" BLOB NOT NULL,
    "CREATE_TIME" CHAR(23) NOT NULL
)$ # mCREATE SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_1B510E9B_97AB_41E4_AF14_ECFFA6169B35" START WITH 1 BELONGS_TO_TABLE% ! LCREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_B" ON "PUBLIC"."TXC_UNDO_LOG"("ID")& % {ALTER TABLE "PUBLIC"."TXC_UNDO_LOG" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_B" PRIMARY KEY("ID") INDEX "PUBLIC"."PRIMARY_KEY_B"'   åCREATE CACHED TABLE "PUBLIC"."TXLCN_LOG"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQUENCE_81B1AEC0_6C3F_4A81_B350_5A31B02CEA76" NOT NULL NULL_TO_DEFAULT SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_81B1AEC0_6C3F_4A81_B350_5A31B02CEA76",
    "UNIT_ID" VARCHAR(32) NOT NULL,
    "GROUP_ID" VARCHAR(64) NOT NULL,
    "METHOD_STR" VARCHAR(512) NOT NULL,
    "BYTES" BLOB NOT NULL,
    "GROUP_ID_HASH" BIGINT NOT NULL,
    "UNIT_ID_HASH" BIGINT NOT NULL,
    "TIME" BIGINT NOT NULL
)( # mCREATE SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_81B1AEC0_6C3F_4A81_B350_5A31B02CEA76" START WITH 1 BELONGS_TO_TABLE) ! ICREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_8" ON "PUBLIC"."TXLCN_LOG"("ID")* % xALTER TABLE "PUBLIC"."TXLCN_LOG" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_8" PRIMARY KEY("ID") INDEX "PUBLIC"."PRIMARY_KEY_8"Ychunk.9chunk.achunk.bmap.1map.3map.4map.5map.6map.7map.8map.aname.lobDataname.lobMapname.lobRefname.openTransactionsname.table.0name.table.3name.table.7name.undoLog.1root.3œ
chunk:9,block:2,len:1,liveMax:0,livePages:0,map:a,max:b00,next:3,pages:2,root:2400001d292,time:10aba3b,unused:10adec0,unusedAtVersion:b,version:9,pinCount:0•
chunk:a,block:5,len:1,liveMax:0,livePages:0,map:a,max:400,pages:1,root:28000002e94,time:10aba3f,unused:10aba40,unusedAtVersion:a,version:a,pinCount:0œ
chunk:b,block:3,len:1,liveMax:0,livePages:0,map:a,max:400,next:6,pages:1,root:2c000002e94,time:10aba40,unused:10adec0,unusedAtVersion:b,version:b,pinCount:0name:openTransactionsname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:2name:table.7,createVersion:3name:undoLog.1,createVersion:7
6
4
5
1
3
7
8
a30000002e98chunk:c,block:4,version:c,fletcher:b6d23bf7                                                                                    
chunk:a,block:5,len:1,map:a,max:400,pages:1,root:28000002e94,time:10aba3f,version:a,pinCount:0                                                                                           
Eõchunk.7chunk.8chunk.9map.1map.3map.4map.5map.6map.7map.8map.aname.lobDataname.lobMapname.lobRefname.openTransactionsname.table.0name.table.3name.table.7name.undoLog.1root.3•
chunk:7,block:3,len:1,liveMax:0,livePages:0,map:9,max:c00,pages:2,root:1c00001d294,time:1098566,unused:10aba3b,unusedAtVersion:8,version:7,pinCount:0•
chunk:8,block:4,len:1,liveMax:0,livePages:0,map:a,max:400,pages:1,root:20000002e94,time:10ab9f9,unused:10aba3b,unusedAtVersion:8,version:8,pinCount:0
chunk:9,block:2,len:1,liveMax:800,livePages:1,map:a,max:b00,next:3,pages:2,root:2400001d292,time:10aba3b,unusedAtVersion:9,version:9,pinCount:0name:openTransactionsname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:2name:table.7,createVersion:3name:undoLog.1,createVersion:7
6
4
5
1
3
7
8
a24000002e98onsname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:2name:table.7,createVersion:3name:undoLog.1,createVersion:7
6
4
5
1
3
7
8
a1c000002e98chunk:a,block:5,version:a,fletcher:a6d238f7