Thread: AW: [HACKERS] Q about read committed in Oracle...

AW: [HACKERS] Q about read committed in Oracle...

From
Andreas Zeugswetter
Date:
Vadim wrote:
>It's nice to see expected results but I still have some
>new questions - please help!

>1.  CREATE TABLE test (x integer, y integer)
>2.  INSERT INTO test VALUES (1, 1);
>    INSERT INTO test VALUES (1, 2);
>    INSERT INTO test VALUES (3, 2);
>3.  run two session T1 and T2
>4.  in session T2 run
>    UPDATE test SET x = 1, y = 2 WHERE x <> 1 OR y <> 2;
2 rows updated.
>5.  in session T1 run
>    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
>    UPDATE test SET y = 3 WHERE x = 1;
blocks
>    --
>    -- 1st record will be changed by T2, qual for new record
>    -- version will be OK, but T1 should be aborted (???)
>    --
>6.  in session T2 run
>    COMMIT;
>7.  in session T1 run
>    ROLLBACK;               -- just to be sure -:)
UPDATE test SET y = 3 WHERE x = 1
       *
ERROR at line 1:
ORA-08177: can't serialize access for this transaction
SQL> rollback;

Rollback complete.
>8.  now in session T2 run
>    UPDATE test SET x = 2;
3 rows updated.
>9.  in session T1 run
>    SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
>    UPDATE test SET y = 4 WHERE x = 1 or x = 2;
blocks
>11. in session T2 run
>    COMMIT;
Commit complete.
in T1: 3 rows updated.
>12. in session T1 run
>    SELECT * FROM test;         -- results?
>    ^^^^^^^^^^^^^^^^^^
>I would like to be sure that T1 will update table...
         X          Y
---------- ----------
         2          4
         2          4
         2          4

So it does.

Andreas



Re: [HACKERS] Q about read committed in Oracle...

From
"Dr. Michael Meskes"
Date:
On Thu, Jul 30, 1998 at 11:32:44AM +0200, Andreas Zeugswetter wrote:
> Vadim wrote:
> >It's nice to see expected results but I still have some
> >new questions - please help!
> ...

It seems you had the results in the wrong order Andreas.

Michael
--
Dr. Michael Meskes        meskes@online-club.de, meskes@debian.org
Go SF49ers! Go Rhein Fire!    Use Debian GNU/Linux!