FreeBSD 4.7: BETA3 (from port): regression failures... - Mailing list pgsql-hackers
| From | Larry Rosenman |
|---|---|
| Subject | FreeBSD 4.7: BETA3 (from port): regression failures... |
| Date | |
| Msg-id | 1035785349.450.4.camel@lerlaptop.lerctr.org Whole thread Raw |
| List | pgsql-hackers |
Regression Diffs:
*** ./expected/geometry-positive-zeros-bsd.out Tue Sep 12 16:07:16 2000
--- ./results/geometry.out Mon Oct 28 00:06:41 2002
***************
*** 114,120 **** | (5.1,34.5) | [(1,2),(3,4)] | (3,4) | (-5,-12) | [(1,2),(3,4)]
| (1,2) | (10,10) | [(1,2),(3,4)] | (3,4)
! | (0,0) | [(0,0),(6,6)] | (0,0) | (-10,0) | [(0,0),(6,6)] |
(0,0) | (-3,4) | [(0,0),(6,6)] | (0.5,0.5) | (5.1,34.5) | [(0,0),(6,6)]
| (6,6)
--- 114,120 ---- | (5.1,34.5) | [(1,2),(3,4)] | (3,4) | (-5,-12) | [(1,2),(3,4)]
| (1,2) | (10,10) | [(1,2),(3,4)] | (3,4)
! | (0,0) | [(0,0),(6,6)] | (-0,0) | (-10,0) | [(0,0),(6,6)] |
(0,0) | (-3,4) | [(0,0),(6,6)] | (0.5,0.5) | (5.1,34.5) | [(0,0),(6,6)]
| (6,6)
***************
*** 224,233 **** twentyfour | rotation ------------+----------------------------- |
(0,0),(0,0)
! | (0,0),(-20,-20)
! | (0,2),(-14,0) | (0,79.2),(-58.8,0)
! | (14,0),(0,-34) | (0,40),(0,0) | (0,0),(0,0) | (-10,-10),(-30,-30)
--- 224,233 ---- twentyfour | rotation ------------+----------------------------- |
(0,0),(0,0)
! | (-0,0),(-20,-20)
! | (-0,2),(-14,0) | (0,79.2),(-58.8,0)
! | (14,-0),(0,-34) | (0,40),(0,0) | (0,0),(0,0) | (-10,-10),(-30,-30)
***************
*** 254,264 **** WHERE (p.f1 <-> point '(0,0)') >= 1; twenty | rotation
--------+-----------------------------------------------------------------------------------
! | (0,0),(-0.2,-0.2) | (-0.1,-0.1),(-0.3,-0.3) | (-0.25,-0.25),(-0.25,-0.35) |
(-0.3,-0.3),(-0.3,-0.3)
! | (0.08,0),(0,-0.56) | (0.12,-0.28),(0.04,-0.84) | (0.26,-0.7),(0.1,-0.82) |
(0.12,-0.84),(0.12,-0.84)
--- 254,264 ---- WHERE (p.f1 <-> point '(0,0)') >= 1; twenty | rotation
--------+-----------------------------------------------------------------------------------
! | (0,-0),(-0.2,-0.2) | (-0.1,-0.1),(-0.3,-0.3) | (-0.25,-0.25),(-0.25,-0.35) |
(-0.3,-0.3),(-0.3,-0.3)
! | (0.08,-0),(0,-0.56) | (0.12,-0.28),(0.04,-0.84) | (0.26,-0.7),(0.1,-0.82) |
(0.12,-0.84),(0.12,-0.84)
***************
*** 266,272 **** | (0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825) |
(0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521) |
(0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825)
! | (0,0.0828402366863905),(-0.201183431952663,0) |
(-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953) |
(-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201) |
(-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586)
--- 266,272 ---- | (0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825) |
(0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521) |
(0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825)
! | (-0,0.0828402366863905),(-0.201183431952663,0) |
(-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953) |
(-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201) |
(-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586)
======================================================================
*** ./expected/horology.out Wed Sep 18 16:35:25 2002
--- ./results/horology.out Mon Oct 28 00:06:41 2002
***************
*** 537,549 **** SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day'))
as"True"; True ------
! t (1 row) SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days'))
as"True"; True ------
! t (1 row) SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
--- 537,549 ---- SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day'))
as"True"; True ------
! f (1 row) SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days'))
as"True"; True ------
! f (1 row) SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
======================================================================
*** ./expected/copy.out Mon Oct 28 00:06:11 2002
--- ./results/copy.out Mon Oct 28 00:06:49 2002
***************
*** 7,14 ****
--- 7,16 ---- COPY aggtest FROM
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/data/agg.data';COPY onek FROM
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/data/onek.data';COPY onek TO
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data';
+ ERROR: COPY command, running in backend with effective uid 70, could not open file
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data'for writing. Errno =
Permissiondenied (13). DELETE FROM onek; COPY onek FROM
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data';
+ ERROR: COPY command, running in backend with effective uid 70, could not open file
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data'for reading. Errno =
Nosuch file or directory (2). COPY tenk1 FROM
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/data/tenk.data';COPY slow_emp4000 FROM
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/data/rect.data';COPY person FROM
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/data/person.data';
======================================================================
*** ./expected/select.out Thu Jul 18 12:11:49 2002
--- ./results/select.out Mon Oct 28 00:07:02 2002
***************
*** 8,24 **** ORDER BY onek.unique1; unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand| fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 0 | 998 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
|AAAAAA | KMBAAA | OOOOxx
! 1 | 214 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 3
|BAAAAA | GIAAAA | OOOOxx
! 2 | 326 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 4 | 5
|CAAAAA | OMAAAA | OOOOxx
! 3 | 431 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 6 | 7
|DAAAAA | PQAAAA | VVVVxx
! 4 | 833 | 0 | 0 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 8 | 9
|EAAAAA | BGBAAA | HHHHxx
! 5 | 541 | 1 | 1 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 10 | 11
|FAAAAA | VUAAAA | HHHHxx
! 6 | 978 | 0 | 2 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 12 | 13
|GAAAAA | QLBAAA | OOOOxx
! 7 | 647 | 1 | 3 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 14 | 15
|HAAAAA | XYAAAA | VVVVxx
! 8 | 653 | 0 | 0 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 16 | 17
|IAAAAA | DZAAAA | HHHHxx
! 9 | 49 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 18 | 19
|JAAAAA | XBAAAA | HHHHxx
! (10 rows) -- -- awk '{if($1<20){print $1,$14;}else{next;}}' onek.data | sort +0nr -1
--- 8,14 ---- ORDER BY onek.unique1; unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand| fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows) -- -- awk '{if($1<20){print $1,$14;}else{next;}}' onek.data | sort +0nr -1
***************
*** 28,54 **** ORDER BY unique1 using >; unique1 | stringu1 ---------+----------
! 19 | TAAAAA
! 18 | SAAAAA
! 17 | RAAAAA
! 16 | QAAAAA
! 15 | PAAAAA
! 14 | OAAAAA
! 13 | NAAAAA
! 12 | MAAAAA
! 11 | LAAAAA
! 10 | KAAAAA
! 9 | JAAAAA
! 8 | IAAAAA
! 7 | HAAAAA
! 6 | GAAAAA
! 5 | FAAAAA
! 4 | EAAAAA
! 3 | DAAAAA
! 2 | CAAAAA
! 1 | BAAAAA
! 0 | AAAAAA
! (20 rows) -- -- awk '{if($1>980){print $1,$14;}else{next;}}' onek.data | sort +1d -2
--- 18,24 ---- ORDER BY unique1 using >; unique1 | stringu1 ---------+----------
! (0 rows) -- -- awk '{if($1>980){print $1,$14;}else{next;}}' onek.data | sort +1d -2
***************
*** 58,83 **** ORDER BY stringu1 using <; unique1 | stringu1 ---------+----------
! 988 | AMAAAA
! 989 | BMAAAA
! 990 | CMAAAA
! 991 | DMAAAA
! 992 | EMAAAA
! 993 | FMAAAA
! 994 | GMAAAA
! 995 | HMAAAA
! 996 | IMAAAA
! 997 | JMAAAA
! 998 | KMAAAA
! 999 | LMAAAA
! 981 | TLAAAA
! 982 | ULAAAA
! 983 | VLAAAA
! 984 | WLAAAA
! 985 | XLAAAA
! 986 | YLAAAA
! 987 | ZLAAAA
! (19 rows) --
--- 28,34 ---- ORDER BY stringu1 using <; unique1 | stringu1 ---------+----------
! (0 rows) --
***************
*** 89,114 **** ORDER BY string4 using <, unique1 using >; unique1 | string4 ---------+---------
! 999 | AAAAxx
! 995 | AAAAxx
! 983 | AAAAxx
! 982 | AAAAxx
! 981 | AAAAxx
! 998 | HHHHxx
! 997 | HHHHxx
! 993 | HHHHxx
! 990 | HHHHxx
! 986 | HHHHxx
! 996 | OOOOxx
! 991 | OOOOxx
! 988 | OOOOxx
! 987 | OOOOxx
! 985 | OOOOxx
! 994 | VVVVxx
! 992 | VVVVxx
! 989 | VVVVxx
! 984 | VVVVxx
! (19 rows) --
--- 40,46 ---- ORDER BY string4 using <, unique1 using >; unique1 | string4 ---------+---------
! (0 rows) --
***************
*** 120,145 **** ORDER BY string4 using >, unique1 using <; unique1 | string4 ---------+---------
! 984 | VVVVxx
! 989 | VVVVxx
! 992 | VVVVxx
! 994 | VVVVxx
! 985 | OOOOxx
! 987 | OOOOxx
! 988 | OOOOxx
! 991 | OOOOxx
! 996 | OOOOxx
! 986 | HHHHxx
! 990 | HHHHxx
! 993 | HHHHxx
! 997 | HHHHxx
! 998 | HHHHxx
! 981 | AAAAxx
! 982 | AAAAxx
! 983 | AAAAxx
! 995 | AAAAxx
! 999 | AAAAxx
! (19 rows) --
--- 52,58 ---- ORDER BY string4 using >, unique1 using <; unique1 | string4 ---------+---------
! (0 rows) --
***************
*** 151,177 **** ORDER BY unique1 using >, string4 using <; unique1 | string4 ---------+---------
! 19 | OOOOxx
! 18 | VVVVxx
! 17 | HHHHxx
! 16 | OOOOxx
! 15 | VVVVxx
! 14 | AAAAxx
! 13 | OOOOxx
! 12 | AAAAxx
! 11 | OOOOxx
! 10 | AAAAxx
! 9 | HHHHxx
! 8 | HHHHxx
! 7 | VVVVxx
! 6 | OOOOxx
! 5 | HHHHxx
! 4 | HHHHxx
! 3 | VVVVxx
! 2 | OOOOxx
! 1 | OOOOxx
! 0 | OOOOxx
! (20 rows) -- -- awk '{if($1<20){print $1,$16;}else{next;}}' onek.data |
--- 64,70 ---- ORDER BY unique1 using >, string4 using <; unique1 | string4 ---------+---------
! (0 rows) -- -- awk '{if($1<20){print $1,$16;}else{next;}}' onek.data |
***************
*** 182,208 **** ORDER BY unique1 using <, string4 using >; unique1 | string4 ---------+---------
! 0 | OOOOxx
! 1 | OOOOxx
! 2 | OOOOxx
! 3 | VVVVxx
! 4 | HHHHxx
! 5 | HHHHxx
! 6 | OOOOxx
! 7 | VVVVxx
! 8 | HHHHxx
! 9 | HHHHxx
! 10 | AAAAxx
! 11 | OOOOxx
! 12 | AAAAxx
! 13 | OOOOxx
! 14 | AAAAxx
! 15 | VVVVxx
! 16 | OOOOxx
! 17 | HHHHxx
! 18 | VVVVxx
! 19 | OOOOxx
! (20 rows) -- -- test partial btree indexes
--- 75,81 ---- ORDER BY unique1 using <, string4 using >; unique1 | string4 ---------+---------
! (0 rows) -- -- test partial btree indexes
***************
*** 217,233 **** SELECT onek2.* WHERE onek2.unique1 < 10; unique1 | unique2 | two | four | ten | twenty | hundred |
thousand| twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 0 | 998 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
|AAAAAA | KMBAAA | OOOOxx
! 1 | 214 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 3
|BAAAAA | GIAAAA | OOOOxx
! 2 | 326 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 4 | 5
|CAAAAA | OMAAAA | OOOOxx
! 3 | 431 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 6 | 7
|DAAAAA | PQAAAA | VVVVxx
! 4 | 833 | 0 | 0 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 8 | 9
|EAAAAA | BGBAAA | HHHHxx
! 5 | 541 | 1 | 1 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 10 | 11
|FAAAAA | VUAAAA | HHHHxx
! 6 | 978 | 0 | 2 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 12 | 13
|GAAAAA | QLBAAA | OOOOxx
! 7 | 647 | 1 | 3 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 14 | 15
|HAAAAA | XYAAAA | VVVVxx
! 8 | 653 | 0 | 0 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 16 | 17
|IAAAAA | DZAAAA | HHHHxx
! 9 | 49 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 18 | 19
|JAAAAA | XBAAAA | HHHHxx
! (10 rows) -- -- awk '{if($1<20){print $1,$14;}else{next;}}' onek.data | sort +0nr -1
--- 90,96 ---- SELECT onek2.* WHERE onek2.unique1 < 10; unique1 | unique2 | two | four | ten | twenty | hundred |
thousand| twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows) -- -- awk '{if($1<20){print $1,$14;}else{next;}}' onek.data | sort +0nr -1
***************
*** 237,263 **** ORDER BY unique1 using >; unique1 | stringu1 ---------+----------
! 19 | TAAAAA
! 18 | SAAAAA
! 17 | RAAAAA
! 16 | QAAAAA
! 15 | PAAAAA
! 14 | OAAAAA
! 13 | NAAAAA
! 12 | MAAAAA
! 11 | LAAAAA
! 10 | KAAAAA
! 9 | JAAAAA
! 8 | IAAAAA
! 7 | HAAAAA
! 6 | GAAAAA
! 5 | FAAAAA
! 4 | EAAAAA
! 3 | DAAAAA
! 2 | CAAAAA
! 1 | BAAAAA
! 0 | AAAAAA
! (20 rows) -- -- awk '{if($1>980){print $1,$14;}else{next;}}' onek.data | sort +1d -2
--- 100,106 ---- ORDER BY unique1 using >; unique1 | stringu1 ---------+----------
! (0 rows) -- -- awk '{if($1>980){print $1,$14;}else{next;}}' onek.data | sort +1d -2
***************
*** 266,291 **** WHERE onek2.unique1 > 980; unique1 | stringu1 ---------+----------
! 981 | TLAAAA
! 982 | ULAAAA
! 983 | VLAAAA
! 984 | WLAAAA
! 985 | XLAAAA
! 986 | YLAAAA
! 987 | ZLAAAA
! 988 | AMAAAA
! 989 | BMAAAA
! 990 | CMAAAA
! 991 | DMAAAA
! 992 | EMAAAA
! 993 | FMAAAA
! 994 | GMAAAA
! 995 | HMAAAA
! 996 | IMAAAA
! 997 | JMAAAA
! 998 | KMAAAA
! 999 | LMAAAA
! (19 rows) SELECT two, stringu1, ten, string4 INTO TABLE tmp
--- 109,115 ---- WHERE onek2.unique1 > 980; unique1 | stringu1 ---------+----------
! (0 rows) SELECT two, stringu1, ten, string4 INTO TABLE tmp
======================================================================
*** ./expected/select_distinct.out Thu Jan 6 00:40:54 2000
--- ./results/select_distinct.out Mon Oct 28 00:07:03 2002
***************
*** 7,15 **** SELECT DISTINCT two FROM tmp; two -----
! 0
! 1
! (2 rows) -- -- awk '{print $5;}' onek.data | sort -n | uniq
--- 7,13 ---- SELECT DISTINCT two FROM tmp; two -----
! (0 rows) -- -- awk '{print $5;}' onek.data | sort -n | uniq
***************
*** 17,33 **** SELECT DISTINCT ten FROM tmp; ten -----
! 0
! 1
! 2
! 3
! 4
! 5
! 6
! 7
! 8
! 9
! (10 rows) -- -- awk '{print $16;}' onek.data | sort -d | uniq
--- 15,21 ---- SELECT DISTINCT ten FROM tmp; ten -----
! (0 rows) -- -- awk '{print $16;}' onek.data | sort -d | uniq
***************
*** 35,45 **** SELECT DISTINCT string4 FROM tmp; string4 ---------
! AAAAxx
! HHHHxx
! OOOOxx
! VVVVxx
! (4 rows) -- -- awk '{print $3,$16,$5;}' onek.data | sort -d | uniq |
--- 23,29 ---- SELECT DISTINCT string4 FROM tmp; string4 ---------
! (0 rows) -- -- awk '{print $3,$16,$5;}' onek.data | sort -d | uniq |
***************
*** 50,96 **** ORDER BY two using <, string4 using <, ten using <; two | string4 | ten -----+---------+-----
! 0 | AAAAxx | 0
! 0 | AAAAxx | 2
! 0 | AAAAxx | 4
! 0 | AAAAxx | 6
! 0 | AAAAxx | 8
! 0 | HHHHxx | 0
! 0 | HHHHxx | 2
! 0 | HHHHxx | 4
! 0 | HHHHxx | 6
! 0 | HHHHxx | 8
! 0 | OOOOxx | 0
! 0 | OOOOxx | 2
! 0 | OOOOxx | 4
! 0 | OOOOxx | 6
! 0 | OOOOxx | 8
! 0 | VVVVxx | 0
! 0 | VVVVxx | 2
! 0 | VVVVxx | 4
! 0 | VVVVxx | 6
! 0 | VVVVxx | 8
! 1 | AAAAxx | 1
! 1 | AAAAxx | 3
! 1 | AAAAxx | 5
! 1 | AAAAxx | 7
! 1 | AAAAxx | 9
! 1 | HHHHxx | 1
! 1 | HHHHxx | 3
! 1 | HHHHxx | 5
! 1 | HHHHxx | 7
! 1 | HHHHxx | 9
! 1 | OOOOxx | 1
! 1 | OOOOxx | 3
! 1 | OOOOxx | 5
! 1 | OOOOxx | 7
! 1 | OOOOxx | 9
! 1 | VVVVxx | 1
! 1 | VVVVxx | 3
! 1 | VVVVxx | 5
! 1 | VVVVxx | 7
! 1 | VVVVxx | 9
! (40 rows) -- -- awk '{print $2;}' person.data |
--- 34,40 ---- ORDER BY two using <, string4 using <, ten using <; two | string4 | ten -----+---------+-----
! (0 rows) -- -- awk '{print $2;}' person.data |
======================================================================
*** ./expected/select_distinct_on.out Thu Jan 27 12:11:50 2000
--- ./results/select_distinct_on.out Mon Oct 28 00:07:03 2002
***************
*** 6,16 **** ORDER BY string4 using <, two using >, ten using <; string4 | two | ten ---------+-----+-----
! AAAAxx | 1 | 1
! HHHHxx | 1 | 1
! OOOOxx | 1 | 1
! VVVVxx | 1 | 1
! (4 rows) -- this will fail due to conflict of ordering requirements SELECT DISTINCT ON (string4, ten) string4, two,
ten
--- 6,12 ---- ORDER BY string4 using <, two using >, ten using <; string4 | two | ten ---------+-----+-----
! (0 rows) -- this will fail due to conflict of ordering requirements SELECT DISTINCT ON (string4, ten) string4, two,
ten
***************
*** 22,66 **** ORDER BY string4 using <, ten using >, two using <; string4 | ten | two ---------+-----+-----
! AAAAxx | 9 | 1
! AAAAxx | 8 | 0
! AAAAxx | 7 | 1
! AAAAxx | 6 | 0
! AAAAxx | 5 | 1
! AAAAxx | 4 | 0
! AAAAxx | 3 | 1
! AAAAxx | 2 | 0
! AAAAxx | 1 | 1
! AAAAxx | 0 | 0
! HHHHxx | 9 | 1
! HHHHxx | 8 | 0
! HHHHxx | 7 | 1
! HHHHxx | 6 | 0
! HHHHxx | 5 | 1
! HHHHxx | 4 | 0
! HHHHxx | 3 | 1
! HHHHxx | 2 | 0
! HHHHxx | 1 | 1
! HHHHxx | 0 | 0
! OOOOxx | 9 | 1
! OOOOxx | 8 | 0
! OOOOxx | 7 | 1
! OOOOxx | 6 | 0
! OOOOxx | 5 | 1
! OOOOxx | 4 | 0
! OOOOxx | 3 | 1
! OOOOxx | 2 | 0
! OOOOxx | 1 | 1
! OOOOxx | 0 | 0
! VVVVxx | 9 | 1
! VVVVxx | 8 | 0
! VVVVxx | 7 | 1
! VVVVxx | 6 | 0
! VVVVxx | 5 | 1
! VVVVxx | 4 | 0
! VVVVxx | 3 | 1
! VVVVxx | 2 | 0
! VVVVxx | 1 | 1
! VVVVxx | 0 | 0
! (40 rows)
--- 18,22 ---- ORDER BY string4 using <, ten using >, two using <; string4 | ten | two ---------+-----+-----
! (0 rows)
======================================================================
*** ./expected/aggregates.out Wed Oct 2 14:21:26 2002
--- ./results/aggregates.out Mon Oct 28 00:07:04 2002
***************
*** 3,10 **** -- SELECT avg(four) AS avg_1 FROM onek; avg_1
! ---------------------
! 1.50000000000000000 (1 row) SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
--- 3,10 ---- -- SELECT avg(four) AS avg_1 FROM onek; avg_1
! -------
! (1 row) SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
***************
*** 30,36 **** SELECT sum(four) AS sum_1500 FROM onek; sum_1500 ----------
! 1500 (1 row) SELECT sum(a) AS sum_198 FROM aggtest;
--- 30,36 ---- SELECT sum(four) AS sum_1500 FROM onek; sum_1500 ----------
! (1 row) SELECT sum(a) AS sum_198 FROM aggtest;
***************
*** 54,60 **** SELECT max(four) AS max_3 FROM onek; max_3 -------
! 3 (1 row) SELECT max(a) AS max_100 FROM aggtest;
--- 54,60 ---- SELECT max(four) AS max_3 FROM onek; max_3 -------
! (1 row) SELECT max(a) AS max_100 FROM aggtest;
***************
*** 78,137 **** SELECT count(four) AS cnt_1000 FROM onek; cnt_1000 ----------
! 1000 (1 row) SELECT count(DISTINCT four) AS cnt_4 FROM onek; cnt_4 -------
! 4 (1 row) select ten, count(*), sum(four) from onek group by ten; ten | count | sum -----+-------+-----
! 0 | 100 | 100
! 1 | 100 | 200
! 2 | 100 | 100
! 3 | 100 | 200
! 4 | 100 | 100
! 5 | 100 | 200
! 6 | 100 | 100
! 7 | 100 | 200
! 8 | 100 | 100
! 9 | 100 | 200
! (10 rows) select ten, count(four), sum(DISTINCT four) from onek group by ten; ten | count | sum
-----+-------+-----
! 0 | 100 | 2
! 1 | 100 | 4
! 2 | 100 | 2
! 3 | 100 | 4
! 4 | 100 | 2
! 5 | 100 | 4
! 6 | 100 | 2
! 7 | 100 | 4
! 8 | 100 | 2
! 9 | 100 | 4
! (10 rows) SELECT newavg(four) AS avg_1 FROM onek; avg_1
! ---------------------
! 1.50000000000000000 (1 row) SELECT newsum(four) AS sum_1500 FROM onek; sum_1500 ----------
! 1500 (1 row) SELECT newcnt(four) AS cnt_1000 FROM onek; cnt_1000 ----------
! 1000 (1 row)
--- 78,117 ---- SELECT count(four) AS cnt_1000 FROM onek; cnt_1000 ----------
! 0 (1 row) SELECT count(DISTINCT four) AS cnt_4 FROM onek; cnt_4 -------
! 0 (1 row) select ten, count(*), sum(four) from onek group by ten; ten | count | sum -----+-------+-----
! (0 rows) select ten, count(four), sum(DISTINCT four) from onek group by ten; ten | count | sum
-----+-------+-----
! (0 rows) SELECT newavg(four) AS avg_1 FROM onek; avg_1
! -------
! (1 row) SELECT newsum(four) AS sum_1500 FROM onek; sum_1500 ----------
! 0 (1 row) SELECT newcnt(four) AS cnt_1000 FROM onek; cnt_1000 ----------
! 0 (1 row)
======================================================================
*** ./expected/random.out Thu Jan 6 00:40:54 2000
--- ./results/random.out Mon Oct 28 00:07:05 2002
***************
*** 6,12 **** SELECT count(*) FROM onek; count -------
! 1000 (1 row) -- select roughly 1/10 of the tuples
--- 6,12 ---- SELECT count(*) FROM onek; count -------
! 0 (1 row) -- select roughly 1/10 of the tuples
***************
*** 25,35 **** GROUP BY random HAVING count(random) > 1; random | count --------+-------
! (0 rows) SELECT random FROM RANDOM_TBL WHERE random NOT BETWEEN 80 AND 120; random --------
! (0 rows)
--- 25,38 ---- GROUP BY random HAVING count(random) > 1; random | count --------+-------
! 0 | 2
! (1 row) SELECT random FROM RANDOM_TBL WHERE random NOT BETWEEN 80 AND 120; random --------
! 0
! 0
! (2 rows)
======================================================================
*** ./expected/misc.out Mon Oct 28 00:06:11 2002
--- ./results/misc.out Mon Oct 28 00:07:06 2002
***************
*** 40,73 **** -- copy -- COPY onek TO
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data';DELETE FROM onek; COPY
onekFROM '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data'; SELECT
unique1FROM onek WHERE unique1 < 2 ORDER BY unique1; unique1 ---------
! 0
! 1
! (2 rows) DELETE FROM onek2; COPY onek2 FROM
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data';SELECT unique1 FROM
onek2WHERE unique1 < 2 ORDER BY unique1; unique1 ---------
! 0
! 1
! (2 rows) COPY BINARY stud_emp TO
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/stud_emp.data';DELETE FROM
stud_emp;COPY BINARY stud_emp FROM
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/stud_emp.data';SELECT * FROM
stud_emp; name | age | location | salary | manager | gpa | percent
! -------+-----+------------+--------+---------+-----+---------
! jeff | 23 | (8,7.7) | 600 | sharon | 3.5 |
! cim | 30 | (10.5,4.7) | 400 | | 3.4 |
! linda | 19 | (0.9,6.1) | 100 | | 2.9 |
! (3 rows) -- COPY aggtest FROM stdin; -- 56 7.8
--- 40,71 ---- -- copy -- COPY onek TO
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data';
+ ERROR: COPY command, running in backend with effective uid 70, could not open file
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data'for writing. Errno =
Permissiondenied (13). DELETE FROM onek; COPY onek FROM
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data';
+ ERROR: COPY command, running in backend with effective uid 70, could not open file
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data'for reading. Errno =
Nosuch file or directory (2). SELECT unique1 FROM onek WHERE unique1 < 2 ORDER BY unique1; unique1 ---------
! (0 rows) DELETE FROM onek2; COPY onek2 FROM
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data';
+ ERROR: COPY command, running in backend with effective uid 70, could not open file
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data'for reading. Errno =
Nosuch file or directory (2). SELECT unique1 FROM onek2 WHERE unique1 < 2 ORDER BY unique1; unique1 ---------
! (0 rows) COPY BINARY stud_emp TO
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/stud_emp.data';
+ ERROR: COPY command, running in backend with effective uid 70, could not open file
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/stud_emp.data'for writing. Errno
=Permission denied (13). DELETE FROM stud_emp; COPY BINARY stud_emp FROM
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/stud_emp.data';
+ ERROR: COPY command, running in backend with effective uid 70, could not open file
'/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/stud_emp.data'for reading. Errno
=No such file or directory (2). SELECT * FROM stud_emp; name | age | location | salary | manager | gpa | percent
! ------+-----+----------+--------+---------+-----+---------
! (0 rows) -- COPY aggtest FROM stdin; -- 56 7.8
***************
*** 460,467 **** mike | posthacking joe | basketball sally | basketball
! jeff | posthacking
! (4 rows) -- -- the next two queries demonstrate how functions generate bogus duplicates.
--- 458,464 ---- mike | posthacking joe | basketball sally | basketball
! (3 rows) -- -- the next two queries demonstrate how functions generate bogus duplicates.
***************
*** 512,520 **** mike | posthacking | peet's coffee joe | basketball | hightops sally | basketball | hightops
! jeff | posthacking | advil
! jeff | posthacking | peet's coffee
! (6 rows) -- -- just like the last two, but make sure that the target list fixup and
--- 509,515 ---- mike | posthacking | peet's coffee joe | basketball | hightops sally | basketball | hightops
! (4 rows) -- -- just like the last two, but make sure that the target list fixup and
***************
*** 536,544 **** peet's coffee | mike | posthacking hightops | joe | basketball hightops | sally |
basketball
! advil | jeff | posthacking
! peet's coffee | jeff | posthacking
! (6 rows) SELECT (p.hobbies).equipment.name, name(p.hobbies), p.name FROM ONLY person p; name | name
|name
--- 531,537 ---- peet's coffee | mike | posthacking hightops | joe | basketball hightops | sally |
basketball
! (4 rows) SELECT (p.hobbies).equipment.name, name(p.hobbies), p.name FROM ONLY person p; name | name
|name
***************
*** 556,564 **** peet's coffee | posthacking | mike hightops | basketball | joe hightops | basketball |
sally
! advil | posthacking | jeff
! peet's coffee | posthacking | jeff
! (6 rows) SELECT user_relns() AS user_relns ORDER BY user_relns;
--- 549,555 ---- peet's coffee | posthacking | mike hightops | basketball | joe hightops | basketball |
sally
! (4 rows) SELECT user_relns() AS user_relns ORDER BY user_relns;
======================================================================
*** ./expected/portals_p2.out Mon Jul 16 00:07:00 2001
--- ./results/portals_p2.out Mon Oct 28 00:07:10 2002
***************
*** 31,110 **** FETCH all in foo13; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 50 | 253 | 0 | 2 | 0 | 10 | 0 | 50 | 50 | 50 | 50 | 0 | 1
|YBAAAA | TJAAAA | HHHHxx
! (1 row) FETCH all in foo14; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 51 | 76 | 1 | 3 | 1 | 11 | 1 | 51 | 51 | 51 | 51 | 2 | 3
|ZBAAAA | YCAAAA | AAAAxx
! (1 row) FETCH all in foo15; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 52 | 985 | 0 | 0 | 2 | 12 | 2 | 52 | 52 | 52 | 52 | 4 | 5
|ACAAAA | XLBAAA | HHHHxx
! (1 row) FETCH all in foo16; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 53 | 196 | 1 | 1 | 3 | 13 | 3 | 53 | 53 | 53 | 53 | 6 | 7
|BCAAAA | OHAAAA | AAAAxx
! (1 row) FETCH all in foo17; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 54 | 356 | 0 | 2 | 4 | 14 | 4 | 54 | 54 | 54 | 54 | 8 | 9
|CCAAAA | SNAAAA | AAAAxx
! (1 row) FETCH all in foo18; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 55 | 627 | 1 | 3 | 5 | 15 | 5 | 55 | 55 | 55 | 55 | 10 | 11
|DCAAAA | DYAAAA | VVVVxx
! (1 row) FETCH all in foo19; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 56 | 54 | 0 | 0 | 6 | 16 | 6 | 56 | 56 | 56 | 56 | 12 | 13
|ECAAAA | CCAAAA | OOOOxx
! (1 row) FETCH all in foo20; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 57 | 942 | 1 | 1 | 7 | 17 | 7 | 57 | 57 | 57 | 57 | 14 | 15
|FCAAAA | GKBAAA | OOOOxx
! (1 row) FETCH all in foo21; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 58 | 114 | 0 | 2 | 8 | 18 | 8 | 58 | 58 | 58 | 58 | 16 | 17
|GCAAAA | KEAAAA | OOOOxx
! (1 row) FETCH all in foo22; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 59 | 593 | 1 | 3 | 9 | 19 | 9 | 59 | 59 | 59 | 59 | 18 | 19
|HCAAAA | VWAAAA | HHHHxx
! (1 row) FETCH all in foo23; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 60 | 483 | 0 | 0 | 0 | 0 | 0 | 60 | 60 | 60 | 60 | 0 | 1
|ICAAAA | PSAAAA | VVVVxx
! (1 row) FETCH all in foo24; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 50 | 253 | 0 | 2 | 0 | 10 | 0 | 50 | 50 | 50 | 50 | 0 | 1
|YBAAAA | TJAAAA | HHHHxx
! (1 row) FETCH all in foo25; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 60 | 483 | 0 | 0 | 0 | 0 | 0 | 60 | 60 | 60 | 60 | 0 | 1
|ICAAAA | PSAAAA | VVVVxx
! (1 row) CLOSE foo13; CLOSE foo14;
--- 31,97 ---- FETCH all in foo13; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows) FETCH all in foo14; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows) FETCH all in foo15; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows) FETCH all in foo16; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows) FETCH all in foo17; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows) FETCH all in foo18; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows) FETCH all in foo19; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows) FETCH all in foo20; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows) FETCH all in foo21; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows) FETCH all in foo22; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows) FETCH all in foo23; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows) FETCH all in foo24; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows) FETCH all in foo25; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand |
fivethous| tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows) CLOSE foo13; CLOSE foo14;
======================================================================
*** ./expected/limit.out Fri Oct 19 21:55:39 2001
--- ./results/limit.out Mon Oct 28 00:07:19 2002
***************
*** 7,46 **** ORDER BY unique1 LIMIT 2; two | unique1 | unique2 | stringu1
-----+---------+---------+----------
! | 51 | 76 | ZBAAAA
! | 52 | 985 | ACAAAA
! (2 rows) SELECT ''::text AS five, unique1, unique2, stringu1 FROM onek WHERE unique1 > 60 ORDER BY
unique1LIMIT 5; five | unique1 | unique2 | stringu1 ------+---------+---------+----------
! | 61 | 560 | JCAAAA
! | 62 | 633 | KCAAAA
! | 63 | 296 | LCAAAA
! | 64 | 479 | MCAAAA
! | 65 | 64 | NCAAAA
! (5 rows) SELECT ''::text AS two, unique1, unique2, stringu1 FROM onek WHERE unique1 > 60 AND unique1 < 63
ORDER BY unique1 LIMIT 5; two | unique1 | unique2 | stringu1 -----+---------+---------+----------
! | 61 | 560 | JCAAAA
! | 62 | 633 | KCAAAA
! (2 rows) SELECT ''::text AS three, unique1, unique2, stringu1 FROM onek WHERE unique1 > 100 ORDER
BYunique1 LIMIT 3 OFFSET 20; three | unique1 | unique2 | stringu1 -------+---------+---------+----------
! | 121 | 700 | REAAAA
! | 122 | 519 | SEAAAA
! | 123 | 777 | TEAAAA
! (3 rows) SELECT ''::text AS zero, unique1, unique2, stringu1 FROM onek WHERE unique1 < 50
--- 7,34 ---- ORDER BY unique1 LIMIT 2; two | unique1 | unique2 | stringu1
-----+---------+---------+----------
! (0 rows) SELECT ''::text AS five, unique1, unique2, stringu1 FROM onek WHERE unique1 > 60 ORDER BY
unique1LIMIT 5; five | unique1 | unique2 | stringu1 ------+---------+---------+----------
! (0 rows) SELECT ''::text AS two, unique1, unique2, stringu1 FROM onek WHERE unique1 > 60 AND unique1 < 63
ORDER BY unique1 LIMIT 5; two | unique1 | unique2 | stringu1 -----+---------+---------+----------
! (0 rows) SELECT ''::text AS three, unique1, unique2, stringu1 FROM onek WHERE unique1 > 100 ORDER
BYunique1 LIMIT 3 OFFSET 20; three | unique1 | unique2 | stringu1 -------+---------+---------+----------
! (0 rows) SELECT ''::text AS zero, unique1, unique2, stringu1 FROM onek WHERE unique1 < 50
***************
*** 54,110 **** ORDER BY unique1 DESC LIMIT 20 OFFSET 39; eleven | unique1 | unique2 | stringu1
--------+---------+---------+----------
! | 10 | 520 | KAAAAA
! | 9 | 49 | JAAAAA
! | 8 | 653 | IAAAAA
! | 7 | 647 | HAAAAA
! | 6 | 978 | GAAAAA
! | 5 | 541 | FAAAAA
! | 4 | 833 | EAAAAA
! | 3 | 431 | DAAAAA
! | 2 | 326 | CAAAAA
! | 1 | 214 | BAAAAA
! | 0 | 998 | AAAAAA
! (11 rows) SELECT ''::text AS ten, unique1, unique2, stringu1 FROM onek ORDER BY unique1 OFFSET 990;
ten | unique1 | unique2 | stringu1 -----+---------+---------+----------
! | 990 | 369 | CMAAAA
! | 991 | 426 | DMAAAA
! | 992 | 363 | EMAAAA
! | 993 | 661 | FMAAAA
! | 994 | 695 | GMAAAA
! | 995 | 144 | HMAAAA
! | 996 | 258 | IMAAAA
! | 997 | 21 | JMAAAA
! | 998 | 549 | KMAAAA
! | 999 | 152 | LMAAAA
! (10 rows) SELECT ''::text AS five, unique1, unique2, stringu1 FROM onek ORDER BY unique1 OFFSET 990
LIMIT5; five | unique1 | unique2 | stringu1 ------+---------+---------+----------
! | 990 | 369 | CMAAAA
! | 991 | 426 | DMAAAA
! | 992 | 363 | EMAAAA
! | 993 | 661 | FMAAAA
! | 994 | 695 | GMAAAA
! (5 rows) SELECT ''::text AS five, unique1, unique2, stringu1 FROM onek ORDER BY unique1 LIMIT 5
OFFSET900; five | unique1 | unique2 | stringu1 ------+---------+---------+----------
! | 900 | 913 | QIAAAA
! | 901 | 931 | RIAAAA
! | 902 | 702 | SIAAAA
! | 903 | 641 | TIAAAA
! | 904 | 793 | UIAAAA
! (5 rows)
--- 42,67 ---- ORDER BY unique1 DESC LIMIT 20 OFFSET 39; eleven | unique1 | unique2 | stringu1
--------+---------+---------+----------
! (0 rows) SELECT ''::text AS ten, unique1, unique2, stringu1 FROM onek ORDER BY unique1 OFFSET 990;
ten| unique1 | unique2 | stringu1 -----+---------+---------+----------
! (0 rows) SELECT ''::text AS five, unique1, unique2, stringu1 FROM onek ORDER BY unique1 OFFSET 990
LIMIT5; five | unique1 | unique2 | stringu1 ------+---------+---------+----------
! (0 rows) SELECT ''::text AS five, unique1, unique2, stringu1 FROM onek ORDER BY unique1 LIMIT 5
OFFSET900; five | unique1 | unique2 | stringu1 ------+---------+---------+----------
! (0 rows)
======================================================================
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
pgsql-hackers by date: