Hi Andres,
On Fri, Sep 28, 2018 at 03:41:27PM -0700, Andres Freund wrote:
> On 2018-09-28 15:22:23 -0700, Mark Wong wrote:
> > On Fri, Sep 28, 2018 at 11:52:15AM -0700, Andres Freund wrote:
> > > Mark, is there anything odd for specific branches?
> >
> > No... I don't have anything in the config that would be applied to
> > specific branches...
>
> Could you perhaps do some manual debugging on that machine?
>
> Maybe starting with manually running something like:
>
> SELECT uuid_cmp('11111111-1111-1111-1111-111111111111'::uuid,
> '22222222-2222-2222-2222-222222222222'::uuid);
> SELECT uuid_cmp('11111111-1111-1111-1111-111111111111'::uuid,
> '11111111-1111-1111-1111-111111111111'::uuid);
> SELECT uuid_cmp('11111111-1111-1111-1111-111111111111'::uuid,
> '11111113-1111-1111-1111-111111111111'::uuid);
> SELECT uuid_cmp('11111111-1111-1111-1111-111111111111'::uuid,
> '11111110-1111-1111-1111-111111111111'::uuid);
>
> on both master and one of the failing branches?
I've attached the output for head and the 9.4 stable branch. It appears
they are returning the same results.
I built them both by:
CC=/usr/bin/clang ./configure --enable-cassert --enable-debug \
--enable-nls --with-perl --with-python --with-tcl \
--with-tclconfig=/usr/lib64 --with-gssapi --with-openssl \
--with-ldap --with-libxml --with-libxslt
What should I try next?
Regards,
Mark
--
Mark Wong http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services
psql (12devel)
Type "help" for help.
postgres=# SELECT uuid_cmp('11111111-1111-1111-1111-111111111111'::uuid,
'22222222-2222-2222-2222-222222222222'::uuid);
uuid_cmp
-------------
-2147483648
(1 row)
postgres=# SELECT uuid_cmp('11111111-1111-1111-1111-111111111111'::uuid,
'11111111-1111-1111-1111-111111111111'::uuid);
uuid_cmp
----------
0
(1 row)
postgres=# SELECT uuid_cmp('11111111-1111-1111-1111-111111111111'::uuid,
'11111113-1111-1111-1111-111111111111'::uuid);
uuid_cmp
-------------
-2147483648
(1 row)
postgres=# SELECT uuid_cmp('11111111-1111-1111-1111-111111111111'::uuid,
'11111110-1111-1111-1111-111111111111'::uuid);
uuid_cmp
----------
1
(1 row)
psql (9.4.19)
Type "help" for help.
postgres=# SELECT uuid_cmp('11111111-1111-1111-1111-111111111111'::uuid,
'22222222-2222-2222-2222-222222222222'::uuid);
uuid_cmp
-------------
-2147483648
(1 row)
postgres=# SELECT uuid_cmp('11111111-1111-1111-1111-111111111111'::uuid,
'11111111-1111-1111-1111-111111111111'::uuid);
uuid_cmp
----------
0
(1 row)
postgres=# SELECT uuid_cmp('11111111-1111-1111-1111-111111111111'::uuid,
'11111113-1111-1111-1111-111111111111'::uuid);
uuid_cmp
-------------
-2147483648
(1 row)
postgres=# SELECT uuid_cmp('11111111-1111-1111-1111-111111111111'::uuid,
'11111110-1111-1111-1111-111111111111'::uuid);
uuid_cmp
----------
1
(1 row)