Subject Re: [firebird-support] Re: FOR SELECT resultset changed during update statement
Author Kjell Rilbe
raivis83 skriver:
> --- In
> <>, "Ann W. Harrison"
> <aharrison@...> wrote:
> >
> > 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.
> >
> Well, thank you Ann. That was very helpful...

Ann has a long history of being EXTREMELY helpful, but this is a very
well-known issue amongts Firebird folks, so perhaps she's tired of
answering it time and again. Also, she did answer your question, actually.

> Can't find anything about it in FAQ's. If there is anything said about
> it, i must have been using wrong keywords. Language reference also says
> nothing about this behavior in FOR SELECT section. So i am considering
> this as a bug, as it is non-standard SQL behavior and there are no
> references in any kind of material.

Well I don't know where it's documented, if anywhere, but it's an issue
that has been with Firebird/Interbase since version 0.x. I think it's in
the roadmap for 3.0 to "fix it", but I'm not sure.

Kjell Rilbe
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64