| -- @Description Tests the basic phantom read behavior of GPDB w.r.t to updates using | |
| -- the default isolation level. | |
| -- | |
| 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: SELECT * FROM ao WHERE b BETWEEN 20 AND 30 ORDER BY a; | |
| 2: BEGIN; | |
| 2: UPDATE ao SET b = -1 WHERE a = 25; | |
| 2: COMMIT; | |
| 1: SELECT * FROM ao WHERE b BETWEEN 20 AND 30 ORDER BY a; | |
| 1: COMMIT; |