Re: serializable isolation level behavior question

Laurenz Albe wrote:
> Bob Jones <email_at_me.not> 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.

Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab