View Issue Details

IDProjectCategoryView StatusLast Update
0001528Database Comparer VCLGeneralpublic2019-12-12 22:39
Reportershirokov Assigned Tobarry  
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version7.1.0.1681 
Target Version7.1.0.1681Fixed in Version8.0.0.1693.Beta 
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
2019-12-12 22:10 barry Status assigned => acknowledged
2019-12-12 22:39 barry Status acknowledged => resolved
2019-12-12 22:39 barry Resolution open => fixed
2019-12-12 22:39 barry Fixed in Version => 8.0.0.1693.Beta