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

-- @Description Ensures that a select during a delete operation is ok
-- 
DROP TABLE IF EXISTS ao;
CREATE TABLE ao (a INT) USING @amname@;
insert into ao select generate_series(1,100);

2: BEGIN;
2: SELECT * FROM ao WHERE a < 5 ORDER BY a;
2: DELETE FROM ao WHERE a < 5;
1: SELECT * FROM ao WHERE a >= 5 AND a < 10 ORDER BY a;
3: SELECT * FROM ao WHERE a < 5 ORDER BY a;
2: COMMIT;
2: SELECT * FROM ao WHERE a < 5 ORDER BY a;
4: SELECT * FROM ao WHERE a < 10 ORDER BY a;
4: INSERT INTO ao VALUES (0);