Stark <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
19/09/2004 10:33 PM
To: [EMAIL PROTECTED]
cc:
Subject: Re: [GENERAL] order of row processing affects updates
[EMAIL PROTECTED] writes:
> Hi all!
> consider the following tabl
[EMAIL PROTECTED] writes:
> Hi all!
> consider the following table
>
> table a (id int primary key)
> and a particular instance of it:
> id
>
> 5
> 6
>
> now update a set id = id +1;
> fails if the executor processes row with 5 first.
Well the correct
On Sun, 19 Sep 2004 08:37:10 -0500, Paramveer.Singh wrote:
> Hi all!
> consider the following table
>
> table a (id int primary key)
> and a particular instance of it:
> id
>
> 5
> 6
>
> now update a set id = id +1;
> fails if the executor processes row
On Sun, 2004-09-19 at 08:37 -0500, [EMAIL PROTECTED] wrote:
> table a (id int primary key)
> and a particular instance of it:
> id
>
> 5
> 6
>
> now update a set id = id +1;
> fails if the executor processes row with 5 first.
> Basically what we would lik
Hi all!
consider the following table
table a (id int primary key)
and a particular instance of it:
id
5
6
now update a set id = id +1;
fails if the executor processes row with 5 first.
This means that the query will succeed sometimes and fail at other ti
