Abbas Butt
-
2012-03-06
- milestone: --> 2663467
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)