public inbox for [email protected]  
help / color / mirror / Atom feed
From: Jeff Janes <[email protected]>
To: PostgreSQL Hackers <[email protected]>
Subject: Bug with ICU for merge join
Date: Fri, 24 Mar 2023 15:45:36 -0400
Message-ID: <CAMkU=1z17XJatF-rMCY3Cjqcxer-Kyn57x6h3OSCpJ0LpAp0ig@mail.gmail.com> (raw)

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


Attachments:

  [application/octet-stream] bad_merge.sql (1.3K, ../CAMkU=1z17XJatF-rMCY3Cjqcxer-Kyn57x6h3OSCpJ0LpAp0ig@mail.gmail.com/3-bad_merge.sql)
  download

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Bug with ICU for merge join
  In-Reply-To: <CAMkU=1z17XJatF-rMCY3Cjqcxer-Kyn57x6h3OSCpJ0LpAp0ig@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox