mirror of
https://github.com/neondatabase/neon.git
synced 2025-12-26 15:49:58 +00:00
3aca717f3d
Merge batch_others and batch_pg_regress. The original idea was to split all the python tests into multiple "batches" and run each batch in parallel as a separate CI job. However, the batch_pg_regress batch was pretty short compared to all the tests in batch_others. We could split batch_others into multiple batches, but it actually seems better to just treat them as one big pool of tests and use pytest's handle the parallelism on its own. If we need to split them across multiple nodes in the future, we could use pytest-shard or something else, instead of managing the batches ourselves. Merge test_neon_regress.py, test_pg_regress.py and test_isolation.py into one file, test_pg_regress.py. Seems more clear to group all pg_regress-based tests into one file, now that they would all be in the same directory.
27 lines
978 B
PL/PgSQL
27 lines
978 B
PL/PgSQL
BEGIN;
|
|
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
|
|
CREATE TABLE cursor (a int);
|
|
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;
|
|
DROP TABLE cursor;
|
|
|
|
create table to_be_evicted(x bigint);
|
|
begin;
|
|
insert into to_be_evicted values (1);
|
|
insert into to_be_evicted select x*10 from to_be_evicted;
|
|
insert into to_be_evicted select x*10 from to_be_evicted;
|
|
insert into to_be_evicted select x*10 from to_be_evicted;
|
|
insert into to_be_evicted select x*10 from to_be_evicted;
|
|
insert into to_be_evicted select x*10 from to_be_evicted;
|
|
insert into to_be_evicted select x*10 from to_be_evicted;
|
|
insert into to_be_evicted select x*10 from to_be_evicted;
|
|
insert into to_be_evicted select x*10 from to_be_evicted;
|
|
insert into to_be_evicted select x*10 from to_be_evicted;
|
|
insert into to_be_evicted select x*10 from to_be_evicted;
|
|
select sum(x) from to_be_evicted;
|
|
end;
|
|
drop table to_be_evicted;
|