View Issue Details

IDProjectCategoryView StatusLast Update
0001047Database Workbench v5Meta Data Compare & Migrationpublic2014-12-29 10:36
ReporterDoychin Bondzhev Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status acknowledgedResolutionopen 
Product Version5.0.2 
Summary0001047: Script to crete SP after compare is not properly ordered
DescriptionNow 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.
TagsNo tags attached.

Activities

Martijn Tonies

2014-12-29 10:36

administrator   ~0000326

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.

Martijn Tonies

2014-12-29 10:36

administrator   ~0000327

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

Issue History

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