View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001509 | Database Comparer VCL | General | public | 2019-04-25 18:56 | 2020-02-23 08:01 |
Reporter | shirokov | Assigned To | barry | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 7.0.0.1680 | ||||
Target Version | 7.0.0.1680 | Fixed in Version | 7.1.0.1681 | ||
Summary | 0001509: Cannot compare Firebird 3 databases if there is a statement MERGE SUM() OVER() | ||||
Description | Cannot compare Firebird 3 databases if there is a statement MERGE INTO dgk D USING (SELECT DOK.DOK_ID, DOK.dok_dgk FROM dok WHERE DOK.ifak_id = :i_izvor_id) Source ON (D.DGK_ID = Source.DOK_DGK) WHEN MATCHED THEN DELETE; and also there is an error on statement SUM() OVER (Partition By) The comparing log is attached. | ||||
Tags | No tags attached. | ||||
|
dbcCompare.Log (4,416 bytes)
17.04.2019 21:24:26(I) 17.04.2019 21:24:26 Error: Procedure ACT_INV_PS_PRETHODNA_GODINA: Missing: INTO (<Ident>: PASSWORD) Script: Line:17 Pos:32 17.04.2019 21:24:27(I) 17.04.2019 21:24:27 Linking dependencies... 17.04.2019 21:24:27(I) 17.04.2019 21:24:27 Extracting master database metadata: "localhost/3053:E:\DELPHI\RADNI\PDV2009\PODACI\PDV2019.FDB". 17.04.2019 21:24:27(I) 17.04.2019 21:24:27 !!! < Comparing finished Abnormally... > FOR EXECUTE STATEMENT :SQL AS USER 'SYSDBA' PASSWORD 'masterke' WITH COMMON TRANSACTION WITH CALLER PRIVILEGES ON EXTERNAL :db INTO :MAG_ID, :ROBA_ID, :STANJE, :CIJENA Message: MISSING INTO, MUST BE DO..... ----------------------------------------------------------- FOR EXECUTE STATEMENT (:SQL) (ULAZ_DAT := :VKALK_DOBAVDAT, ULAZ_DOBAV := :KOMIT_OPIS, PLACANJE_ID := :PLACANJE_ID, vkalk_id := :VKALK_ID) AS USER 'SYSDBA' PASSWORD 'masterke' WITH COMMON TRANSACTION WITH CALLER PRIVILEGES ON EXTERNAL :db INTO :ULAZ_ID do SUSPEND; Message: MISSING INTO, MUST BE DO..... ----------------------------------------------------------- EXECUTE STATEMENT (:SQL) (ULAZ_ID := :Ulaz_ID, TARIFA_ID := :TARIFA_ID, REPRO_ID := :ROBA_ID, ULAZS_KOL := SVK_KOL, ULAZS_CIJENA := SVK_FCIJENA, ULAZS_FINULAZ := NULL, ULAZS_POREZ := :SVK_POREZ_I, ULAZS_ULSP := NULL, ULAZS_PROD_CIJENA := :SVK_CIJENA, ULAZS_PROD_VRIJED := SVK_PV, ULAZS_PROD_PDV := NULL) AS USER 'SYSDBA' PASSWORD 'masterke' WITH COMMON TRANSACTION WITH CALLER PRIVILEGES ON EXTERNAL :db; Message: MISSING AS, Missing: (, Missing: SELECT ------------------------------------------------------------ MERGE INTO dgk D USING (SELECT DOK.DOK_ID, DOK.dok_dgk FROM dok WHERE DOK.ifak_id = :i_izvor_id) Source ON (D.DGK_ID = Source.DOK_DGK) WHEN MATCHED THEN DELETE; Message: MISSING SET ------------------------------------------------------------ SELECT S.KONTO_ID, S.KOMIT_ID, COALESCE(Povezano.ios_iznos, 0) AS Duguje, S.SDGK_POT - S.SDGK_DUG AS Potrazuje , (S.SDGK_POT - S.SDGK_DUG) - COALESCE(Povezano.ios_iznos, 0) AS Ostalo , SUM((S.SDGK_POT - S.SDGK_DUG) - COALESCE(Povezano.ios_iznos, 0)) OVER (PARTITION BY S.KOMIT_ID ORDER BY D.DGK_DAT, S.sdgk_id) AS Kumulativ , S.sdgk_id, D.dgk_dat, D.dgk_tipdok, D.dgk_broj, D.dgk_opis, D.DGK_ID, 'D' AS Vrsta FROM SDGK S INNER JOIN DGK D On (D.dgk_id = S.dgk_id) INNER JOIN KOMIT K ON (K.dob_konto_id = S.konto_id and S.komit_id = K.komit_id) -- dob_konto_id LEFT JOIN (select I.ios_po_cemu, Sum(I.ios_iznos) AS ios_iznos From IOS I GROUP BY I.ios_po_cemu) AS Povezano ON Povezano.ios_po_cemu = S.sdgk_id Where S.SDGK_POT - S.SDGK_DUG > 0 and ((S.KOMIT_ID = :i_komit_id) or (:i_komit_id = -1)) AND (S.SDGK_POT - S.SDGK_DUG) - COALESCE(Povezano.ios_iznos, 0) <> 0 Message: Missing: FROM, Missing INTO, MUST BE DO ------------------------------------------------------------- For Select P.STOPA, SUM(P.STOPA) OVER (PARTITION BY P.TB) USTOPA From p_por_stopa_det(:vkalk_dat) P Where P.tb = :tarifa_id Into :stopa, :ustopa do Message: MISSING FROM, INTO, MUST BE DO ------------------------------------------------------------- SQL = 'SELECT KONTO_ID, KONTO_OPIS, KONTO_PS, KONTO_DEVIZNI, KONTO_ANALITIKA, KONTO_MT, KONTO_VT, KONTO_SUBANALITIKA, KONTO_VANBILANS FROM KONTO WHERE StrLen(KONTO_ID) = 1'; FOR EXECUTE STATEMENT :SQL ON EXTERNAL :DB AS USER CURRENT_USER PASSWORD 'masterkey' WITH AUTONOMOUS TRANSACTION INTO :KONTO_ID, :KONTO_OPIS, :KONTO_PS, :KONTO_DEVIZNI, :KONTO_ANALITIKA, :KONTO_MT, :KONTO_VT, :KONTO_SUBANALITIKA, :KONTO_VANBILANS DO BEGIN Message: MISSING INTO, MUST BE DO ------------------------------------------------------------- SQL = 'SELECT R.REPORT_ID, R.REPORT_NAME, R.REPORT_PATH, R.COMPONENTS_LEFT, R.REPORT_TITLE, R.MASTER_DATASET, R.REDOSLED, R.GRUPA, R.QUERY, R.REFRESH_DATASET FROM REPORT R'; FOR EXECUTE STATEMENT :SQL ON EXTERNAL :DB AS USER CURRENT_USER PASSWORD 'masterkey' WITH AUTONOMOUS TRANSACTION INTO :REPORT_ID, :REPORT_NAME, :REPORT_PATH, :COMPONENTS_LEFT, :REPORT_TITLE, :MASTER_DATASET, :REDOSLED, :GRUPA, :QUERY, :REFRESH_DATASET DO BEGIN Message: MISSING INTO, MUST BE DO |
|
А можно нормальный скрипт или базу? Какие-то обрывки в логе... |
Date Modified | Username | Field | Change |
---|---|---|---|
2019-04-25 18:56 | shirokov | New Issue | |
2019-04-25 18:56 | shirokov | Status | new => assigned |
2019-04-25 18:56 | shirokov | Assigned To | => barry |
2019-04-25 18:56 | shirokov | File Added: dbcCompare.Log | |
2019-04-26 16:20 | barry | Note Added: 0004082 | |
2019-04-26 16:21 | barry | Note Edited: 0004082 | View Revisions |
2019-04-26 21:49 | barry | Status | assigned => resolved |
2019-04-26 21:49 | barry | Resolution | open => fixed |
2019-04-26 21:49 | barry | Fixed in Version | => 7.1.0.1681 |
2020-02-23 08:01 | barry | Status | resolved => closed |