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
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 |