geometry-NetBSD.out patch
Started by Brook Milliganover 27 years ago2 messageshackers
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;
Re: [HACKERS] geometry-NetBSD.out patch
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@candle.pha.pa.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. |