Cannot alter or drop procedure - "there are x dependencies." on FB30
--------------------------------------------------------------------
Key: CORE-6258
URL: http://tracker.firebirdsql.org/browse/CORE-6258
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.5
Reporter: Attila Molnár
Priority: Blocker
exception on commit trying ro ALTER or DROP a procedure.
create or alter procedure GL_USER (
CSAK_EHHEZ_A_PELDANYHOZ varchar(1))
returns (
ID integer,
UNEV varchar(30),
TNEV varchar(70),
GL_ROLE_ID integer,
EMAIL varchar(100))
AS
declare variable conn xszoveg;
declare variable pass xvar30;
declare variable gl_pldid integer;
begin
SELECT c.conn
FROM gl_getdbconn('Libra3s') c
INTO :conn;
IF (conn IS NULL)
THEN EXECUTE PROCEDURE gl_exception('gl_sql_run.conn.null');
SELECT rdb$get_context('USER_SESSION', 'PASSWORD_USER')
FROM dual
INTO :pass;
IF (pass IS NULL)
THEN EXECUTE PROCEDURE gl_exception('gl_sql_run.pass.null');
select ertek from xpref_olvas('GL_PLDID')
into gl_pldid;
for execute statement 'select xu.id, xu.unev, xu.tnev, xu.gl_role_id,
xu.email from xuser xu ' ||
iif(:csak_ehhez_a_peldanyhoz is not distinct from 'I', 'where exists(select 1
from xuserpld up where up.xuser_id = xu.id and up.xpld_id = ' || :gl_pldid ||
')', '')
on external :conn
as user current_user
role current_role
password :pass
into id, unev, tnev, :gl_role_id, :email do
begin
suspend;
end
end
drop procedure gl_user
select *
from rdb$dependencies d
where d.rdb$dependent_name in ('GL_USER', 'RDB$112355', 'RDB$112354',
'RDB$112356') or
d.rdb$depended_on_name in ('GL_USER', 'RDB$112355', 'RDB$112354',
'RDB$112356')
"Cannot commit transaction:
This operation is not defined for system tables.
unsuccessful metadata update.
cannot delete.
DOMAIN RDB$112355.
there are 2 dependencies."
The reported dependency is wrong, the procedure do not depend on the named
domain.
I can send you the database.
This is a stopper for us, until this is not fixed, we cannot upgrade to FB30.
--
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
