Re: Request for supported platforms - Mailing list pgsql-hackers

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@sghms.ac.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/>