RE: AW: Re: [SQL] possible row locking bug in 7.0.3 & 7 .1
Started by Mikheev, Vadimalmost 25 years ago1 messages
This will take thought, research and discussion. A quick fix is the
last thing that should be on our minds.From my latest tests( see following post), I tend to agree,
that this is extremely sensitive :-(
I do however think that Vadim's patch description was the
correct thing to do.
To avoid double tuple versions return - maybe.
To get same results from SELECT and SELECT FOR UPDATE in functions -
no time for 7.1.
The problem case seems to be when the function is not
executed inside a txn.
Any query is executed inside TX. All queries of a function
are executed in the same TX.
Vadim