Horton

Re: pgbench test failing on 14beta1 on Debian/i386

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Christoph Berg <myon@debian.org>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Dean Rasheed <dean.a.rasheed@gmail.com>, Fabien COELHO <coelho@cri.ensmp.fr>
Date: 2021-05-18T23:45:04Z
Lists: pgsql-hackers 
Thomas Munro <thomas.munro@gmail.com> writes:
> Forgot to post the actual values:
>       r = 2563421694876090368
>       r = 2563421694876090365
> Smells a bit like a precision problem in the workings of pg_erand48(),
> but as soon as I saw floating point numbers I closed my laptop and ran
> for the door.

Yup.  This test has a touching, but entirely unwarranted, faith in
pg_erand48() producing bit-for-bit the same values everywhere.

			regards, tom lane

Commits

  1. Fix pgbench permute tests.

  2. pgbench: Function to generate random permutations.