From e19a5adaf71466efccbe1be92842e209ff6099a6 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sun, 23 Sep 2001 04:28:18 +0000 Subject: [PATCH] Update regress tests for new LIMIT x,y behavior. --- src/test/regress/expected/limit.out | 2 +- src/test/regress/sql/limit.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/src/test/regress/expected/limit.out b/src/test/regress/expected/limit.out index e14cd6daf7..c99e094156 100644 --- a/src/test/regress/expected/limit.out +++ b/src/test/regress/expected/limit.out @@ -98,7 +98,7 @@ SELECT ''::text AS five, unique1, unique2, stringu1 SELECT ''::text AS five, unique1, unique2, stringu1 FROM onek - ORDER BY unique1 LIMIT 5, 900; + ORDER BY unique1 LIMIT 900, 5; five | unique1 | unique2 | stringu1 ------+---------+---------+---------- | 900 | 913 | QIAAAA diff --git a/src/test/regress/sql/limit.sql b/src/test/regress/sql/limit.sql index d9c3688850..99842af2f6 100644 --- a/src/test/regress/sql/limit.sql +++ b/src/test/regress/sql/limit.sql @@ -29,4 +29,4 @@ SELECT ''::text AS five, unique1, unique2, stringu1 ORDER BY unique1 OFFSET 990 LIMIT 5; SELECT ''::text AS five, unique1, unique2, stringu1 FROM onek - ORDER BY unique1 LIMIT 5, 900; + ORDER BY unique1 LIMIT 900, 5; -- 2.40.0