AFTER CREATE/ALTER PACKAGE DDL triggers runs in incorrectly moment ------------------------------------------------------------------
Key: CORE-4887 URL: http://tracker.firebirdsql.org/browse/CORE-4887 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Beta 2 Reporter: Adriano dos Santos Fernandes AFTER CREATE/ALTER PACKAGE DDL triggers is running before inserts and updates of RDB$PROCEDURES and RDB$FUNCTIONS, while they should run after all system tables changes. Test case: create exception e 'Empty package'! create or alter trigger t_trig after create package as begin if ((select count(*) from rdb$functions where rdb$package_name = rdb$get_context('DDL_TRIGGER', 'OBJECT_NAME')) = 0) then exception e; end! create package xpk1 as begin function f1 returns integer; end! -- 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 ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel