You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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!
Submitted by: @asfernandes
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!
Commits: 50b2d73 FirebirdSQL/fbt-repository@889a712
The text was updated successfully, but these errors were encountered: