vc wrote:
> mAsterdam wrote:
>
>>Marshall Spight wrote:
>>
>>>Jon Heggland wrote:
>>>
>>>The relational operators don't handle lists very well.
>>>
>>>myList.removeAt(3)
>>>
>>>vs.
>>>
>>>BEGIN
>>>delete from MyList where Index = 3;
>>>update MyList set Index = Index - 1 where Index > 3;
>>>COMMIT
>>
>>
>>Aside (the example surely illustrates your point)
>>could this removeAt operation possibly be useful
>>in a concurrent environment?
>>
>>You'ld never know which item you are going to scratch -
>>somebody else could have just done myList.removeAt(2).
>
>
> What happened to concurrency contro in your hypothetical system ?
Assuming MVCC the item which was the third item
in MyList at transaction time would be removed.
Results may be very unpleasant - that was my point -
but would this constitute a CC failure?
Received on Fri Mar 03 2006 - 14:30:14 CST
