View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001047 | Database Workbench v5 | Meta Data Compare & Migration | public | 2014-09-28 14:47 | 2014-12-29 10:36 |
| Reporter | Doychin Bondzhev | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | acknowledged | Resolution | open | ||
| Product Version | 5.0.2 | ||||
| Summary | 0001047: Script to crete SP after compare is not properly ordered | ||||
| Description | Now stored procedures are alphabetically ordered in the script. Instead they must be ordered based on the dependency. Also when 2 procedures depend on each other an empty body must be created first for one of the procedures and then altered to contain the actual body after it's dependency is satisfied. | ||||
| Tags | No tags attached. | ||||
|
|
Another example: The generated sql script first alters a stored procedure A such that it references new stored procedure B. But it only creates B later on, so executing the script will fail. Could you change script creation such that new stored procedures are created before existing stored procedures are changed? After having done that manually, I got the next problem: stored procedure B now has a different list of input parameters. But the script tries to alter stored procedure A calling B before altering stored procedure B. So this still fails. |
|
|
Fix: 1) alter both procedures so that there's no implementation 2) alter both procedures to hold the new parameters 3) alter both procedures with source code and new calling sequences |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2014-09-28 14:47 | Doychin Bondzhev | New Issue | |
| 2014-10-01 14:41 | Martijn Tonies | Project | Database Workbench v4 => Database Workbench v5 |
| 2014-10-02 13:31 | Martijn Tonies | Status | new => acknowledged |
| 2014-12-29 10:36 | Martijn Tonies | Note Added: 0000326 | |
| 2014-12-29 10:36 | Martijn Tonies | Note Added: 0000327 | |
| 2015-05-11 11:20 | Martijn Tonies | Category | Compare & Migration => Meta Data Compare & Migration |
