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