View Issue Details

IDProjectCategoryView StatusLast Update
0001349Database Workbench v5Data Pump & Comparepublic2016-09-07 16:19
ReporterVolker Becker-Huberti Assigned ToMartijn Tonies  
Status closedResolutionfixed 
Product Version5.1.12 
Fixed in Version5.2.0 
Summary0001349: Option to ignore Description values within DB-Compare of Trigger and Procedures (Firebird)
DescriptionA DB-Compare in DBW 5 does also compare the RDB$Description column of the tables

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 ReproduceThis line added to the end of all trigger and procedures


"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
TagsNo tags attached.


Volker Becker-Huberti

2016-04-28 11:05

reporter   ~0000393

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.

Martijn Tonies

2016-04-28 11:07

administrator   ~0000394

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.

Volker Becker-Huberti

2016-04-29 10:38

reporter   ~0000395

Great, thanks a lot for this tip!! :-)

Issue History

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