View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001528 | Database Comparer VCL | General | public | 2019-06-21 23:44 | 2020-02-23 08:00 |
| Reporter | shirokov | Assigned To | barry | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 7.1.0.1681 | ||||
| Target Version | 7.1.0.1681 | Fixed in Version | 8.0.0.1693.Beta | ||
| Summary | 0001528: Missing THEN (AND) when parsing the MERGE INTO statement | ||||
| Description | The 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 | ||||
| Tags | No tags attached. | ||||
| 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 |
| 2020-02-23 08:00 | barry | Status | resolved => closed |
