Bug with ICU for merge join

Jeff Janes <jeff.janes@gmail.com>

From: Jeff Janes <jeff.janes@gmail.com>

To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2023-03-24T19:45:36Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix abbreviated keys bug introduced in d87d548cd03.
- 81a6d57e3351 16.0 landed

Attachments

bad_merge.sql (application/octet-stream)

Ever since 27b62377b47f9e7bf58613, I have been getting "ERROR:  mergejoin
input data is out of order" for the attached reproducer.

I get this on Ubuntu 20.04 and 22.04, whether initdb was run under LC_ALL=C
or under LANG=en_US.UTF-8.

It is not my query, I don't really know what its point is.  I just got this
error while looking into the performance of it and accidentally running it
against 16dev.

Cheers,

Jeff