Bug with ICU for merge join

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Bug with ICU for merge join
Date: 2023-03-24 19:45:36
Message-ID: CAMkU=1z17XJatF-rMCY3Cjqcxer-Kyn57x6h3OSCpJ0LpAp0ig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Attachment Content-Type Size
bad_merge.sql application/octet-stream 1.3 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2023-03-24 19:47:01 Make fop less verbose when building PDF
Previous Message Justin Pryzby 2023-03-24 19:23:20 cfbot stuck