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)