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

Reply via email to