Issue Details (XML | Word | Printable)

Key: CORE-5833
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Zoran Vučenović
Votes: 0
Watchers: 4

If you were logged in you would be able to see more operations.
Firebird Core

DDL triggers for some object types (views, exceptions, roles, indexes, domains) are lost in backup-restore process

Created: 24/May/18 05:11 PM   Updated: 28/May/18 05:30 AM
Component/s: Engine
Affects Version/s: 4.0 Alpha 1, 3.0.3
Fix Version/s: 3.0.4, 4.0 Beta 1

Environment: Linux Mint 18.3, 64-bit

QA Status: Done successfully

 Description  « Hide
For example:

create trigger tr_bc_view
  before create view
position 0

Now, see the trigger's type:
select rdb$trigger_type from rdb$triggers where rdb$trigger_name = 'TR_BC_VIEW'
You get 540672 (HEX 84000).

Backup the database.
Restore the database.

Now, query the trigger type again (same select as above), you get 16384 (HEX 4000).

So, the bit 19, which says that this is "create view" trigger is lost during backup-restore and this trigger is unusable.

This happens with triggers defined to fire on views, as well as with triggers defined for exceptions, roles, indexes and domains. The triggers which fire on other objects do survive (triggers on tables, procedures, etc.).

 All   Comments   Change History   Subversion Commits      Sort Order: Descending order - Click to sort in ascending order
There are no comments yet on this issue.