From a426ff583d6fdc46be5c66d70ac5f159b0b46672 Mon Sep 17 00:00:00 2001
From: "Marc G. Fournier" <scrappy@hub.org>
Date: Sun, 27 Apr 1997 18:13:54 +0000
Subject: [PATCH] There, I'll leave this alone until Thomas catchs up *grin*

---
 src/test/regress/input/misc.source | 63 --------------------------------------
 src/test/regress/sql/arrays.sql    | 42 +++++++++++++++++++++++++
 src/test/regress/sql/random.sql    | 12 ++++++++
 src/test/regress/sql/tests         | 16 +++++-----
 4 files changed, 62 insertions(+), 71 deletions(-)
 create mode 100644 src/test/regress/sql/arrays.sql
 create mode 100644 src/test/regress/sql/random.sql

diff --git a/src/test/regress/input/misc.source b/src/test/regress/input/misc.source
index 74d2d84bc6..8151ff3a5a 100644
--- a/src/test/regress/input/misc.source
+++ b/src/test/regress/input/misc.source
@@ -80,19 +80,6 @@ SELECT * FROM stud_emp;
 
 
 --
--- test the random function
---
--- count the number of tuples originally
-SELECT count(*) FROM onek;
-
--- select roughly 1/10 of the tuples
-SELECT count(*) FROM onek where oidrand(onek.oid, 10);
-
--- select again, the count should be different
-SELECT count(*) FROM onek where oidrand(onek.oid, 10);
-
-
---
 -- inheritance stress test
 --
 SELECT * FROM a_star*;
@@ -228,53 +215,3 @@ SELECT user_relns() AS user_relns
 --
 -- rewrite rules
 --
-
---
--- ARRAYS
---
-SELECT * FROM arrtest;
-
-SELECT arrtest.a[1],
-          arrtest.b[1][1][1],
-          arrtest.c[1],
-          arrtest.d[1][1], 
-          arrtest.e[0]
-   FROM arrtest;
--- ??? what about
--- SELECT a[1], b[1][1][1], c[1], d[1][1], e[0]
---    FROM arrtest;
-
-SELECT arrtest.a[1:3],
-          arrtest.b[1:1][1:2][1:2],
-          arrtest.c[1:2], 
-          arrtest.d[1:1][1:2]
-   FROM arrtest;
-
--- returns three different results--
-SELECT array_dims(arrtest.b) AS x;
-
--- returns nothing 
-SELECT *
-   FROM arrtest
-   WHERE arrtest.a[1] < 5 and 
-         arrtest.c = '{"foobar"}'::_char16;
-
--- updating array subranges seems to be broken
--- 
--- UPDATE arrtest
---   SET a[1:2] = '{16,25}',
---       b[1:1][1:1][1:2] = '{113, 117}', 
---       c[1:1] = '{"new_word"}';
-
-SELECT arrtest.a[1:3],
-          arrtest.b[1:1][1:2][1:2],
-          arrtest.c[1:2], 
-          arrtest.d[1:1][1:2]
-   FROM arrtest;
-
-
---
--- expensive functions
---
-
-
diff --git a/src/test/regress/sql/arrays.sql b/src/test/regress/sql/arrays.sql
new file mode 100644
index 0000000000..117b27cf8a
--- /dev/null
+++ b/src/test/regress/sql/arrays.sql
@@ -0,0 +1,42 @@
+--
+-- ARRAYS
+--
+SELECT * FROM arrtest;
+
+SELECT arrtest.a[1],
+          arrtest.b[1][1][1],
+          arrtest.c[1],
+          arrtest.d[1][1], 
+          arrtest.e[0]
+   FROM arrtest;
+-- ??? what about
+-- SELECT a[1], b[1][1][1], c[1], d[1][1], e[0]
+--    FROM arrtest;
+
+SELECT arrtest.a[1:3],
+          arrtest.b[1:1][1:2][1:2],
+          arrtest.c[1:2], 
+          arrtest.d[1:1][1:2]
+   FROM arrtest;
+
+-- returns three different results--
+SELECT array_dims(arrtest.b) AS x;
+
+-- returns nothing 
+SELECT *
+   FROM arrtest
+   WHERE arrtest.a[1] < 5 and 
+         arrtest.c = '{"foobar"}'::_char16;
+
+-- updating array subranges seems to be broken
+-- 
+-- UPDATE arrtest
+--   SET a[1:2] = '{16,25}',
+--       b[1:1][1:1][1:2] = '{113, 117}', 
+--       c[1:1] = '{"new_word"}';
+
+SELECT arrtest.a[1:3],
+          arrtest.b[1:1][1:2][1:2],
+          arrtest.c[1:2], 
+          arrtest.d[1:1][1:2]
+   FROM arrtest;
diff --git a/src/test/regress/sql/random.sql b/src/test/regress/sql/random.sql
new file mode 100644
index 0000000000..6e541341af
--- /dev/null
+++ b/src/test/regress/sql/random.sql
@@ -0,0 +1,12 @@
+--
+-- test the random function
+--
+-- count the number of tuples originally
+SELECT count(*) FROM onek;
+
+-- select roughly 1/10 of the tuples
+SELECT count(*) FROM onek where oidrand(onek.oid, 10);
+
+-- select again, the count should be different
+SELECT count(*) FROM onek where oidrand(onek.oid, 10);
+
diff --git a/src/test/regress/sql/tests b/src/test/regress/sql/tests
index e9f3d7c075..3086689d80 100644
--- a/src/test/regress/sql/tests
+++ b/src/test/regress/sql/tests
@@ -39,13 +39,13 @@ select_distinct_on
 transactions
 portals
 errors
+misc
+random
+arrays
 btree_index
 hash_index
-aggregates.sql
-select_views.sql
-alter_table.sql
-purge.sql
-portals_p2.sql
-misc
-
-
+aggregates
+select_views
+alter_table
+purge
+portals_p2
-- 
2.11.0