Bug with ICU for merge join

2023-03-24 Thread Jeff Janes 
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


bad_merge.sql
Description: Binary data

Re: Bug with ICU for merge join

2023-03-25 Thread Jeff Davis 
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