Re: Request for supported platforms

Bruce,

Not sure. I know Tom Lane ran a check on 10.1.x and didn't have any
errors, so I figured the differences I saw reflected changes made by
Apple between 10.1.x and 10.2.x. Then, I was surprised when I saw Adam's
report, so I thought perhaps he was running on a PPC G3 and there were
differences between G3 and G4 floating point handling (I had run the
original regression tests on a PowerBook G4/400 MHz). So, I ran the same
exact scenario on my aging iMac (G3/266 Mhz). Those results corroborated
my original test (geometry failed; horology cleared up, though, as
expected). So, something is different between Adam's system and the two
I have easy access to. I have confirmed that both my systems are running
10.2.1. Similarly, the tests were both run on 7.3b3 from the full
tarball on ftp.us.postgresql.org. The new iMac G3 regression.diffs
output is immediately below. Regardless, it would appear that Mac OS X
10.2.x is well supported.

Tara

*** ./expected/geometry-powerpc-darwin.out Mon Dec 11 11:45:16 2000
--- ./results/geometry.out Tue Oct 29 07:59:59 2002
***************
*** 127,133 ****
| (-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)
--- 127,133 ----
| (-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.3864610140473)
| (-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)

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

Bruce Momjian wrote:

> Strange. I just got report from another OSX 10.2.1 user saying
> regression tests passed:
>
> 10.2.1, Adam Witney (awitney(at)sghms(dot)ac(dot)uk>
>
> The proper value seems to be:
>
> 15.3864610140472
>
> or
>
> 15.3864610140473
>
> in ./expected/geometry-powerpc-darwin.out. Which is it, folks?
>
> ---------------------------------------------------------------------------
>
> Tara Piorkowski wrote:
>
> >Tom Lane wrote:
> >
> >
> >>Bruce Momjian writes:
> >>
> >>
> >>>Folks. start sending in those plaform reports, OS name and version
> >>>number please.
> >>
> >>
> >>I've checked CVS tip on:
> >> HPUX 10.20, using both gcc and vendor's cc
> >> PPC Linux
> >> Mac OS X 10.1
> >
> >
> >Here's the regression.diffs file from Mac OS X 10.2.1 (Jaguar). It
> >failed geometry (rounding) and horology (not sure). gcc -v returns
> >"Apple Computer, Inc. GCC version 1161, based on gcc version 3.1
> >20020420 (prerelease)".
> >
> >
> >*** ./expected/geometry-powerpc-darwin.out Mon Dec 11 11:45:16 2000
> >--- ./results/geometry.out Sun Oct 27 21:27:11 2002
> >***************
> >*** 127,133 ****
> > | (-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)
> >--- 127,133 ----
> > | (-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.3864610140473)
> > | (-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)
> >
> >======================================================================
> >
> >*** ./expected/horology.out Wed Sep 18 17:35:25 2002
> >--- ./results/horology.out Sun Oct 27 21:27:12 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";
> >
> >======================================================================

--
Tara Piorkowski
System Administrator, vilaj.com, LLC
<http://www.vilaj.com/>