FBx64 2.5.4, 2.5.5, SS, SC - в любом. Конфиги "оптимизированные" с сайта
http://ib-aid.com/. Чего ему не хватает? При вызове из приложения ломается на диапазоне дат больше 3-х месяцев. В IBExprt при тех же датах диагностика - Connection will be closed immediately - и отсоединяется. Backup\Restore базы без ошибок.
А вот и Select
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.
SELECT C__.NAME as C_NAME, T__.NAME as S_NAME, D__.ID, D__.NUM, f_DocNum(D__.NUM) as INTNUM,
f_DocNumSuffix( D__.NUM ) as NUMSFX, f_Concat3(C__.NAME, ' ¹ ', D__.NUM_DATE) as OPER_DOC_NAME,
D__.D_DATE, D__.U_FLAG, D__.STATE, D__.A_FLAG, D__.DIRECTION, D__.PROC_DATE, f_Concat3(KC__.NAME, ' ',KD__.NUM_DATE) as KVIT_DOC_NAME, D__.WHOS,
D__.PARAM, D__.KVIT, D__.D_CAT,C__.EDITOR, S__.IS_OUT, D__.LAST_STEP, D__.ERR_CODE, D__.CREATOR,
D__.OPER, D__.SECURITY, C__.SYS_NAME, C__.EDITOR_TYPE as EDO_READY,D__.R_DATE, D__.IMAGEFILE, L__.ID as DOL,CR__.NAME A_NAME,t0.VAL as CONTRACT,PC.NUM_DATE as CONTRACT_NAME, (case when L__.FOOTER > 1 then f_concat3(L__.NUM,' / ',L__.FOOTER) else f_IntToStr(L__.NUM) end) as LINE ,(case when t6.VAL is null then null else f_AsInteger(t6.VAL) end) as PORTFOLIO,F.NAME as INVESTOR,PD.NUM_DATE as PORTFOLIO_NAME,(case when t1.VAL is null then null else f_AsFloat(t1.VAL) end) as SUMMA_OCEN,(case when t2.VAL is null then null else f_AsFloat(t2.VAL) end) as AMOUNT,(case when t3.VAL is null then null else f_AsFloat(t3.VAL) end) as SUMMA,(case when t4.VAL is null then null else f_AsFloat(t4.VAL) end) as PRICE,(case when t5.VAL is null then null else f_AsFloat(t5.VAL) end) as SUMMA_BAL
FROM OD_OPERATORS O__
left join OD_DOC_CATS C__ on C__.WALK>=199 and C__.WALK<200 and f_SetMult(C__.PROFILE, 287552)<>0 and C__.IS_TERM='T'
left join OD_DOCS D__ on D__.D_CAT=C__.ID and D__.WHOS=13911 and D__.D_DATE>='01.09.2015' and D__.D_DATE<'01.01.2016'
left join OD_OPERATORS CR__ on CR__.ID=D__.CREATOR
left join OD_DOCS KD__ on KD__.ID=D__.KVIT
left join OD_DOC_CATS KC__ on KC__.ID=KD__.D_CAT
left join OD_TEMP_RIGHTS S__ on S__.OPER_ID=4
and S__.D_CAT=C__.ID and S__.STATE=D__.STATE and S__.PROFILE=287552
left join OD_DOC_STATES T__ on T__.ID=D__.STATE
left join D_OP_VAL t0 on t0.DESCR=3281 and t0.DOC=D__.ID
left join OD_DOCS PC on PC.ID=f_DocNum(t0.VAL) and f_Substr( ',', t0.VAL)<0 left join OD_DOLS L__ on L__.DOC=D__.ID
left join D_OP_VAL t1 on t1.DESCR=26485 and t1.LINE=L__.ID
left join D_OP_VAL t2 on t2.DESCR=3284 and t2.LINE=L__.ID
left join D_OP_VAL t3 on t3.DESCR=3285 and t3.LINE=L__.ID
left join D_OP_VAL t4 on t4.DESCR=3286 and t4.LINE=L__.ID
left join D_OP_VAL t5 on t5.DESCR=26486 and t5.LINE=L__.ID
left join D_OP_VAL t6 on t6.DESCR=3287 and t6.LINE=L__.ID
left outer join D_B_CONTRACTS C on C.DOC=(case when t6.VAL is null then null else f_AsInteger(t6.VAL) end)
left outer join OD_FACES F on F.SELF_ID=C.INVESTOR and F.LAST_FLAG=1
left outer join OD_DOCS PD on PD.ID=(case when t6.VAL is null then null else f_AsInteger(t6.VAL) end)
WHERE O__.USER_ID=USER
and ( (S__.OK=1 and (D__.SECURITY is null or D__.SECURITY like '%,4,%' or USER like 'SYSDBA%')
and (f_StrLen(O__.USER_CODE)=0 or CR__.USER_CODE=O__.USER_CODE or USER like 'SYSDBA%') )
or (D__.STATE=0 and D__.CREATOR=4)
)
and 0=0
ORDER BY D__.D_DATE DESC,D__.ID DESC, L__.FOOTER, L__.NUM
Database header page information:
Flags 0
Checksum 12345
Generation 1380
Page size 8192
ODS version 11.2
Oldest transaction 1367
Oldest active 1368
Oldest snapshot 1367
Next transaction 1372
Bumped transaction 1
Sequence number 0
Next attachment ID 8
Implementation ID 26
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 14, 2016 13:54:34
Attributes force write
Есть 2 ошибки в gfix -v -f
ACER-I7P (Server) Thu Jan 14 14:39:33 2016
Database: D:\BASES\DKT_DATA.FDB
Relation has 19 orphan backversions (11 in use) in table RDB$RELATIONS (6)
ACER-I7P (Server) Thu Jan 14 14:39:33 2016
Database: D:\BASES\DKT_DATA.FDB
Relation has 2 orphan backversions (412 in use) in table RDB$PROCEDURES (26)
