Submitted by: Alex Gilev (xstarter)

Duplicates CORE3108

It's not possible to alter procedure1 in transaction1 what used in another procedure2, queried in NOT read only transaction2.

How to reproduce. Open IBExpert, in the Script executive:

SET TERM ^ ;
CREATE OR ALTER PROCEDURE TestProc1
returns (TestParam numeric (15,2))
AS
BEGIN
TestParam=1;

suspend;
END ^

CREATE OR ALTER PROCEDURE TestProc2
returns (TestParam numeric (15,2))
AS
BEGIN
select TestParam
from TestProc1
into :TestParam;

suspend;
END ^

SET TERM ; ^

select * from TestProc2;

SET TERM ^ ;
ALTER PROCEDURE TestProc1
returns (TestParam numeric (15,3))
AS
BEGIN
TestParam=1;

suspend;
END ^
SET TERM ; ^

Executed well. Open another IBExpert, in SQL Editor window execute such query:
select * from TestProc2;

Now returning into the first IBExpert and trying to execute the same script, receive 3 errors like this:
lock conflict on no wait transaction.
unsuccessful metadata update.
object TESTPROC1 is in use.

Firebird 1.5.x had not such issue. Problem is critical for us because our autoupdate system for databases can not work well if users working and have write transactions.

Note: This is maybe duplicate of CORE1081, but not duplicate of CORE888.