View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002053 | Database Workbench v6 | Firebird Module | public | 2022-09-24 19:26 | 2022-10-17 10:32 |
| Reporter | Mirco Malaguti | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 6.1.0 | ||||
| Fixed in Version | 6.1.2 | ||||
| Summary | 0002053: SET TERM for procedures and trigger is not extracted in DDL extraction | ||||
| Description | Extracted database DDL for PROCEDUREs and TRIGGERs should be surrounded by SET TERM, like SET TERM ^ ; -- ^ is the alternative terminator CREATE PROCEDURE ppppp... .... BEGIN .... END^ SET TERM ^ ; but this doesn't happen in current version and the DDL is like CREATE PROCEDURE ppppp... .... BEGIN .... END; Apparently alternative termination of PSQL isn't considered. | ||||
| Steps To Reproduce | Open any database and execute "Tools > Extract metadata..." or "Extract DDL..." or "Extract Database DDL..." function. | ||||
| Additional Information | In "File > Preferences > DB Engine Specific > Firebird" specific panel I checked that "Alternative terminator" field is assigned a value ("^" in my case). I also tried to change to other values but nothing changed. | ||||
| Tags | No tags attached. | ||||
|
|
Database Workbench no longer needs SET TERM. Is there a specific reason why you want to have it? |
|
|
We submit DDL or part of them extracted with Database Workbench to other tools (e.g. isql) that needs SET TERM It's a practical issue. An option to emit them or not would be a good solution |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-09-24 19:26 | Mirco Malaguti | New Issue | |
| 2022-09-26 09:51 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2022-09-26 09:51 | Martijn Tonies | Status | new => feedback |
| 2022-09-26 09:51 | Martijn Tonies | Note Added: 0000569 | |
| 2022-09-26 10:50 | Mirco Malaguti | Note Added: 0000570 | |
| 2022-09-26 10:50 | Mirco Malaguti | Status | feedback => assigned |
| 2022-09-27 10:03 | Martijn Tonies | Status | assigned => resolved |
| 2022-09-27 10:03 | Martijn Tonies | Resolution | open => fixed |
| 2022-09-27 10:03 | Martijn Tonies | Fixed in Version | => 6.1.2 |
| 2022-10-17 10:32 | Martijn Tonies | Status | resolved => closed |
