Thread: Call for platform testing

Call for platform testing

From
Thomas Lockhart
Date:
I have not recorded successful tests for the following platforms (I've
included the names of folks who reported for the last release, in case
they are still able to test or want to hand it off to someone else):

AIX          Gilles Darold
BeOS         Cyril Velter
HPUX         (have 10.20 from Tom; anyone tested 11.0 or higher?)
IRIX         Robert Bruccoleri
Linux/arm    Mark Knox
Linux/s390   Neale Ferguson
Linux/sparc  Ryan Kirkpatrick
NetBSD/arm32 Patrick Welche
NetBSD/m68k  Henry Hotz (not tested since 7.0; obsolete platform?)
NetBSD/PPC   Henry Hotz
NetBSD/VAX   Tom I. Helbekkmo
NetBSD/x86   Giles Lean
QNX          (did I get a definitive report for 4.x already?)
SCO Unixware Larry Rosenman
Solaris/x86  Mathijs Brands
SunOS        Tatsuo Ishii (old release; still relevant?)
Windows/Cygwin Jason Tishler
Windows/native Magnus Hagander (clients only)


The following platforms have been reported as successfully running
PostgreSQL 7.2:

BSD/OS       Bruce
FreeBSD      Chris Kings-Lynne
Linux/Alpha  Tom
Linux/MIPS   Hisao Shibuya
Linux/PPC    Tom
Linux/x86    Thomas (and many others ;)
MacOS-X      Tom
NetBSD/Alpha Thomas Thai
OpenBSD/sparc Brandon Palmer
OpenBSD/x86  Brandon Palmer
Solaris/sparc Andrew Sullivan
Tru64        Alessio Bragadini (anyone tested 5.0 or higher?)


Have I missed any success reports? Have I left out any platforms known
to be good or bad (or which *should* be reported)? Sorry if I've missed
anything; over time there is a lot flying around for which I'm not sure
the result (AIX and QNX come to mind for examples).
                       - Thomas


Re: Call for platform testing

From
Bruce Momjian
Date:
> Have I missed any success reports? Have I left out any platforms known
> to be good or bad (or which *should* be reported)? Sorry if I've missed
> anything; over time there is a lot flying around for which I'm not sure
> the result (AIX and QNX come to mind for examples).

QNX6 will fail in 7.2.X.  We have patches for 7.3.  I believe AIX is
fine thanks to work done a few weeks ago by Tatuso and others.  However,
I am not totally sure.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


Re: Call for platform testing

From
Tatsuo Ishii
Date:
> QNX6 will fail in 7.2.X.  We have patches for 7.3.  I believe AIX is
> fine thanks to work done a few weeks ago by Tatuso and others.  However,
> I am not totally sure.

I have been troubled by 7.2b3/AIX 5L combo. The parallel regression
test hangs in the middle of the test. It seems backend goes into an
idle state and it happens nothing after that.

I have been on a business trip till this week end. I will start to dig
into more next week.
--
Tatsuo Ishii


Re: Call for platform testing

From
"Zeugswetter Andreas SB SD"
Date:
> QNX6 will fail in 7.2.X.  We have patches for 7.3.  I believe AIX is
> fine thanks to work done a few weeks ago by Tatuso and others.
However,
> I am not totally sure.

7.2b3 passes "make check" on AIX 4.3 with both xlc and gcc.
1 Rounding difference (last digit) and 3 0 vs -0 in the geometry tests 
when using gcc (both gcc and xlc show -0s, only different ones).

The PG_FUNCTION_INFO_V1 macro produces an annoying warning, that I
cannot 
interpret:

xlc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong  -DREFINT_VERBOSE -I.
-I../../src/include -I/us
r/local/include  -c -o autoinc.o autoinc.c       8 | extern Pg_finfo_record * pg_finfo_autoinc (void);
Pg_finfo_record * pg_finfo_a
utoinc (void) { static Pg_finfo_record my_finfo = { 1 }; return
&my_finfo; };
........................................................................
......
........................................................................
....a
a - 1506-137 (E) Declaration must declare at least one declarator, tag,
or the members of
an enumeration.

Andreas


Re: Call for platform testing

From
Larry Rosenman
Date:
I've upgraded to OpenUNIX 8, and all is well.  

It probably passes on UW 7 as well, but I can no longer test it. 

LER

* Thomas Lockhart <lockhart@fourpalms.org> [011127 23:06]:
> I have not recorded successful tests for the following platforms (I've
> included the names of folks who reported for the last release, in case
> they are still able to test or want to hand it off to someone else):
> 
> AIX          Gilles Darold
> BeOS         Cyril Velter
> HPUX         (have 10.20 from Tom; anyone tested 11.0 or higher?)
> IRIX         Robert Bruccoleri
> Linux/arm    Mark Knox
> Linux/s390   Neale Ferguson
> Linux/sparc  Ryan Kirkpatrick
> NetBSD/arm32 Patrick Welche
> NetBSD/m68k  Henry Hotz (not tested since 7.0; obsolete platform?)
> NetBSD/PPC   Henry Hotz
> NetBSD/VAX   Tom I. Helbekkmo
> NetBSD/x86   Giles Lean
> QNX          (did I get a definitive report for 4.x already?)
> SCO Unixware Larry Rosenman
> Solaris/x86  Mathijs Brands
> SunOS        Tatsuo Ishii (old release; still relevant?)
> Windows/Cygwin Jason Tishler
> Windows/native Magnus Hagander (clients only)
> 
> 
> The following platforms have been reported as successfully running
> PostgreSQL 7.2:
> 
> BSD/OS       Bruce
> FreeBSD      Chris Kings-Lynne
> Linux/Alpha  Tom
> Linux/MIPS   Hisao Shibuya
> Linux/PPC    Tom
> Linux/x86    Thomas (and many others ;)
> MacOS-X      Tom
> NetBSD/Alpha Thomas Thai
> OpenBSD/sparc Brandon Palmer
> OpenBSD/x86  Brandon Palmer
> Solaris/sparc Andrew Sullivan
> Tru64        Alessio Bragadini (anyone tested 5.0 or higher?)
> 
> 
> Have I missed any success reports? Have I left out any platforms known
> to be good or bad (or which *should* be reported)? Sorry if I've missed
> anything; over time there is a lot flying around for which I'm not sure
> the result (AIX and QNX come to mind for examples).
> 
>                         - Thomas
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


Re: Call for platform testing

From
Thomas Lockhart
Date:
> I've upgraded to OpenUNIX 8, and all is well.
> It probably passes on UW 7 as well, but I can no longer test it.

I'm not familiar with SCO products. Is OU 8 the successor to UW 7, or is
it a different product line? Do I need two entries in the list? I'm
still not clear on the differences between that and OpenServer 5 (other
than version of course) and whether that should (still) be listed as
"untested and possibly unsupported".

Hmm. Looking at Caldera's web site, it lists all three as separate
products :(

If these product lines are feature-compatible, could we just list "SCO"
as supported, and in the comments mention "tested on OpenUnix 8"?

Anyone else running other variants of SCO?
                       - Thomas


Re: Call for platform testing

From
Thomas Lockhart
Date:
> 7.2b3 passes "make check" on AIX 4.3 with both xlc and gcc.
> 1 Rounding difference (last digit) and 3 0 vs -0 in the geometry tests
> when using gcc (both gcc and xlc show -0s, only different ones).

Thanks Andreas. Tatsuo is continuing testing on AIX 5.x, so I'll
continue to list 4.3 as supported for now.
                      - Thomas


Re: Call for platform testing

From
Thomas Lockhart
Date:
> MacOS 10.1.1 passes.

Thanks Gavin!
                         - Thomas

> ======================
>  All 79 tests passed.
> ======================
> 
> [localhost:~/postgresql-7.2b3] swm% uname -a
> Darwin localhost 5.1 Darwin Kernel Version 5.1: Tue Oct 30 00:06:34 PST
> 2001; root:xnu/xnu-201.5.obj~1/RELEASE_PPC  Power Macintosh powerpc


Re: Call for platform testing

From
Larry Rosenman
Date:
* Thomas Lockhart <lockhart@fourpalms.org> [011128 08:28]:
> > I've upgraded to OpenUNIX 8, and all is well.
> > It probably passes on UW 7 as well, but I can no longer test it.
> 
> I'm not familiar with SCO products. Is OU 8 the successor to UW 7, or is
> it a different product line? Do I need two entries in the list? I'm
> still not clear on the differences between that and OpenServer 5 (other
> than version of course) and whether that should (still) be listed as
> "untested and possibly unsupported".
OU8 is UW 7 + LKP (Linux Kernel Personality) + Bug Fixes.

OSR5 is the old Sco 3.2 stuff, and is a totally different
beast/codeset.


> 
> Hmm. Looking at Caldera's web site, it lists all three as separate
> products :(
> 
> If these product lines are feature-compatible, could we just list "SCO"
> as supported, and in the comments mention "tested on OpenUnix 8"?
I would POSSIBLY combine OU8 and UW7, but NOT OSR5. 
> 
> Anyone else running other variants of SCO?
> 
>                         - Thomas

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


Re: Call for platform testing

From
Mathijs Brands
Date:
On Wed, Nov 28, 2001 at 05:01:08AM +0000, Thomas Lockhart allegedly wrote:
> Solaris/x86  Mathijs Brands

Unfortunately I don't have a Solaris/x86 development box anymore :(

Cheers,

Mathijs


Re: Call for platform testing

From
Tom Lane
Date:
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at> writes:
> The PG_FUNCTION_INFO_V1 macro produces an annoying warning, that I
> cannot interpret:

> xlc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong  -DREFINT_VERBOSE -I.
> -I../../src/include -I/usr/local/include  -c -o autoinc.o autoinc.c
>         8 | extern Pg_finfo_record * pg_finfo_autoinc (void);
> Pg_finfo_record * pg_finfo_a
> utoinc (void) { static Pg_finfo_record my_finfo = { 1 }; return
> &my_finfo; };
> ........................................................................
> ......
> ........................................................................
> ....a
> a - 1506-137 (E) Declaration must declare at least one declarator, tag,
> or the members of
> an enumeration.

It's not so much the macro as the semicolon after it.  I get "Empty
declaration" warnings from HP's cc for those lines myself.  Kind of
annoying, but not writing the semicolon in the source sounds uglier.

Is it worth adding a dummy declaration to the macro just to shut up
these compilers?  We could probably make the macro produce bogus
extern declarations, say PG_FUNCTION_INFO_V1(foo) produces

extern Pg_finfo_record * pg_finfo_foo (void);
Pg_finfo_record * pg_finfo_foo (void)
{ static Pg_finfo_record my_finfo = { 1 }; return &my_finfo;
}
extern int pg_finfo_foo_dummy

which would satisfy even the most pedantic compiler ... unless it
chose to warn about unreferenced extern declarations, but I don't
think any do.
        regards, tom lane


Re: Call for platform testing

From
Thomas Lockhart
Date:
> OU8 is UW 7 + LKP (Linux Kernel Personality) + Bug Fixes.

OK, I'll just do one entry for both UW and OU. Love those name changes
:(

> OSR5 is the old Sco 3.2 stuff, and is a totally different
> beast/codeset.

Maybe I'll just remove mention of it altogether. Either it is
supportable because it is Unix-y and somewhat compatible with other SCO
products, or it isn't, but it isn't worth guessing at either way unless
someone can test it.
                      - Thomas


Re: Call for platform testing

From
Horak Daniel
Date:
> Windows/Cygwin Jason Tishler

Only the "privileges" test failed when running "serial_schedule". When
running "parallel_schedule" there are random failures with errors
"cannot access some file with a table/index/...". So I think that
PostgreSQL is OK, but the Cygwin/Windows layer is not. We should try to
find what's wrong when multiple backends are running.

system:
CYGWIN_NT-5.0 CERT 1.3.5(0.47/3/2) 2001-11-13 23:16 i686 unknown

with cygipc 1.11

        Dan


Re: Call for platform testing

From
Luis Amigo
Date:
>

Regression test on Irix 6.5.13 installed with MIPSPro 7.30

=======================2 of 79 tests failed.
=======================
geometry and join

*** ./expected/geometry-irix.out    Wed Oct 11 06:55:58 2000
--- ./results/geometry.out    Wed Nov 28 17:55:25 2001
***************
*** 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)
 
--- 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)
 
***************
*** 443,452 ****    FROM CIRCLE_TBL;  six |
                                                                                                             polygon


-----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
!      |
((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359017709e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718035418e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138139,-1.49999999995138))
    |
((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983794))
    |
((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887967),(-3.33012701896897,0.500000000081028))
!      |
((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.59807621137373),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138139,0.500000000048617))
    |
((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
    |
((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983794))
(6rows)
 
--- 443,452 ----    FROM CIRCLE_TBL;  six |
                                                                                                             polygon


-----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
!      |
((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359017709e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718035418e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138))
    |
((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983794))
    |
((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887967),(-3.33012701896897,0.500000000081028))
!      |
((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.59807621137373),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048617))
    |
((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
    |
((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983794))
(6rows)
 
***************
*** 459,465 ****      |
((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359017709e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718035418e-11),(2.12132034353258,-2.12132034358671),(-4.59307077053127e-11,-3),(-2.12132034359753,-2.12132034352175))
    |
((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.7106781191961,72.7106781181135),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917))
    |
((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))
!      |
((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586708),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))
    |
((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))
    |
((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
(6rows)
 
--- 459,465 ----      |
((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359017709e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718035418e-11),(2.12132034353258,-2.12132034358671),(-4.59307077053127e-11,-3),(-2.12132034359753,-2.12132034352175))
    |
((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.7106781191961,72.7106781181135),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917))
    |
((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))
!      |
((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))
    |
((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))
    |
((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
(6rows)
 

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

*** ./expected/join.out    Thu Dec 14 23:30:45 2000
--- ./results/join.out    Wed Nov 28 17:57:11 2001
***************
*** 1731,1738 ****      | 6 | 6 | six   |         | 7 | 7 | seven |         | 8 | 8 | eight |   
-      |   |   | null  |         |   | 0 | zero  |    (13 rows)  SELECT '' AS "xxx", *
--- 1731,1738 ----      | 6 | 6 | six   |         | 7 | 7 | seven |         | 8 | 8 | eight |         |   | 0 | zero  |
 
 
+      |   |   | null  |    (13 rows)  SELECT '' AS "xxx", *
***************
*** 1750,1757 ****      | 6 | 6 | six   |         | 7 | 7 | seven |         | 8 | 8 | eight |   
-      |   |   | null  |         |   | 0 | zero  |    (13 rows)  SELECT '' AS "xxx", *
--- 1750,1757 ----      | 6 | 6 | six   |         | 7 | 7 | seven |         | 8 | 8 | eight |         |   | 0 | zero  |
 
 
+      |   |   | null  |    (13 rows)  SELECT '' AS "xxx", *
***************
*** 1799,1806 ****      | 6 | 6 | six   |         | 7 | 7 | seven |         | 8 | 8 | eight |   
-      |   |   | null  |         |   | 0 | zero  |         |   |   |       |         |   |   |       |  0 (15 rows)
--- 1799,1806 ----      | 6 | 6 | six   |         | 7 | 7 | seven |         | 8 | 8 | eight |         |   | 0 | zero  |
 
 
+      |   |   | null  |         |   |   |       |         |   |   |       |  0 (15 rows)
***************
*** 1820,1827 ****      | 6 | 6 | six   |         | 7 | 7 | seven |         | 8 | 8 | eight |   
-      |   |   | null  |         |   | 0 | zero  |         |   |   |       |         |   |   |       |  0 (15 rows)
--- 1820,1827 ----      | 6 | 6 | six   |         | 7 | 7 | seven |         | 8 | 8 | eight |         |   | 0 | zero  |
 
 
+      |   |   | null  |         |   |   |       |         |   |   |       |  0 (15 rows)

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


Re: Call for platform testing

From
Luis Amigo
Date:
regression test on irix 6.5.12 with MIPSpro Compilers: Version 7.3.1.2m
(this platform is 8-r10000 ip25 processors, previous is 8 -r12000 ip35 processors)

=======================
 2 of 79 tests failed.
=======================
again join and geometry(it also failed in postgres 7.1.3)

*** ./expected/geometry-irix.out    Wed Oct 11 06:55:58 2000
--- ./results/geometry.out    Wed Nov 28 17:55:25 2001
***************
*** 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)
--- 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)
***************
*** 443,452 ****
     FROM CIRCLE_TBL;
   six |
                                                                          polygon

                           

-----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
!      |
((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359017709e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718035418e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138139,-1.49999999995138))
       |
((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983794))
       |
((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887967),(-3.33012701896897,0.500000000081028))
!      |
((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.59807621137373),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138139,0.500000000048617))
       |
((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
       |
((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983794))
  (6 rows)
--- 443,452 ----
     FROM CIRCLE_TBL;
   six |
                                                                          polygon

                           

-----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
!      |
((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359017709e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718035418e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138))
       |
((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983794))
       |
((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887967),(-3.33012701896897,0.500000000081028))
!      |
((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.59807621137373),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048617))
       |
((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
       |
((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983794))
  (6 rows)
***************
*** 459,465 ****
       |
((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359017709e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718035418e-11),(2.12132034353258,-2.12132034358671),(-4.59307077053127e-11,-3),(-2.12132034359753,-2.12132034352175))
       |
((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.7106781191961,72.7106781181135),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917))
       |
((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))
!      |
((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586708),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))
       |
((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))
       |
((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
  (6 rows)
--- 459,465 ----
       |
((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359017709e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718035418e-11),(2.12132034353258,-2.12132034358671),(-4.59307077053127e-11,-3),(-2.12132034359753,-2.12132034352175))
       |
((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.7106781191961,72.7106781181135),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917))
       |
((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))
!      |
((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))
       |
((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))
       |
((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
  (6 rows)

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

*** ./expected/join.out    Thu Dec 14 23:30:45 2000
--- ./results/join.out    Wed Nov 28 17:57:11 2001
***************
*** 1731,1738 ****
       | 6 | 6 | six   |
       | 7 | 7 | seven |
       | 8 | 8 | eight |
-      |   |   | null  |
       |   | 0 | zero  |
  (13 rows)

  SELECT '' AS "xxx", *
--- 1731,1738 ----
       | 6 | 6 | six   |
       | 7 | 7 | seven |
       | 8 | 8 | eight |
       |   | 0 | zero  |
+      |   |   | null  |
  (13 rows)

  SELECT '' AS "xxx", *
***************
*** 1750,1757 ****
       | 6 | 6 | six   |
       | 7 | 7 | seven |
       | 8 | 8 | eight |
-      |   |   | null  |
       |   | 0 | zero  |
  (13 rows)

  SELECT '' AS "xxx", *
--- 1750,1757 ----
       | 6 | 6 | six   |
       | 7 | 7 | seven |
       | 8 | 8 | eight |
       |   | 0 | zero  |
+      |   |   | null  |
  (13 rows)

  SELECT '' AS "xxx", *
***************
*** 1799,1806 ****
       | 6 | 6 | six   |
       | 7 | 7 | seven |
       | 8 | 8 | eight |
-      |   |   | null  |
       |   | 0 | zero  |
       |   |   |       |
       |   |   |       |  0
  (15 rows)
--- 1799,1806 ----
       | 6 | 6 | six   |
       | 7 | 7 | seven |
       | 8 | 8 | eight |
       |   | 0 | zero  |
+      |   |   | null  |
       |   |   |       |
       |   |   |       |  0
  (15 rows)
***************
*** 1820,1827 ****
       | 6 | 6 | six   |
       | 7 | 7 | seven |
       | 8 | 8 | eight |
-      |   |   | null  |
       |   | 0 | zero  |
       |   |   |       |
       |   |   |       |  0
  (15 rows)
--- 1820,1827 ----
       | 6 | 6 | six   |
       | 7 | 7 | seven |
       | 8 | 8 | eight |
       |   | 0 | zero  |
+      |   |   | null  |
       |   |   |       |
       |   |   |       |  0
  (15 rows)

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


Re: Call for platform testing

From
Doug McNaught
Date:
7.2b3 compiles and passes all tests on Linux/Sparc64.  I updated the
regression test database. 

-Doug
-- 
Let us cross over the river, and rest under the shade of the trees.  --T. J. Jackson, 1863



Re: Call for platform testing

From
Tom Lane
Date:
Luis Amigo <lamigo@atc.unican.es> writes:
> again join and geometry(it also failed in postgres 7.1.3)

The join discrepancy is probably an artifact of your local qsort()
behaving slightly differently for equal keys than everyone else's.
Curious that it only affects these few queries, though.

Geometry differences in the low-order digits are par for the course.
I wouldn't even stop to think about it, except that I see that you
are already using a platform-specific geometry comparison file
(geometry-irix.out).  Some digging in the CVS logs and mail archives
shows that that file was submitted by Pete Forman in Oct 2000, and
he was using 

>   Architecture (example: Intel Pentium)  : SGI MIPS 8000
>
>   Operating System (example: Linux 2.0.26 ELF) : IRIX 6.5.5m
>
>   PostgreSQL version (example: PostgreSQL-7.1):   PostgreSQL-7.1
>
>   Compiler used (example:  gcc 2.8.0): MIPSPro 7.3

Not clear at this point if the differences in your results are due to
hardware, library version, or compiler version differences.
        regards, tom lane


Re: Call for platform testing

From
Luis Amigo
Date:
Tom Lane wrote:

> Luis Amigo <lamigo@atc.unican.es> writes:
> > again join and geometry(it also failed in postgres 7.1.3)
>
> The join discrepancy is probably an artifact of your local qsort()
> behaving slightly differently for equal keys than everyone else's.
> Curious that it only affects these few queries, though.
>
> Geometry differences in the low-order digits are par for the course.
> I wouldn't even stop to think about it, except that I see that you
> are already using a platform-specific geometry comparison file
> (geometry-irix.out).  Some digging in the CVS logs and mail archives
> shows that that file was submitted by Pete Forman in Oct 2000, and
> he was using
>
> >   Architecture (example: Intel Pentium)  : SGI MIPS 8000
> >
> >   Operating System (example: Linux 2.0.26 ELF) : IRIX 6.5.5m
> >
> >   PostgreSQL version (example: PostgreSQL-7.1):   PostgreSQL-7.1
> >
> >   Compiler used (example:  gcc 2.8.0): MIPSPro 7.3
>
> Not clear at this point if the differences in your results are due to
> hardware, library version, or compiler version differences.
>
>                         regards, tom lane

I've reviewed the results,  join differences seem to be conceptual
differences, expected result gives higher value to NULL that 0
(personally I think 0 is bigger than NULL).
Geometry differences are architectural round up differences (I think
that MIPS 10000  and 12000 may have corrected previous errors or might
be a different point-of-view about rounding)




Re: Call for platform testing

From
Bruce Momjian
Date:
> > OU8 is UW 7 + LKP (Linux Kernel Personality) + Bug Fixes.
> 
> OK, I'll just do one entry for both UW and OU. Love those name changes
> :(

If the first name doesn't succeed, try, try again.  :-)

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


Re: Call for platform testing

From
Thomas Lockhart
Date:
> regression test on irix 6.5.12 with MIPSpro Compilers: Version 7.3.1.2m
> (this platform is 8-r10000 ip25 processors, previous is 8 -r12000 ip35 processors)
> 
> =======================
>  2 of 79 tests failed.
> =======================
> again join and geometry(it also failed in postgres 7.1.3)

Got both reports. Counts as good from my pov...

Thanks!
                    - Thomas


Re: Call for platform testing

From
Thomas Lockhart
Date:
OK, the list is getting smaller fast (thanks for all of the responses!).
Here is what I have left currently (note the addition of NetBSD/sparc,
which I had inadvertently omitted from the first list):

BeOS         Cyril Velter
Linux/arm    Mark Knox
Linux/s390   Neale Ferguson
NetBSD/arm32 Patrick Welche
NetBSD/m68k  Bill Studenmund (will test)
NetBSD/sparc Matthew Green (left off the first list)
NetBSD/VAX   Tom I. Helbekkmo
QNX          (did I get a definitive report for 4.x already?)
SunOS        Tatsuo Ishii (old release; still relevant?)
Windows/Cygwin Daniel Horak (OK in serial test, trouble with parallel
test?)
Windows/native Magnus Hagander (clients only)

I'm curious about the Windows/Cygwin trouble, and if others see it too,
since the -cygwin mailing list seems to report happiness with 7.1.3.

Tatsuo, do you think that we should still track SunOS explicitly?

Are there any other platforms we are running on?
                      - Thomas


The following platforms have been reported as successfully running
PostgreSQL 7.2:

AIX          Andreas Zeugswetter (Tatsuo working on 5L?)
BSD/OS       Bruce
FreeBSD      Chris Kings-Lynne
HPUX         Tom (anyone tested 11.0 or higher?)
IRIX         Luis Amigo
Linux/Alpha  Tom
Linux/MIPS   Hisao Shibuya
Linux/PPC    Tom
Linux/sparc  Doug McNaught
Linux/x86    Thomas (and many others ;)
MacOS-X      Gavin Sherry
NetBSD/Alpha Thomas Thai
NetBSD/PPC   Bill Studenmund
NetBSD/x86   Bill Studenmund
OpenBSD/sparc Brandon Palmer
OpenBSD/x86  Brandon Palmer
SCO OpenUnix Larry Rosenman
Solaris/sparc Andrew Sullivan
Solaris/x86  Martin Renters
Tru64        Alessio Bragadini (trouble with 5.1?)


Re: Call for platform testing

From
Luis Amigo
Date:
Thomas Lockhart wrote:

> > regression test on irix 6.5.12 with MIPSpro Compilers: Version 7.3.1.2m
> > (this platform is 8-r10000 ip25 processors, previous is 8 -r12000 ip35 processors)
> >
> > =======================
> >  2 of 79 tests failed.
> > =======================
> > again join and geometry(it also failed in postgres 7.1.3)
>
> Got both reports. Counts as good from my pov...
>
> Thanks!
>
>                      - Thomas

I also count them as good but I think that someone may change expected, cause two
platforms with different OS, architecture and compilers are giving same result.



Re: Call for platform testing

From
Peter Eisentraut
Date:
Thomas Lockhart writes:

> > OSR5 is the old Sco 3.2 stuff, and is a totally different
> > beast/codeset.
>
> Maybe I'll just remove mention of it altogether. Either it is
> supportable because it is Unix-y and somewhat compatible with other SCO
> products, or it isn't, but it isn't worth guessing at either way unless
> someone can test it.

This seems to be a little drastic, just because one company ships two
separate products and everyone is confused about why they would do that.
Quite a few people do use OpenServer (successfully, after a few patches
against 7.1 which made it into 7.2), but if no one ends up submitting a
test result it will simply stay in the unsupported area.

-- 
Peter Eisentraut   peter_e@gmx.net



Re: Call for platform testing

From
Luis Amigo
Date:
Tom Lane wrote:

> Luis Amigo <lamigo@atc.unican.es> writes:
> > again join and geometry(it also failed in postgres 7.1.3)
>
> The join discrepancy is probably an artifact of your local qsort()
> behaving slightly differently for equal keys than everyone else's.
> Curious that it only affects these few queries, though.
>
> Geometry differences in the low-order digits are par for the course.
> I wouldn't even stop to think about it, except that I see that you
> are already using a platform-specific geometry comparison file
> (geometry-irix.out).  Some digging in the CVS logs and mail archives
> shows that that file was submitted by Pete Forman in Oct 2000, and
> he was using
>
> >   Architecture (example: Intel Pentium)  : SGI MIPS 8000
> >
> >   Operating System (example: Linux 2.0.26 ELF) : IRIX 6.5.5m
> >
> >   PostgreSQL version (example: PostgreSQL-7.1):   PostgreSQL-7.1
> >
> >   Compiler used (example:  gcc 2.8.0): MIPSPro 7.3
>
> Not clear at this point if the differences in your results are due to
> hardware, library version, or compiler version differences.
>
>                         regards, tom lane

I've been searching for info that could explain round-up difference in
geometry.
I believe i've found a reasonable explanation, there is a architecture
disroupt between old MIPS3 FPUs
and newer MIPS4 FPUs.(so I'm almost sure that is the explanation).
I would like to know if is there anyone else running on IRIX, so we can
discuss these  and other results
from another point of view.
Thanks for all your heavy working.
best wishes.



Re: Call for platform testing

From
Tom Lane
Date:
Luis Amigo <lamigo@atc.unican.es> writes:
> I've been searching for info that could explain round-up difference in
> geometry.
> I believe i've found a reasonable explanation, there is a architecture
> disroupt between old MIPS3 FPUs
> and newer MIPS4 FPUs.(so I'm almost sure that is the explanation).
> I would like to know if is there anyone else running on IRIX, so we can
> discuss these  and other results from another point of view.

I sent mail earlier to Pete Forman, who submitted the existing
geometry-irix comparison file.  He hasn't responded yet.

If Pete's lost interest then I'd be willing to adopt your results as
the standard geometry-irix file.  If he's still interested then we'd
need to figure out a way for the resultmap mechanism to distinguish
older and newer MIPS hardware in order to accommodate two sets of
IRIX geometry results.  Got any idea how to do that?  (Does config.guess
produce any relevant info?)
        regards, tom lane


Re: Call for platform testing

From
Olivier PRENANT
Date:
On Wed, 28 Nov 2001, Larry Rosenman wrote:

> I've upgraded to OpenUNIX 8, and all is well.  
> 
> It probably passes on UW 7 as well, but I can no longer test it. 
7.2b3 does run ok on uw711 (regression test shows no error)

[snip]

-- 
Olivier PRENANT             Tel:    +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
FRANCE                      Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)



Re: Call for platform testing

From
Luis Amigo
Date:
Tom Lane wrote:

> Luis Amigo <lamigo@atc.unican.es> writes:
>
> > I believe i've found a reasonable explanation, there is a architecture
> > disroupt between old MIPS3 FPUs
> > and newer MIPS4 FPUs.(so I'm almost sure that is the explanation).
>
> If Pete's lost interest then I'd be willing to adopt your results as
> the standard geometry-irix file.  If he's still interested then we'd
> need to figure out a way for the resultmap mechanism to distinguish
> older and newer MIPS hardware in order to accommodate two sets of
> IRIX geometry results.  Got any idea how to do that?  (Does config.guess
> produce any relevant info?)
>
>                         regards, tom lane

First I have to apologize, I said MIPS3 and MIPS4 architecture, MIPS are
proccesor instructions set no architecture, and r8000 CPUs have MIPS4
instructions set.
I should have said old 8010 FPUs and newer 10010 and 12010 FPUs.
I think there are only three possible reasons in differences:
1.- FPUs architecture.
2.- compiler specific optimization( It's only possible if Pete turned on
extensive optimization for 8000), because we are compiling with
full-compatibility options -rx directives optimize cache and memory use but
does not affect proccessors.)
3.-If regress is sending binary data to disk and later retrieving the data
and writing output files, there "might" be rounding up differences between
what was written and readed.

I still believe this difference is made by FPUs
config.guess only says  mips-sgi-irix6.5
I think we can make two results choosing FPUs from hinv
but we don´t have another r8000 to test Pete's results nor another r10000 or
12000 to test our results.
I would try to test in our 4 r10000 IP27 to be sure that our results are
right.

regards   Luis Amigo



Re: Call for platform testing

From
Thomas Lockhart
Date:
> 7.2b3 does run ok on uw711 (regression test shows no error)

Thanks! I'll update the list.
                  - Thomas


Re: Call for platform testing

From
Peter Eisentraut
Date:
Luis Amigo writes:

> I still believe this difference is made by FPUs
> config.guess only says  mips-sgi-irix6.5

If your uname -m gives any clue about the processor type we might want to
create a patch for config.guess.

-- 
Peter Eisentraut   peter_e@gmx.net



Re: Call for platform testing

From
Luis Amigo
Date:
Peter Eisentraut wrote:

> Luis Amigo writes:
>
> > I still believe this difference is made by FPUs
> > config.guess only says  mips-sgi-irix6.5
>
> If your uname -m gives any clue about the processor type we might want to
> create a patch for config.guess.
>
> --
> Peter Eisentraut   peter_e@gmx.net

uname -m returns IP25 what is SGI platform, it's about cache sizes and
internal net issues, I'm not sure that would work, I think it's more
reliable to do:
congrio 39% hinv -t cpu
CPU: MIPS R10000 Processor Chip Revision: 2.5
CPU: MIPS R10000 Processor Chip Revision: 2.5
CPU: MIPS R10000 Processor Chip Revision: 2.5
CPU: MIPS R10000 Processor Chip Revision: 2.5
CPU: MIPS R10000 Processor Chip Revision: 2.6
CPU: MIPS R10000 Processor Chip Revision: 2.6
CPU: MIPS R10000 Processor Chip Revision: 2.6
CPU: MIPS R10000 Processor Chip Revision: 2.6
or
congrio 40% hinv -t fpu
FPU: MIPS R10010 Floating Point Chip Revision: 2.5
FPU: MIPS R10010 Floating Point Chip Revision: 2.5
FPU: MIPS R10010 Floating Point Chip Revision: 2.5
FPU: MIPS R10010 Floating Point Chip Revision: 2.5
FPU: MIPS R10010 Floating Point Chip Revision: 2.6
FPU: MIPS R10010 Floating Point Chip Revision: 2.6
FPU: MIPS R10010 Floating Point Chip Revision: 2.6
FPU: MIPS R10010 Floating Point Chip Revision: 2.6
as you wish
best regards




Re: Call for platform testing

From
Tom Lane
Date:
Luis Amigo <lamigo@atc.unican.es> writes:
> uname -m returns IP25 what is SGI platform, it's about cache sizes and
> internal net issues, I'm not sure that would work, I think it's more
> reliable to do:
> congrio 39% hinv -t cpu
> congrio 40% hinv -t fpu

I'm not eager to add such a platform-dependent test to the resultmap
code, especially not when the issue is just the geometry results; we
already know that the long-term answer there must be to display fewer
digits in the test output.  Also, we don't know what this program will
report for older MIPS boxes anyway.  (Pete Forman hasn't responded to my
ping, so I'm inclined to assume that he's not actively tracking Postgres
development anymore; we can't expect help from him to check it on the
older boxes.)

I'd be willing to just commit the newer-hardware IRIX results as
geometry-irix for 7.2.  Somebody's got to put up with a discrepancy,
and it may as well be the older boxes.

Comments?
        regards, tom lane


Re: Call for platform testing

From
Luis Amigo
Date:
Tom Lane wrote:

> Luis Amigo <lamigo@atc.unican.es> writes:
> > uname -m returns IP25 what is SGI platform, it's about cache sizes and
> > internal net issues, I'm not sure that would work, I think it's more
> > reliable to do:
> > congrio 39% hinv -t cpu
> > congrio 40% hinv -t fpu
>
> I'm not eager to add such a platform-dependent test to the resultmap
> code, especially not when the issue is just the geometry results; we
> already know that the long-term answer there must be to display fewer
> digits in the test output.  Also, we don't know what this program will
> report for older MIPS boxes anyway.  (Pete Forman hasn't responded to my
> ping, so I'm inclined to assume that he's not actively tracking Postgres
> development anymore; we can't expect help from him to check it on the
> older boxes.)
>
> I'd be willing to just commit the newer-hardware IRIX results as
> geometry-irix for 7.2.  Somebody's got to put up with a discrepancy,
> and it may as well be the older boxes.
>
> Comments?
>
>                         regards, tom lane

I'm completely with you, I don´t think that would be useful to mantain such
firmware dependecies, but I think that it might be useful to document this
and problems with gcc, now we all remember this issue, but in two months
all will be forgotten.
We had here a lot of trouble installing our first 7.1.3 postgres because it
wasn´t documented that gcc simply doesn´t run. I swear that when I had time
I will try to compile with gcc and new libgcc links to try to fix this
problem.



Re: Call for platform testing

From
Luis Amigo
Date:
> I almost forget:

best wishes and regards



Re: Call for platform testing

From
Tom Lane
Date:
Luis Amigo <lamigo@atc.unican.es> writes:
> I'm completely with you, I don�t think that would be useful to mantain such
> firmware dependecies, but I think that it might be useful to document this
> and problems with gcc, now we all remember this issue, but in two months
> all will be forgotten.
> We had here a lot of trouble installing our first 7.1.3 postgres because it
> wasn�t documented that gcc simply doesn�t run. I swear that when I had time
> I will try to compile with gcc and new libgcc links to try to fix this
> problem.

Would you like to make up a FAQ_IRIX document similar to the ones we
have for some other platforms (see, eg, doc/FAQ_HPUX)?  It doesn't need
to be long or fancy, just cover the things you wish you'd known sooner.
        regards, tom lane