Re: [PORTS] HP-UX port - Mailing list pgsql-ports

From Michael J Schout
Subject Re: [PORTS] HP-UX port
Date
Msg-id 199907301922.OAA32520@mail.gkg-com.com
Whole thread Raw
In response to Re: [PORTS] HP-UX port  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-ports
> Michael J Schout <mschout@mail.gkg-com.com> writes:
> > and the actual results are:
> > QUERY: SELECT random FROM RANDOM_TBL
> >   WHERE random NOT BETWEEN 80 AND 120;
> > random
> > ------
> >    123
> > (1 row)
>
> > Which looks like a genuine bug to me :).
>
> No, that's expected behavior, actually.  The random test wouldn't be
> random if it didn't fail occasionally :-).  The parameters are set so

I agree :).  When I qlanced at it the first time, I missed the "NOT" in the
query, so I didnt think that 123 should have been returned at all, which is
obviously false :).  It looks like the regressions are okay then, which is
a relief :).

...
> Interesting.  May or may not be a 64-bit issue; it might be a problem
> with the machine-dependent spinlock code.  Check out
> src/include/storage/s_lock.h and src/backend/storage/buffer/s_lock.c.

Ill hopefully get some time next week to look at this.  I'll let you know
if I can figure it out :)

Mike

pgsql-ports by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Patches for Postgresql on Linux/Alpha!
Next
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] Patches for Postgresql on Linux/Alpha!