Use CASEFOLD() internally rather than LOWER()

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v2, Patch count: 3, First patch: +41−16, All patches: +55−30

Tags

Created

2026-01-12 18:33:19

Last modified

2026-03-31 20:45:38 (6 hours ago)

Latest email

2026-03-26 00:01:26 (6 days ago)

Status

PG20-1 (2026-07-01 – 2026-07-31): Needs review

PG19-Final (2026-03-01 – 2026-03-31): Moved to different CF

Target version

Authors

Jeff Davis (jdavis)

Reviewers

Mark Dilger (mark.dilger)Become reviewer

Committer

Links

Emails

Use CASEFOLD() internally rather than LOWER(): First at 2026-01-12 18:22:20 by Jeff Davis <pgsql at j-davis.com>
Latest at 2026-03-26 00:01:26 by Mark Dilger <mark.dilger at enterprisedb.com>
Latest attachment (WIP-v3-0001-Demonstrate-inconsistency-in-gin-index-vs-seq-sca.patch-WIP) at 2026-03-22 03:14:37 from Mark Dilger <mark.dilger at enterprisedb.com>
    Attachment (WIP-v3-0001-Demonstrate-inconsistency-in-gin-index-vs-seq-sca.patch-WIP) at 2026-03-22 03:14:37 from Mark Dilger <mark.dilger at enterprisedb.com> (Patch: Yes)
    Attachment (v2-0001-ILIKE-use-CASEFOLD-rather-than-LOWER.patch) at 2026-03-03 21:01:48 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v1-0001-ILIKE-use-CASEFOLD-rather-than-LOWER.patch) at 2026-01-12 18:22:20 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)

History

When	Who	What
2026-03-31 20:45:38	Jeff Davis (jdavis)	Moved from CF PG19-Final to CF PG20-1
2026-03-22 02:21:14	Mark Dilger (mark.dilger)	Added mark.dilger as reviewer
2026-01-12 18:33:19	Jeff Davis (jdavis)	Attached mail thread 64d7949bad90545f981ac7513fb0b4954daca2c9.camel@j-davis.com
2026-01-12 18:33:19	Jeff Davis (jdavis)	Created patch record