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

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: Make LIKE throw an error if the escape character is at the end of
Дата
Msg-id 20080926021640.5E4417545A4@cvs.postgresql.org
обсуждение исходный текст
Список 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)

В списке pgsql-committers по дате отправления:

Предыдущее
От: itagaki@pgfoundry.org (User Itagaki)
Дата:
Сообщение: orafce - orafce: Add uninstall script.
Следующее
От: dpage@pgfoundry.org (Dave Page)
Дата:
Сообщение: edb-debugger - server: Define _USE_32BIT_TIME_T on Windows/VC++