BUG #17358: While using --with-uuid=bsd option, uuid_ossp test fails on NetBSD 9.2

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: byavuz81(at)gmail(dot)com
Subject: BUG #17358: While using --with-uuid=bsd option, uuid_ossp test fails on NetBSD 9.2
Date: 2022-01-07 10:38:50
Message-ID: 17358-89806e7420797025@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17358
Logged by: Nazir Bilal Yavuz
Email address: byavuz81(at)gmail(dot)com
PostgreSQL version: 14.1
Operating system: NetBSD 9.2
Description:

Hi,

While installing PostgreSQL from source code, uuid_ossp test fails on NetBSD
9.2.
The commands I used are:
./configure \
--with-uuid=bsd \
\
--with-includes=/usr/pkg/include --with-libs=/usr/pgk/lib && \
gmake -s world-bin && gmake -s check-world

OS:
NetBSD localhost 9.2 NetBSD 9.2 (GENERIC) #0: Wed May 12 13:15:55 UTC 2021
mkrepro(at)mkrepro(dot)NetBSD(dot)org:/usr/src/sys/arch/amd64/compile/GENERIC amd64

Error message:
test uuid ... ok 11 ms
test uuid ... ok 12 ms
test uuid_ossp ... FAILED 11 ms

Diff:
diff -U3 /home/postgres/postgres/contrib/uuid-ossp/expected/uuid_ossp.out
/home/postgres/postgres/contrib/uuid-ossp/results/uuid_ossp.out
--- /home/postgres/postgres/contrib/uuid-ossp/expected/uuid_ossp.out
2022-01-07 09:54:27.613601852 +0000
+++ /home/postgres/postgres/contrib/uuid-ossp/results/uuid_ossp.out
2022-01-07 10:02:25.833291382 +0000
@@ -59,7 +59,7 @@
uuid_reserved_bits(uuid_generate_v1());
uuid_version_bits | uuid_reserved_bits
-------------------+--------------------
- 00010000 | 10000000
+ 01000000 | 10000000
(1 row)

-- Although RFC 4122 only requires the multicast bit to be set in V1MC
style
@@ -70,20 +70,20 @@
uuid_local_admin_bit(uuid_generate_v1mc());
uuid_version_bits | uuid_reserved_bits | uuid_multicast_bit |
uuid_local_admin_bit

-------------------+--------------------+--------------------+----------------------
- 00010000 | 10000000 | t | t
+ 01000000 | 10000000 | t | t
(1 row)

-- timestamp+clock sequence should be monotonic increasing in v1
SELECT uuid_timestamp_bits(uuid_generate_v1()) <
uuid_timestamp_bits(uuid_generate_v1());
?column?
----------
- t
+ f
(1 row)

SELECT uuid_timestamp_bits(uuid_generate_v1mc()) <
uuid_timestamp_bits(uuid_generate_v1mc());
?column?
----------
- t
+ f
(1 row)

-- Ideally, the node value is stable in V1 addresses, but OSSP UUID
@@ -96,7 +96,7 @@
END;
case
------
- t
+ f
(1 row)

-- In any case, V1MC node addresses should be random.

Thanks,
Nazir Bilal Yavuz

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pantelis Theodosiou 2022-01-07 11:39:18 Re: BUG #17357: When working with the window_function, the Where Clause does not work properly!
Previous Message Etsuro Fujita 2022-01-07 06:19:46 Re: BUG #17355: Server crashes on ExecReScanForeignScan in postgres_fdw when accessing foreign partition