DDL triggers for some object types (views, exceptions, roles, indexes, domains)
are lost in backup-restore process
------------------------------------------------------------------------------------------------------------------
Key: CORE-5833
URL: http://tracker.firebirdsql.org/browse/CORE-5833
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.3
Environment: Linux Mint 18.3, 64-bit
Reporter: Zoran Vučenović
For example:
create trigger tr_bc_view
active
before create view
position 0
as
begin
--
end
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 byte 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.).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
