Fix multibyte issue in ltree_strncasecmp().

Jeff Davis <jdavis@postgresql.org>

Commit: b8cfe9dc2e7f052e727fc3bc07ccaef13ef55979
Author: Jeff Davis <jdavis@postgresql.org>
Date: 2025-12-16T18:36:29Z
Releases: 17.8
Fix multibyte issue in ltree_strncasecmp().

Previously, the API for ltree_strncasecmp() took two inputs but only
one length (that of the smaller input). It truncated the larger input
to that length, but that could break a multibyte sequence.

Change the API to be a check for prefix equality (possibly
case-insensitive) instead, which is all that's needed by the
callers. Also, provide the lengths of both inputs.

Reviewed-by: Chao Li <li.evan.chao@gmail.com>
Reviewed-by: Peter Eisentraut <peter@eisentraut.org>
Discussion: https://postgr.es/m/5f65b85740197ba6249ea507cddf609f84a6188b.camel%40j-davis.com
Backpatch-through: 14

Files

PathChange+/−
contrib/ltree/lquery_op.c modified +28 −12
contrib/ltree/ltree.h modified +5 −2
contrib/ltree/ltxtquery_op.c modified +4 −4

Discussion