View Issue Details

IDProjectCategoryView StatusLast Update
0001509Database Comparer VCL[All Projects] Generalpublic2019-04-26 21:49
ReportershirokovAssigned Tobarry 
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version[Database Comparer] 7.0.0.1680 
Target Version[Database Comparer] 7.0.0.1680Fixed in Version[Database Comparer] 7.1.0.1681 
Summary0001509: Cannot compare Firebird 3 databases if there is a statement MERGE SUM() OVER()
DescriptionCannot 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.
TagsNo tags attached.

Activities

shirokov

2019-04-25 18:56

administrator  

dbcCompare.Log (4,416 bytes)

barry

2019-04-26 16:20

administrator   ~0004082

Last edited: 2019-04-26 16:21

View 2 revisions

А можно нормальный скрипт или базу? Какие-то обрывки в логе...

Issue History

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