View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001349 | Database Workbench v5 | Data Pump & Compare | public | 2016-04-04 09:45 | 2016-09-07 16:19 |
| Reporter | Volker Becker-Huberti | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | feature | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | Windows | OS | 7 | ||
| Product Version | 5.1.12 | ||||
| Fixed in Version | 5.2.0 | ||||
| Summary | 0001349: Option to ignore Description values within DB-Compare of Trigger and Procedures (Firebird) | ||||
| Description | A DB-Compare in DBW 5 does also compare the RDB$Description column of the tables RDB$Procedures/RDB$TRIGGERS. When using the RDB$Description column to store additional information like the update timestamp of trigger and procedures within the database, then the DB-Compare will mark all trigger and procedures as different due to a different timestamp in the comment: "COMMENT ON PROCEDURE/TRIGGER..." | ||||
| Steps To Reproduce | This line added to the end of all trigger and procedures UPDATE RDB$PROCEDURES SET RDB$DESCRIPTION = '$LastChangedRevision: xxx $, aktualisiert:'||CURRENT_TIMESTAMP WHERE RDB$PROCEDURE_NAME = UPPER('NameOfProcedure'); "NameOfProcedure" needs to be replaced by the real name of the trigger or procedure "xxx" should be the revision number inserted by subversion, but doesn't matter here | ||||
| Tags | No tags attached. | ||||
|
|
Just learned about Firebird 3 "System Tables are Now Read-only". Unfortunately we can not use the RDB$DESCRIPTION field any more. "The system tables (RDB$—) are now read-only. Attempting any DDL or insert/update/delete statement on them will be rejected." So this seems no issue any more. |
|
|
Volkert, this is about direct manipulation of the system tables via UPDATE statement, Firebird offers a normal DDL-statement to modify description, so you can continu to use descriptions safely. |
|
|
Great, thanks a lot for this tip!! :-) |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-04-04 09:45 | Volker Becker-Huberti | New Issue | |
| 2016-04-05 13:03 | Martijn Tonies | Status | new => acknowledged |
| 2016-04-25 12:00 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2016-04-25 12:00 | Martijn Tonies | Status | acknowledged => assigned |
| 2016-04-25 12:00 | Martijn Tonies | Summary | Option to ignore RDB$Description values within DB-Compare of Trigger and Procedures (Firebird) => Option to ignore Description values within DB-Compare of Trigger and Procedures (Firebird) |
| 2016-04-28 11:05 | Volker Becker-Huberti | Note Added: 0000393 | |
| 2016-04-28 11:07 | Martijn Tonies | Note Added: 0000394 | |
| 2016-04-29 10:38 | Volker Becker-Huberti | Note Added: 0000395 | |
| 2016-06-27 15:13 | Martijn Tonies | Status | assigned => resolved |
| 2016-06-27 15:13 | Martijn Tonies | Fixed in Version | => 5.2.0 |
| 2016-06-27 15:13 | Martijn Tonies | Resolution | open => fixed |
| 2016-09-07 16:19 | Martijn Tonies | Status | resolved => closed |
