pgsql: Use multibyte-aware extraction of pattern prefixes. - Mailing list pgsql-committers

From Jeff Davis
Subject pgsql: Use multibyte-aware extraction of pattern prefixes.
Date
Msg-id E1vVDHV-000wjh-2T@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Use multibyte-aware extraction of pattern prefixes.

Previously, like_fixed_prefix() used char-at-a-time logic, which
forced it to be too conservative for case-insensitive matching.

Introduce like_fixed_prefix_ci(), and use that for case-insensitive
pattern prefixes. It uses multibyte and locale-aware logic, along with
the new pg_iswcased() API introduced in 630706ced0.

Reviewed-by: Chao Li <li.evan.chao@gmail.com>
Reviewed-by: Peter Eisentraut <peter@eisentraut.org>
Discussion: https://postgr.es/m/450ceb6260cad30d7afdf155d991a9caafee7c0d.camel@j-davis.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/9c8de1596912b36a8b22d880766ac660b66d03c7

Modified Files
--------------
src/backend/utils/adt/like_support.c | 169 +++++++++++++++++++++++------------
1 file changed, 112 insertions(+), 57 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Add offnum range checks to suppress compile warnings with UBSAN.
Next
From: Jeff Davis
Date:
Subject: pgsql: Remove incorrect declarations in pg_wchar.h.