| From: | Jeff Davis <jdavis(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Fix pg_iswcased() for some libc case mappings. |
| Date: | 2026-10-26 22:12:19 |
| Message-ID: | E1xLSvT-00000000tDJ-2dnY@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Fix pg_iswcased() for some libc case mappings.
Some C libraries, such as macOS libc, case-map characters that they do
not classify as upper or lower. ILIKE index scans could then miss
rows, because those characters stayed in the fixed prefix.
Introduced in 630706ced0. 43a948b7b25 fixed similar issues, but missed
this one.
Author: shihao zhong <zhong950419(at)gmail(dot)com>
Reviewed-by: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Reviewed-by: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Discussion: https://postgr.es/m/CAGRkXqS6pr-hG-g=K6RTdRw53SnMZWz3iXvh_wi8rqLSf972sA@mail.gmail.com
Backpatch-through: 19
Branch
------
REL_19_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/75a5fef57d09d75cc082fc6ffe817fc0772ef89a
Modified Files
--------------
src/backend/utils/adt/pg_locale_libc.c | 8 ++++++--
1 file changed, 6 insertions(+), 2 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2026-10-27 02:25:22 | pgsql: doc PG 19 relnotes: add mention of view pg_stat_progress_repack |
| Previous Message | Jeff Davis | 2026-10-26 22:12:13 | pgsql: Fix pg_iswcased() for some libc case mappings. |