Re: Odd 9.4, 9.3 buildfarm failure on s390x
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Cc: Mark Wong <mark@2ndquadrant.com>,
Andrew Gierth <andrew@tao11.riddles.org.uk>,
Andres Freund <andres@anarazel.de>, pgsql-hackers@postgresql.org
Date: 2018-10-01T21:11:02Z
Lists: pgsql-hackers
Andrew Dunstan <andrew.dunstan@2ndquadrant.com> writes: > On 10/01/2018 11:58 AM, Tom Lane wrote: >> Oooh ... apparently, on that platform, memcmp() is willing to produce >> INT_MIN in some cases. That's not a safe value for a sort comparator >> to produce --- we explicitly say that somewhere, IIRC. I think we >> implement DESC by negating the comparator's result, which explains >> why only the DESC case fails. > Is there a standard that forbids this, or have we just been lucky up to now? We've been lucky; POSIX just says the value is less than, equal to, or greater than zero. In practice, a memcmp that operates byte-at-a-time would not likely return anything outside +-255. But on a big-endian machine you could easily optimize to use word-wide operations to compare 4 bytes at a time, and I suspect that's what's happening here. Or maybe there's just some weird architecture-specific reason that makes it cheap for them to return INT_MIN rather than some other value? regards, tom lane
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Allow btree comparison functions to return INT_MIN.
- 6e63e0697516 9.3.25 landed
- 60cc2414beac 9.6.11 landed
- 26cc27541d92 9.4.20 landed
- 0dc6bf633a28 9.5.15 landed
- c87cb5f7a679 12.0 landed
- 67e7d4da72dc 11.0 landed
- 142cfd3cd82e 10.6 landed