Postgres Pro
Downloads
Home   >   mailing lists

Thread: Bug with ICU for merge join

Bug with ICU for merge join

From
Jeff Janes
Date:
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

Re: Bug with ICU for merge join

From
Jeff Davis
Date:
On Fri, 2023-03-24 at 15:45 -0400, Jeff Janes wrote:
> Ever since 27b62377b47f9e7bf58613, I have been getting "ERROR:
>  mergejoin input data is out of order" for the attached reproducer.

Thank you for the report! And the simple repro.

Fixed in 81a6d57e33.

Regards,
    Jeff Davis