Subject Re: [firebird-support] Re: Online DDL
Author Aldo Caruso
    Does this risk implies a database corruption or the risk only implies the undesired behaviour, from the logical point of view, of having two versions of the same stored procedure in two different transactions ( situation that ends when the older transaction commits or rolls back ) ?

Aldo Caruso

El 22/03/14 22:18, Dmitry Yemanov escribió:

23.03.2014 04:17, Aldo Caruso wrote:
> Frequently I modify stored procedures and triggers.
> If some user were connected before I started my transaction (the
> one which changes the stored procedure) he will still be using the
> unmodified version of the stored procedure. On the other hand, users who
> connects after I commit my transaction will be using the modified version.


> In that case is there a risk that two different versions of the
> same stored procedure coexist (in different transactions)

Surely this may be undesired, but this "risk" is a documented behavior,