diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2001-07-15 20:16:17 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2001-07-15 20:16:17 +0000 |
| commit | 997439f59e1d487cb2bfa1384f6479fda0c4dd4c (patch) | |
| tree | 19aa0bdf82543ecad0e4993e6a2b448834d68485 /src | |
| parent | 1e3eacc6f144ca4b409503bc44074e148b0b6bc1 (diff) | |
| download | postgresql-997439f59e1d487cb2bfa1384f6479fda0c4dd4c.tar.gz postgresql-997439f59e1d487cb2bfa1384f6479fda0c4dd4c.zip | |
Add ORDER BY to a couple of test queries whose output ordering is not
as predictable as it used to be, due to recycling of free space with
new VACUUM.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/input/misc.source | 4 | ||||
| -rw-r--r-- | src/test/regress/output/misc.source | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/src/test/regress/input/misc.source b/src/test/regress/input/misc.source index 0fa63839e60..9c7a707f1c0 100644 --- a/src/test/regress/input/misc.source +++ b/src/test/regress/input/misc.source @@ -55,13 +55,13 @@ DELETE FROM onek; COPY onek FROM '@abs_builddir@/results/onek.data'; -SELECT unique1 FROM onek WHERE unique1 < 2; +SELECT unique1 FROM onek WHERE unique1 < 2 ORDER BY unique1; DELETE FROM onek2; COPY onek2 FROM '@abs_builddir@/results/onek.data'; -SELECT unique1 FROM onek2 WHERE unique1 < 2; +SELECT unique1 FROM onek2 WHERE unique1 < 2 ORDER BY unique1; COPY BINARY stud_emp TO '@abs_builddir@/results/stud_emp.data'; diff --git a/src/test/regress/output/misc.source b/src/test/regress/output/misc.source index 57dc0fb4a42..a98ccd73e36 100644 --- a/src/test/regress/output/misc.source +++ b/src/test/regress/output/misc.source @@ -42,7 +42,7 @@ DROP TABLE tmp; COPY onek TO '@abs_builddir@/results/onek.data'; DELETE FROM onek; COPY onek FROM '@abs_builddir@/results/onek.data'; -SELECT unique1 FROM onek WHERE unique1 < 2; +SELECT unique1 FROM onek WHERE unique1 < 2 ORDER BY unique1; unique1 --------- 0 @@ -51,7 +51,7 @@ SELECT unique1 FROM onek WHERE unique1 < 2; DELETE FROM onek2; COPY onek2 FROM '@abs_builddir@/results/onek.data'; -SELECT unique1 FROM onek2 WHERE unique1 < 2; +SELECT unique1 FROM onek2 WHERE unique1 < 2 ORDER BY unique1; unique1 --------- 0 |