pgsql: Make LIKE throw an error if the escape character is at the end of

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Make LIKE throw an error if the escape character is at the end of
Date: 2008-09-26 02:16:40
Message-ID: 20080926021640.5E4417545A4@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Make LIKE throw an error if the escape character is at the end of the pattern
(ie, has nothing to quote), rather than silently ignoring the character as has
been our historical behavior. This is required by SQL spec and should help
reduce the sort of user confusion seen in bug #4436. Per discussion.

This is not so much a bug fix as a definitional change, and it could break
existing applications; so not back-patched. It might deserve being mentioned
as an incompatibility in the 8.4 release notes.

Modified Files:
--------------
pgsql/src/backend/utils/adt:
like_match.c (r1.21 -> r1.22)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/like_match.c?r1=1.21&r2=1.22)

Browse pgsql-committers by date

  From Date Subject
Next Message Dave Page 2008-09-26 08:02:42 edb-debugger - server: Define _USE_32BIT_TIME_T on Windows/VC++
Previous Message User Itagaki 2008-09-26 01:23:47 orafce - orafce: Add uninstall script.