src/test/isolation2/input/uao/cursor_before_update.source

-- @Description Tests the visibility when a cursor has been created before the update.
-- 
DROP TABLE IF EXISTS ao;
CREATE TABLE ao (a INT, b INT) USING @amname@;
INSERT INTO ao SELECT i as a, i as b  FROM generate_series(1,100) AS i;

1: BEGIN;
1: DECLARE cur CURSOR FOR SELECT a,b FROM ao ORDER BY a;
1: FETCH NEXT IN cur;
1: FETCH NEXT IN cur;
2: BEGIN;
2: UPDATE ao SET b = 8 WHERE a < 5;
2: COMMIT;
1: FETCH NEXT IN cur;
1: FETCH NEXT IN cur;
1: FETCH NEXT IN cur;
1: CLOSE cur;
1: COMMIT;
3: BEGIN;
3: DECLARE cur CURSOR FOR SELECT a,b FROM ao ORDER BY a;
3: FETCH NEXT IN cur;
3: CLOSE cur;
3: COMMIT;