summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/rules.sql
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2002-11-21 22:26:02 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2002-11-21 22:26:02 +0000
commitca1d1b79ab2e080c9edb45de761af320f7236e1c (patch)
treec3c8bdeece85f88f0d14ea4146d38bf1541c036b /src/test/regress/sql/rules.sql
parent63c38401d9a955cb65e6c4910a4f08f44f529c07 (diff)
downloadpostgresql-ca1d1b79ab2e080c9edb45de761af320f7236e1c.tar.gz
Wups, stuck ORDER BY on wrong query while trying to eliminate random
ordering of GROUP BY output due to hash-based aggregation.
Diffstat (limited to 'src/test/regress/sql/rules.sql')
-rw-r--r--src/test/regress/sql/rules.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/sql/rules.sql b/src/test/regress/sql/rules.sql
index 0a630194f2..3179a851eb 100644
--- a/src/test/regress/sql/rules.sql
+++ b/src/test/regress/sql/rules.sql
@@ -467,11 +467,11 @@ select * from rtest_view3;
delete from rtest_view3;
insert into rtest_view4 select * from rtest_vview4 where 3 > refcount;
-select * from rtest_view4;
+select * from rtest_view4 order by a, b;
delete from rtest_view4;
insert into rtest_view4 select * from rtest_vview5 where a > 2 and refcount = 0;
-select * from rtest_view4 order by a, b;
+select * from rtest_view4;
delete from rtest_view4;
--
-- Test for computations in views