View Issue Details

IDProjectCategoryView StatusLast Update
0001528Database Comparer VCL[All Projects] Generalpublic2019-06-21 23:44
ReportershirokovAssigned Tobarry 
PrioritynormalSeveritymajorReproducibilityalways
Status assignedResolutionopen 
Product Version[Database Comparer] 7.1.0.1681 
Target Version[Database Comparer] 7.1.0.1681Fixed in Version 
Summary0001528: Missing THEN (AND) when parsing the MERGE INTO statement
DescriptionThe problem is related to the MERGE command
MERGE INTO dgk D
 USING (SELECT DOK.DOK_ID, DOK.dok_dgk FROM dok ) Source
 ON (D.DGK_ID = Source.DOK_DGK)
 WHEN MATCHED *AND Source.DOK_DGK IS NOT NULL* THEN DELETE;

and the reported problem is Missing THEN (AND).

There is a link to download a database that reproduces the problem:
https://www.clevercomponents.com/dev/dbc/support/PDV2019.zip
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-06-21 23:44 shirokov New Issue
2019-06-21 23:44 shirokov Status new => assigned
2019-06-21 23:44 shirokov Assigned To => barry