From 9aaf52a39acb111fe16f20da89a30abd015cc85d Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Sat, 24 Aug 2013 18:51:12 +0300 Subject: [PATCH] Use setseed() in RUN ON ANY regtest. Without it, the test can fail occasionally. Reported by Peter Eisentraut. --- test/expected/plproxy_many.out | 6 ++++++ test/sql/plproxy_many.sql | 1 + 2 files changed, 7 insertions(+) diff --git a/test/expected/plproxy_many.out b/test/expected/plproxy_many.out index c7b65a0..57bf1c2 100644 --- a/test/expected/plproxy_many.out +++ b/test/expected/plproxy_many.out @@ -81,6 +81,12 @@ select test_multi(0, 'foo'); (1 row) -- test RUN ON RANDOM +select setseed(0.5); + setseed +--------- + +(1 row) + drop function test_multi(integer, text); create function test_multi(part integer, username text) returns setof integer as $$ cluster 'testcluster'; run on any; $$ language plproxy; diff --git a/test/sql/plproxy_many.sql b/test/sql/plproxy_many.sql index c1d2305..2d0074c 100644 --- a/test/sql/plproxy_many.sql +++ b/test/sql/plproxy_many.sql @@ -54,6 +54,7 @@ returns setof integer as $$ cluster 'testcluster'; run on 2; $$ language plproxy select test_multi(0, 'foo'); -- test RUN ON RANDOM +select setseed(0.5); drop function test_multi(integer, text); create function test_multi(part integer, username text) returns setof integer as $$ cluster 'testcluster'; run on any; $$ language plproxy; -- 2.39.5