View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001304 | Database Workbench v6 | Meta Data Compare & Migration | public | 2015-10-21 20:46 | 2022-01-12 11:52 |
| Reporter | Arno Brinkman | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | acknowledged | Resolution | open | ||
| Product Version | 5.1.6 | ||||
| Summary | 0001304: Stored procedure dependency not taken into account while migrating from IB to IB/FB | ||||
| Description | When creating a migrate script from InterBase (dialect 1) to InterBase/Firebird the stored procedures are not added in the right order so the script will run successfully. | ||||
| Steps To Reproduce | - Create Firebird or InterBase database - Run next DDL: SET TERM ^^ ; CREATE PROCEDURE SP_B ( I_ID Integer) returns ( ID Integer) AS BEGIN ID = I_ID * I_ID; SUSPEND; END ^^ CREATE PROCEDURE SP_A ( I_ID Integer) returns ( ID Integer) AS BEGIN FOR SELECT sp.ID FROM SP_B(:I_ID) sp INTO ID DO SUSPEND; END ^^ SET TERM ; ^^ - Call migrator wizards and output script will use alphabetic order | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-10-21 20:46 | Arno Brinkman | New Issue | |
| 2015-10-22 10:48 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2015-10-22 10:48 | Martijn Tonies | Status | new => acknowledged |
| 2022-01-12 11:52 | Martijn Tonies | Project | Database Workbench v5 => Database Workbench v6 |
