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

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

From
Larry Rosenman
Date:
On Mon, 2002-10-28 at 00:09, Larry Rosenman wrote:
Ignore the first one, stupid me forgot about permissions.  

Here is the real one (horology and geometry):
(and I expect horology is due to DST change day). 

LER



*** ./expected/geometry-positive-zeros-bsd.out    Tue Sep 12 16:07:16 2000
--- ./results/geometry.out    Mon Oct 28 00:15:32 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:15:33 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";

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

-- 
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



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

From
Larry Rosenman
Date:
On Mon, 2002-10-28 at 00:20, Larry Rosenman wrote:
> On Mon, 2002-10-28 at 00:09, Larry Rosenman wrote:
> Ignore the first one, stupid me forgot about permissions.  
> 
> Here is the real one (horology and geometry):
> (and I expect horology is due to DST change day). 
The geometry on FreeBSD4.7 MATCHES EXACTLY geometry-bsdi-precision.out. 
$ diff -c ../expected/geometry-bsdi-precision.out geometry.out 
$ 

So, how can we change the resultmap to take the 4.7 stuff into account?



> 
> LER
> 
> 
> 
> *** ./expected/geometry-positive-zeros-bsd.out    Tue Sep 12 16:07:16 2000
> --- ./results/geometry.out    Mon Oct 28 00:15:32 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:15:33 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";
> 
> ======================================================================
> 
> -- 
> 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
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 
-- 
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



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

From
Bruce Momjian
Date:
See the resultmap file in the regression directory.  I see:

geometry/.*-bsdi=geometry-bsdi-precisiongeometry/.*-darwin=geometry-powerpc-darwingeometry/i.86-.*-freebsd=geometry-positive-zeros-bsd
geometry/alpha.*-freebsd=geometry-positive-zerosgeometry/i.86-.*-openbsd=geometry-positive-zeros-bsdgeometry/sparc-.*-openbsd=geometry-positive-zerosgeometry/.*-irix6=geometry-irixgeometry/.*-netbsd=geometry-positive-zerosgeometry/.*-sysv5.*:cc=geometry-uw7-ccgeometry/.*-sysv5.*:gcc=geometry-uw7-gcc


I assume we need to modify the FreeBSD entries.  Once you give me a
string to match your OS, I will rename geometry-bsdi-precision to
something non-OS specific.  I assume we need a string that is 4.7-only.


---------------------------------------------------------------------------

Larry Rosenman wrote:
> On Mon, 2002-10-28 at 00:20, Larry Rosenman wrote:
> > On Mon, 2002-10-28 at 00:09, Larry Rosenman wrote:
> > Ignore the first one, stupid me forgot about permissions.  
> > 
> > Here is the real one (horology and geometry):
> > (and I expect horology is due to DST change day). 
> The geometry on FreeBSD4.7 MATCHES EXACTLY geometry-bsdi-precision.out. 
> $ diff -c ../expected/geometry-bsdi-precision.out geometry.out 
> $ 
> 
> So, how can we change the resultmap to take the 4.7 stuff into account?
> 
> 
> 
> > 
> > LER
> > 
> > 
> > 
> > *** ./expected/geometry-positive-zeros-bsd.out    Tue Sep 12 16:07:16 2000
> > --- ./results/geometry.out    Mon Oct 28 00:15:32 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:15:33 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";
> > 
> > ======================================================================
> > 
> > -- 
> > 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
> > 
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> > 
> > http://archives.postgresql.org
> > 
> -- 
> 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
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


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

From
Larry Rosenman
Date:
On Mon, 2002-10-28 at 21:33, Bruce Momjian wrote:
> 
> See the resultmap file in the regression directory.  I see:
> 
>     geometry/.*-bsdi=geometry-bsdi-precision
>     geometry/.*-darwin=geometry-powerpc-darwin
>     geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd 
>     geometry/alpha.*-freebsd=geometry-positive-zeros
>     geometry/i.86-.*-openbsd=geometry-positive-zeros-bsd
>     geometry/sparc-.*-openbsd=geometry-positive-zeros
>     geometry/.*-irix6=geometry-irix
>     geometry/.*-netbsd=geometry-positive-zeros
>     geometry/.*-sysv5.*:cc=geometry-uw7-cc
>     geometry/.*-sysv5.*:gcc=geometry-uw7-gcc 
> 
> I assume we need to modify the FreeBSD entries.  Once you give me a
> string to match your OS, I will rename geometry-bsdi-precision to
> something non-OS specific.  I assume we need a string that is 4.7-only.
geometry/i.86-.*-freebsd4.7= 

I think...

I don't see where it picks out the release? 

LER

> 
> 
> ---------------------------------------------------------------------------
> 
> Larry Rosenman wrote:
> > On Mon, 2002-10-28 at 00:20, Larry Rosenman wrote:
> > > On Mon, 2002-10-28 at 00:09, Larry Rosenman wrote:
> > > Ignore the first one, stupid me forgot about permissions.  
> > > 
> > > Here is the real one (horology and geometry):
> > > (and I expect horology is due to DST change day). 
> > The geometry on FreeBSD4.7 MATCHES EXACTLY geometry-bsdi-precision.out. 
> > $ diff -c ../expected/geometry-bsdi-precision.out geometry.out 
> > $ 
> > 
> > So, how can we change the resultmap to take the 4.7 stuff into account?
> > 
> > 
> > 
> > > 
> > > LER
> > > 
> > > 
> > > 
> > > *** ./expected/geometry-positive-zeros-bsd.out    Tue Sep 12 16:07:16 2000
> > > --- ./results/geometry.out    Mon Oct 28 00:15:32 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:15:33 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";
> > > 
> > > ======================================================================
> > > 
> > > -- 
> > > 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
> > > 
> > > 
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 6: Have you searched our list archives?
> > > 
> > > http://archives.postgresql.org
> > > 
> > -- 
> > 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
> > 
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
> > 
> 
> -- 
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
-- 
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



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

From
Bruce Momjian
Date:
OK, I just updated CVS to add a freebsd 4.7 entry to use the bsdi
output.  Please update cvs and let me know if it passes now.  Thanks.

---------------------------------------------------------------------------

Larry Rosenman wrote:
> On Mon, 2002-10-28 at 21:33, Bruce Momjian wrote:
> > 
> > See the resultmap file in the regression directory.  I see:
> > 
> >     geometry/.*-bsdi=geometry-bsdi-precision
> >     geometry/.*-darwin=geometry-powerpc-darwin
> >     geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd 
> >     geometry/alpha.*-freebsd=geometry-positive-zeros
> >     geometry/i.86-.*-openbsd=geometry-positive-zeros-bsd
> >     geometry/sparc-.*-openbsd=geometry-positive-zeros
> >     geometry/.*-irix6=geometry-irix
> >     geometry/.*-netbsd=geometry-positive-zeros
> >     geometry/.*-sysv5.*:cc=geometry-uw7-cc
> >     geometry/.*-sysv5.*:gcc=geometry-uw7-gcc 
> > 
> > I assume we need to modify the FreeBSD entries.  Once you give me a
> > string to match your OS, I will rename geometry-bsdi-precision to
> > something non-OS specific.  I assume we need a string that is 4.7-only.
> geometry/i.86-.*-freebsd4.7= 
> 
> I think...
> 
> I don't see where it picks out the release? 
> 
> LER
> 
> > 
> > 
> > ---------------------------------------------------------------------------
> > 
> > Larry Rosenman wrote:
> > > On Mon, 2002-10-28 at 00:20, Larry Rosenman wrote:
> > > > On Mon, 2002-10-28 at 00:09, Larry Rosenman wrote:
> > > > Ignore the first one, stupid me forgot about permissions.  
> > > > 
> > > > Here is the real one (horology and geometry):
> > > > (and I expect horology is due to DST change day). 
> > > The geometry on FreeBSD4.7 MATCHES EXACTLY geometry-bsdi-precision.out. 
> > > $ diff -c ../expected/geometry-bsdi-precision.out geometry.out 
> > > $ 
> > > 
> > > So, how can we change the resultmap to take the 4.7 stuff into account?
> > > 
> > > 
> > > 
> > > > 
> > > > LER
> > > > 
> > > > 
> > > > 
> > > > *** ./expected/geometry-positive-zeros-bsd.out    Tue Sep 12 16:07:16 2000
> > > > --- ./results/geometry.out    Mon Oct 28 00:15:32 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:15:33 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";
> > > > 
> > > > ======================================================================
> > > > 
> > > > -- 
> > > > 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
> > > > 
> > > > 
> > > > ---------------------------(end of broadcast)---------------------------
> > > > TIP 6: Have you searched our list archives?
> > > > 
> > > > http://archives.postgresql.org
> > > > 
> > > -- 
> > > 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
> > > 
> > > 
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 3: if posting/reading through Usenet, please send an appropriate
> > > subscribe-nomail command to majordomo@postgresql.org so that your
> > > message can get through to the mailing list cleanly
> > > 
> > 
> > -- 
> >   Bruce Momjian                        |  http://candle.pha.pa.us
> >   pgman@candle.pha.pa.us               |  (610) 359-1001
> >   +  If your life is a hard drive,     |  13 Roberts Road
> >   +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
> -- 
> 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
> 
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


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

From
Bruce Momjian
Date:
Larry Rosenman wrote:
> On Mon, 2002-10-28 at 21:33, Bruce Momjian wrote:
> > 
> > See the resultmap file in the regression directory.  I see:
> > 
> >     geometry/.*-bsdi=geometry-bsdi-precision
> >     geometry/.*-darwin=geometry-powerpc-darwin
> >     geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd 
> >     geometry/alpha.*-freebsd=geometry-positive-zeros
> >     geometry/i.86-.*-openbsd=geometry-positive-zeros-bsd
> >     geometry/sparc-.*-openbsd=geometry-positive-zeros
> >     geometry/.*-irix6=geometry-irix
> >     geometry/.*-netbsd=geometry-positive-zeros
> >     geometry/.*-sysv5.*:cc=geometry-uw7-cc
> >     geometry/.*-sysv5.*:gcc=geometry-uw7-gcc 
> > 
> > I assume we need to modify the FreeBSD entries.  Once you give me a
> > string to match your OS, I will rename geometry-bsdi-precision to
> > something non-OS specific.  I assume we need a string that is 4.7-only.
> geometry/i.86-.*-freebsd4.7= 
> 
> I think...
> 
> I don't see where it picks out the release? 

resultmap is read by pg_regress.sh.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


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

From
Larry Rosenman
Date:
On Mon, 2002-10-28 at 21:45, Bruce Momjian wrote:
> Larry Rosenman wrote:
> > On Mon, 2002-10-28 at 21:33, Bruce Momjian wrote:
> > > 
> > > See the resultmap file in the regression directory.  I see:
> > > 
> > >     geometry/.*-bsdi=geometry-bsdi-precision
> > >     geometry/.*-darwin=geometry-powerpc-darwin
> > >     geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd 
> > >     geometry/alpha.*-freebsd=geometry-positive-zeros
> > >     geometry/i.86-.*-openbsd=geometry-positive-zeros-bsd
> > >     geometry/sparc-.*-openbsd=geometry-positive-zeros
> > >     geometry/.*-irix6=geometry-irix
> > >     geometry/.*-netbsd=geometry-positive-zeros
> > >     geometry/.*-sysv5.*:cc=geometry-uw7-cc
> > >     geometry/.*-sysv5.*:gcc=geometry-uw7-gcc 
> > > 
> > > I assume we need to modify the FreeBSD entries.  Once you give me a
> > > string to match your OS, I will rename geometry-bsdi-precision to
> > > something non-OS specific.  I assume we need a string that is 4.7-only.
> > geometry/i.86-.*-freebsd4.7= 
> > 
> > I think...
> > 
> > I don't see where it picks out the release? 
> 
> resultmap is read by pg_regress.sh.
I made the following addition:
geometry/i.86-.*-freebsd4.7=geometry-bsdi-precision

(The anon cvs server hasn't updated yet), and we pass geometry.

Still fail horology, but I suspect that's DST change day fubar. 


> 
> -- 
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
-- 
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