Re: [HACKERS] geometry-NetBSD.out patch

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: brook(at)trillium(dot)NMSU(dot)Edu (Brook Milligan)
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] geometry-NetBSD.out patch
Date: 1998-09-18 21:47:29
Message-ID: 199809182147.RAA11848@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

APplied.

> The following is a patch to bring the geometry regression test in line
> with current (1.3.2/i386) NetBSD output. I didn't see any differences
> from the current "normal" expectation that were other than roundoff
> errors, so I think the differences are irrelevant.
>
> Cheers,
> Brook
>
> ===========================================================================
> --- test/regress/expected/geometry-NetBSD.out.orig Sun Mar 22 12:46:33 1998
> +++ test/regress/expected/geometry-NetBSD.out Wed Sep 16 09:51:55 1998
> @@ -87,43 +87,42 @@
>
> QUERY: SELECT '' AS count, p.f1, l.s, l.s # p.f1 AS intersection
> FROM LSEG_TBL l, POINT_TBL p;
> -ERROR: There is no operator '#' for types 'lseg' and 'point'
> - You will either have to retype this query using an explicit cast,
> - or you will have to define the operator using CREATE OPERATOR
> +ERROR: There is more than one possible operator '#' for types 'lseg' and 'point'
> + You will have to retype this query using an explicit cast
> QUERY: SELECT '' AS thirty, p.f1, l.s, p.f1 ## l.s AS closest
> FROM LSEG_TBL l, POINT_TBL p;
> -thirty|f1 |s |closest
> -------+----------+-----------------------------+------------------------------------
> - |(0,0) |[(1,2),(3,4)] |(1,2)
> - |(-10,0) |[(1,2),(3,4)] |(1,2)
> - |(-3,4) |[(1,2),(3,4)] |(1,2)
> - |(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,0)
> - |(5.1,34.5)|[(0,0),(6,6)] |(6,6)
> - |(-5,-12) |[(0,0),(6,6)] |(0,0)
> - |(10,10) |[(0,0),(6,6)] |(6,6)
> - |(0,0) |[(10,-10),(-3,-4)] |(-3,-4)
> - |(-10,0) |[(10,-10),(-3,-4)] |(-3,-4)
> - |(-3,4) |[(10,-10),(-3,-4)] |(-3,-4)
> - |(5.1,34.5)|[(10,-10),(-3,-4)] |(-3,-4)
> - |(-5,-12) |[(10,-10),(-3,-4)] |(-3,-4)
> - |(10,10) |[(10,-10),(-3,-4)] |(-3,-4)
> - |(0,0) |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264)
> - |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472)
> - |(-3,4) |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303)
> - |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925)
> - |(-5,-12) |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616)
> - |(10,10) |[(-1000000,200),(300000,-40)]|(10.000993741978,15.3827690473092)
> - |(0,0) |[(11,22),(33,44)] |(11,22)
> - |(-10,0) |[(11,22),(33,44)] |(11,22)
> - |(-3,4) |[(11,22),(33,44)] |(11,22)
> - |(5.1,34.5)|[(11,22),(33,44)] |(11,22)
> - |(-5,-12) |[(11,22),(33,44)] |(11,22)
> - |(10,10) |[(11,22),(33,44)] |(11,22)
> +thirty|f1 |s |closest
> +------+----------+-----------------------------+-------------------------------------
> + |(0,0) |[(1,2),(3,4)] |(1,2)
> + |(-10,0) |[(1,2),(3,4)] |(1,2)
> + |(-3,4) |[(1,2),(3,4)] |(1,2)
> + |(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)
> + |(-5,-12) |[(0,0),(6,6)] |(0,0)
> + |(10,10) |[(0,0),(6,6)] |(6,6)
> + |(0,0) |[(10,-10),(-3,-4)] |(-2.04878048780488,-4.4390243902439)
> + |(-10,0) |[(10,-10),(-3,-4)] |(-3,-4)
> + |(-3,4) |[(10,-10),(-3,-4)] |(-3,-4)
> + |(5.1,34.5)|[(10,-10),(-3,-4)] |(-3,-4)
> + |(-5,-12) |[(10,-10),(-3,-4)] |(-1.60487804878049,-4.64390243902439)
> + |(10,10) |[(10,-10),(-3,-4)] |(2.39024390243902,-6.48780487804878)
> + |(0,0) |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264)
> + |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472)
> + |(-3,4) |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303)
> + |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925)
> + |(-5,-12) |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616)
> + |(10,10) |[(-1000000,200),(300000,-40)]|(10.000993741978,15.3827690473092)
> + |(0,0) |[(11,22),(33,44)] |(11,22)
> + |(-10,0) |[(11,22),(33,44)] |(11,22)
> + |(-3,4) |[(11,22),(33,44)] |(11,22)
> + |(5.1,34.5)|[(11,22),(33,44)] |(14.3,25.3)
> + |(-5,-12) |[(11,22),(33,44)] |(11,22)
> + |(10,10) |[(11,22),(33,44)] |(11,22)
> (30 rows)
>
> QUERY: SELECT '' as six, box(f1) AS box FROM CIRCLE_TBL;
>
>

--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
http://www.op.net/~candle | (610) 353-9879(w)
+ If your life is a hard drive, | (610) 853-3000(h)
+ Christ can be your backup. |

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David Gould 1998-09-19 00:06:00 Re: [HACKERS] Compiling 6.4 on NetBSD-current/pc532
Previous Message Jon Buller 1998-09-18 21:20:02 Re: [HACKERS] Compiling 6.4 on NetBSD-current/pc532