View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001545 | Database Comparer VCL | General | public | 2019-07-26 10:50 | 2020-02-23 08:01 |
| Reporter | shirokov | Assigned To | barry | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 7.1.0.1686 | ||||
| Target Version | 7.1.0.1686 | ||||
| Summary | 0001545: Problems with updating cross-linked stored procedures. | ||||
| Description | In Procedure "PKTOLISTE" (proc1, see attached file) there is a call to another procedure called "PktoListeSub" (proc2) via execute procedure. The generated update script fails on dropping proc2 because proc1 has dependency to proc2. In version 6.4 the update script has a statement to empty the body of proc1 to resolve dependency . In versoin 7.1. that stetement is missing. See attached SQL scripts. The problem is reproduced in both VCL and standalone edition, 7.1.0.1686. Problem does not occure with version 6.4. The master and target databases are attached, as well. Master has only one procedure. Target has two procs. DBComparer-Tool Log: Updating target database... Charset: NONE Connect: "d:\db\dbcomparer\targetnew.fdb" Dialect: 1. DBCharSet: NONE. < Exec SQL >: PKTOLISTESUB: drop Error: dbcDataMod_1.DBCConnection: This operation is not defined for system tables.Unsuccessful metadata update. Cannot delete. PROCEDURE PKTOLISTESUB. There are 1 dependencies. < Exec SQL >: PKTOLISTE: alter < Script executed: 1 errors... > | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-07-26 10:50 | shirokov | New Issue | |
| 2019-07-26 10:50 | shirokov | Status | new => assigned |
| 2019-07-26 10:50 | shirokov | Assigned To | => barry |
| 2019-07-26 10:50 | shirokov | File Added: cros-linked-procs.zip | |
| 2019-07-29 17:38 | barry | Status | assigned => resolved |
| 2019-07-29 17:38 | barry | Resolution | open => fixed |
| 2019-07-29 17:38 | barry | Note Added: 0004161 | |
| 2020-02-23 08:01 | barry | Status | resolved => closed |
