Skip site navigation (1) Skip section navigation (2)

FreeBSD 4.7: BETA3 (from port): regression failures...

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: FreeBSD 4.7: BETA3 (from port): regression failures...
Date: 2002-10-28 06:09:09
Message-ID: 1035785349.450.4.camel@lerlaptop.lerctr.org (view raw or flat)
Thread:
Lists: 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 = Permission denied (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 = No such 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 onek FROM '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data';
  SELECT unique1 FROM 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 onek2 WHERE 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 = Permission denied (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 = No such 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 = No such 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 unique1 LIMIT 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 BY unique1 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 unique1 LIMIT 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 BY unique1 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 LIMIT 5;
   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 OFFSET 900;
   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 LIMIT 5;
   five | unique1 | unique2 | stringu1 
  ------+---------+---------+----------
! (0 rows)
  
  SELECT ''::text AS five, unique1, unique2, stringu1 
  		FROM onek
  		ORDER BY unique1 LIMIT 5 OFFSET 900;
   five | unique1 | unique2 | stringu1 
  ------+---------+---------+----------
! (0 rows)
  

======================================================================

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


Responses

pgsql-hackers by date

Next:From: Larry RosenmanDate: 2002-10-28 06:20:10
Subject: Re: FreeBSD 4.7: BETA3 (from port): regression failures...
Previous:From: Tatsuo IshiiDate: 2002-10-28 06:05:17
Subject: Re: 7.3 beta3 regression failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group