Menu

#264 TRANSACTION ISOLATION LEVEL SERIALIZABLE does not work.

Development Queue
open
nobody
5
2012-06-03
2011-12-20
Abbas Butt
No

The test case involved here is portals.sql

The test case is

BEGIN;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
CREATE TABLE cursor (a int, b int) distribute by hash(b);
INSERT INTO cursor VALUES (1);
DECLARE c1 NO SCROLL CURSOR FOR SELECT * FROM cursor FOR UPDATE;
UPDATE cursor SET a = 2;
FETCH ALL FROM c1;
COMMIT;

Expected output from the FETCH is

a
---
(0 rows)

Obtained result is
a | b
---+---
2 |
(1 row)

Discussion

  • Abbas Butt

    Abbas Butt - 2012-03-06
    • milestone: --> 2663467
     
  • Koichi Suzuki

    Koichi Suzuki - 2012-06-03
    • milestone: 2663467 --> Development Queue
     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.