Re: EUC_* ILIKE index scan stopped matching seq scan in v19

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: EUC_* ILIKE index scan stopped matching seq scan in v19
Date: 2026-09-01 22:51:34
Message-ID: b3d894239e12326649261585d9a30e7e5a6ae43c.camel@j-davis.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 2026-08-26 at 15:15 -0700, Noah Misch wrote:
> Opus 5 found the $SUBJECT regression from commit 630706c "Add
> pg_iswcased()".
> That finding still holds at today's master.  I am attaching the LLM's
> report
> and test case.

Thank you for the report. Patch attached.

I can add a test or two, but they'd be fairly heavyweight and platform-
specific, I think.

Regards,
Jeff Davis

Attachment Content-Type Size
v1-0001-Fix-pg_iswcased.patch text/x-patch 4.9 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tobias Bussmann 2026-09-01 23:10:16 Re: Credits For v19
Previous Message Jan Nidzwetzki 2026-09-01 22:47:46 Re: Enable partitionwise join for partition keys wrapped by RelabelType