diff options
Diffstat (limited to 'src/test/regress/sql/random.sql')
| -rw-r--r-- | src/test/regress/sql/random.sql | 18 |
1 files changed, 16 insertions, 2 deletions
diff --git a/src/test/regress/sql/random.sql b/src/test/regress/sql/random.sql index 6e541341af3..6463c7bf8bd 100644 --- a/src/test/regress/sql/random.sql +++ b/src/test/regress/sql/random.sql @@ -5,8 +5,22 @@ SELECT count(*) FROM onek; -- select roughly 1/10 of the tuples -SELECT count(*) FROM onek where oidrand(onek.oid, 10); +-- Assume that the "onek" table has 1000 tuples +-- and try to bracket the correct number so we +-- have a regression test which can pass/fail +-- - thomas 1998-08-17 +SELECT count(*) AS random INTO RANDOM_TBL + FROM onek WHERE oidrand(onek.oid, 10); -- select again, the count should be different -SELECT count(*) FROM onek where oidrand(onek.oid, 10); +INSERT INTO RANDOM_TBL (random) + SELECT count(*) + FROM onek WHERE oidrand(onek.oid, 10); + +-- now test the results for randomness in the correct range +SELECT random, count(random) FROM RANDOM_TBL + GROUP BY random HAVING count(random) > 1; + +SELECT random FROM RANDOM_TBL + WHERE random NOT BETWEEN 80 AND 120; |