Subject Re: [firebird-support] FOR SELECT resultset changed during update statement
Author Michael Ludwig
Ann W. Harrison schrieb am 13.12.2010 um 18:36 (-0500):
> On 12/13/2010 6:48 AM, raivis83 wrote:
> >
> > I have noticed one problem with FOR SELECT statement in pl/sql
> >procedure. Correct me if I am wrong but as far as I know ResultSet
> >returned by SELECT statement should remain unchanged while looping
> > through it. But it isn't.
>
> Yes, your right, and yes, it's non-standard.

Could Firebird's behaviour in this situation be explained as
READ COMMITTED? And READ COMMITTED regardless of my transaction
isolation setting?

--
Michael Ludwig