Do not invalidate the package body when [CREATE OR] ALTER PACKAGE did not
change the packet header
--------------------------------------------------------------------------------------------------
Key: CORE-4975
URL: http://tracker.firebirdsql.org/browse/CORE-4975
Project: Firebird Core
Issue Type: Improvement
Reporter: Simonov Denis
Do not invalidate the package body when [CREATE OR] ALTER PACKAGE did not
change the packet header. For example, adding comments or formatting source of
the package header should not cause invalidation of the package body.
Test:
####
set list on;
set term ^; --------------------------------- [ 1:begin ]
create package pkg_test as
begin
procedure sp_test(a int);
end
^ ------------------------------------------- [ 1:end ]
create package body pkg_test as
begin
procedure sp_test (a int) as
begin
end
end
^
set term ;^
commit;
select 'Before ALTER package statement, w/o any changes in it' as msg,
p.rdb$package_name, p.rdb$valid_body_flag
from rdb$packages p;
set term ^; --------------------------------- [ 2:begin ]
alter package pkg_test as
begin
-- My comment
procedure sp_test(a int);
end
^ ------------------------------------------- [ 2:end ]
set term ;^
commit;
select 'After ALTER package statement, w/o any changes in it' as msg,
p.rdb$package_name, p.rdb$valid_body_flag
from rdb$packages p;
set echo on;
Output:
######
MSG Before ALTER package statement, w/o any changes in it
RDB$PACKAGE_NAME PKG_TEST
RDB$VALID_BODY_FLAG 1
MSG After ALTER package statement, w/o any changes in it
RDB$PACKAGE_NAME PKG_TEST
RDB$VALID_BODY_FLAG 0 <-- Why? This
modification should not make the package body invalid.
--
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
