diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2008-12-29 02:58:11 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2008-12-29 02:58:11 +0000 |
| commit | 2f806e540fe48c49188956a794bf9cef1a7645a2 (patch) | |
| tree | 780d279e81411939fbadabbf7da9e6457665d6e7 /src | |
| parent | 95b07bc7f5010233f52f9d11da74e2e5b653b0a7 (diff) | |
| download | postgresql-2f806e540fe48c49188956a794bf9cef1a7645a2.tar.gz postgresql-2f806e540fe48c49188956a794bf9cef1a7645a2.zip | |
Tighten up a couple of regression test cases that can have platform-dependent
results due to underspecified ordering. Per report from buildfarm member
pika.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/window.out | 11 | ||||
| -rw-r--r-- | src/test/regress/sql/window.sql | 4 |
2 files changed, 8 insertions, 7 deletions
diff --git a/src/test/regress/expected/window.out b/src/test/regress/expected/window.out index ee16087b92c..8454d82183b 100644 --- a/src/test/regress/expected/window.out +++ b/src/test/regress/expected/window.out @@ -233,26 +233,27 @@ SELECT cume_dist() OVER (PARTITION BY four ORDER BY ten), ten, four FROM tenk1 W 1 | 3 | 3 (10 rows) -SELECT ntile(3) OVER (ORDER BY ten), ten, four FROM tenk1 WHERE unique2 < 10; +SELECT ntile(3) OVER (ORDER BY ten, four), ten, four FROM tenk1 WHERE unique2 < 10; ntile | ten | four -------+-----+------ 1 | 0 | 0 - 1 | 0 | 2 1 | 0 | 0 + 1 | 0 | 2 1 | 1 | 1 - 2 | 1 | 3 2 | 1 | 1 + 2 | 1 | 3 2 | 3 | 3 3 | 4 | 0 3 | 7 | 1 3 | 9 | 1 (10 rows) -SELECT ntile(NULL) OVER (ORDER BY ten), ten, four FROM tenk1 LIMIT 1; +SELECT ntile(NULL) OVER (ORDER BY ten, four), ten, four FROM tenk1 LIMIT 2; ntile | ten | four -------+-----+------ | 0 | 0 -(1 row) + | 0 | 0 +(2 rows) SELECT lag(ten) OVER (PARTITION BY four ORDER BY ten), ten, four FROM tenk1 WHERE unique2 < 10; lag | ten | four diff --git a/src/test/regress/sql/window.sql b/src/test/regress/sql/window.sql index 1100de5afa4..82f8624e450 100644 --- a/src/test/regress/sql/window.sql +++ b/src/test/regress/sql/window.sql @@ -54,9 +54,9 @@ SELECT percent_rank() OVER (PARTITION BY four ORDER BY ten), ten, four FROM tenk SELECT cume_dist() OVER (PARTITION BY four ORDER BY ten), ten, four FROM tenk1 WHERE unique2 < 10; -SELECT ntile(3) OVER (ORDER BY ten), ten, four FROM tenk1 WHERE unique2 < 10; +SELECT ntile(3) OVER (ORDER BY ten, four), ten, four FROM tenk1 WHERE unique2 < 10; -SELECT ntile(NULL) OVER (ORDER BY ten), ten, four FROM tenk1 LIMIT 1; +SELECT ntile(NULL) OVER (ORDER BY ten, four), ten, four FROM tenk1 LIMIT 2; SELECT lag(ten) OVER (PARTITION BY four ORDER BY ten), ten, four FROM tenk1 WHERE unique2 < 10; |