Re: serializable isolation level behavior question

From: Bob Jones <email_at_me.not>
Date: Fri, 20 Oct 2006 01:27:19 GMT
Message-ID: <XBVZg.12554$TV3.11995@newssvr21.news.prodigy.com>

"hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in message news:1161275070.399495.122890_at_m7g2000cwm.googlegroups.com...
>
> Bob Jones wrote:
>> >> Are we still talking about TRUNCATE? Serializing it is like
>> >> serializing
>> >> drop table. It does not make sense. I don't know what part was I not
>> >> clear about.
>> >
>> > You have been very clear, but you are missing the point.
>> >
>> > A serializable transaction must not get different results when issuing
>> > the
>> > same query twice. Period.
>> >
>>
>> Again, truncate is not a query, it is not even a dml.
>>
>
> Why not go back and read the original posting and the questions posed
> in it instead of repeatedly posting items not related?
>

Please do.

> The query was a SELECT in the serializable transaction.
>

No, session 1 was not set to serializable, but that is not the point anyway.

> After that you go off on some kind of unrelated rant.
>

Please show some prove. Received on Thu Oct 19 2006 - 20:27:19 CDT