From ef6f3426447d4e0a5901921bfa5876b5e586afdb 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 | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/src/backend/utils/adt/like_match.c b/src/backend/utils/adt/like_match.c index 30d52d62c4..8d32cce449 100644 --- a/src/backend/utils/adt/like_match.c +++ b/src/backend/utils/adt/like_match.c @@ -19,7 +19,7 @@ * Copyright (c) 1996-2008, PostgreSQL Global Development Group * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/adt/like_match.c,v 1.20.2.1 2008/03/01 03:26:44 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/utils/adt/like_match.c,v 1.20.2.2 2008/09/27 16:57:43 adunstan Exp $ * *------------------------------------------------------------------------- */ @@ -98,7 +98,7 @@ MatchText(char *t, int tlen, char *p, int plen) { /* Next byte must match literally, whatever it is */ NextByte(p, plen); - if ((plen <= 0) || *p != *t) + if ((plen <= 0) || TCHAR(*p) != TCHAR(*t)) return LIKE_FALSE; } else if (*p == '%') -- 2.50.1