Re: serializable isolation level behavior question

Serge Rielau <srielau_at_ca.ibm.com> wrote:
> Laurenz Albe wrote:

>>> I would love to see it if anyone can serialize TRUNCATE in any database.  
>>
>> Check it out and enjoy.

> MS SQL Server even allows ROLLBACK past a TRUNCATE.
> Any utilities which perform truncate (LOAD/IMPORT REPLACE/ALTER TABLE)
> in DB2 ensure that concurrent users have released any locks.
> I fully expect IDS to behave similarly on TRUNCATE. IDS also does auto
> commit (like Oracle).
> So autocommit for DDL does not prevent proper semantics for DML.
>
> FWIW when I request information from a database system in a specific
> isolation level I expect exactly one of two behaviors:
> 1. Get the correct results
> 2. Get an error informing me that what I asked for couldn't be done.
>
> I don't care what the error is and what it's cause is. But an error it
> must be whether someone trips over the power cord or a rogue admistrator
> chooses to pull a table from under me.
>
> Anything else is kaput and to those who disagree I propose to sign up
> for a Database 101 class (which is different from an Oracle class!) at a
> reputable institution.

That's what I said, just a little more elaborate and more polemic.

Yours,
Laurenz Albe Received on Mon Oct 23 2006 - 10:00:12 CDT