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