src/test/singlenode_isolation2/output/uao/select_while_delete.source

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

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