Re: pgsql: Collations with nondeterministic comparison

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter(at)eisentraut(dot)org>
Cc: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Collations with nondeterministic comparison
Date: 2019-03-25 05:07:46
Message-ID: 8688.1553490466@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Peter Eisentraut <peter(at)eisentraut(dot)org> writes:
> Collations with nondeterministic comparison

Buildfarm member snapper doesn't like this. I think the problem is
that the queries it's failing on do not bother to constrain their
output row order. Adding an "EXPLAIN" right there indicates that
the INTERSECTs are being done via hashing, meaning that platform
specific output ordering is to be expected. I don't have a
big-endian platform with ICU installed, but if I did I bet I could
replicate the failure on it.

regards, tom lane

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2019-03-25 07:16:35 pgsql: Add ORDER BY to regression test case
Previous Message Andres Freund 2019-03-25 02:05:47 pgsql: tableam: Use in CREATE TABLE AS and CREATE MATERIALIZED VIEW.