From a8bd91b16b4ad45362b69a6b529b334054752255 Mon Sep 17 00:00:00 2001 From: Andrew Dunstan Date: Sat, 27 Sep 2008 16:57:43 +0000 Subject: [PATCH] Compare escaped chars case insensitively for ILIKE - per gripe from TGL. --- src/backend/utils/adt/like_match.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/backend/utils/adt/like_match.c b/src/backend/utils/adt/like_match.c index aad02d27e3..ad78216eb3 100644 --- a/src/backend/utils/adt/like_match.c +++ b/src/backend/utils/adt/like_match.c @@ -103,7 +103,7 @@ MatchText(char *t, int tlen, char *p, int plen) ereport(ERROR, (errcode(ERRCODE_INVALID_ESCAPE_SEQUENCE), errmsg("LIKE pattern must not end with escape character"))); - if (*p != *t) + if (TCHAR(*p) != TCHAR(*t)) return LIKE_FALSE; } else if (*p == '%') -- 2.39.5