diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-11-21 22:26:02 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-11-21 22:26:02 +0000 |
| commit | ca1d1b79ab2e080c9edb45de761af320f7236e1c (patch) | |
| tree | c3c8bdeece85f88f0d14ea4146d38bf1541c036b /src/test/regress/sql/rules.sql | |
| parent | 63c38401d9a955cb65e6c4910a4f08f44f529c07 (diff) | |
| download | postgresql-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.sql | 4 |
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 |
