Re: [HACKERS] geometry-NetBSD.out patch - Mailing list pgsql-hackers
From | Bruce Momjian |
---|---|
Subject | Re: [HACKERS] geometry-NetBSD.out patch |
Date | |
Msg-id | 199809182147.RAA11848@candle.pha.pa.us Whole thread Raw |
In response to | geometry-NetBSD.out patch (Brook Milligan <brook@trillium.NMSU.Edu>) |
List | 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@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. |
pgsql-hackers by date: