BUG #15421: Error: LIKE pattern must not end with escape character

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15421: Error: LIKE pattern must not end with escape character
Дата
Msg-id 15421-6e32dfa391cfae4a@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15421: Error: LIKE pattern must not end with escape character  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15421
Logged by:          Pavel Shapovalov
Email address:      pavel@bnovo.ru
PostgreSQL version: 9.4.19
Operating system:   Linux (4.9.0-4-amd64 #1 SMP Debian 4.9.65-3+deb9u)
Description:

Schema:
CREATE TABLE public.tmp (
    id integer NOT NULL,
    name text
);

Test data:
INSERT INTO tmp VALUES(1, 'test')

If I try to query the table with LIKE statement:
SELECT COUNT(id) AS "records_found" FROM "tmp" WHERE lower("tmp"."name")
LIKE 't\' I get the error "Error: LIKE pattern must not end with escape
character". The same situation is for statement SELECT COUNT(id) AS
"records_found" FROM "tmp" WHERE lower("tmp"."name") LIKE 'te\' and others
if the LIKE pattern matches the beginning of the name field in any record.

If I try to query the statement SELECT COUNT(id) AS "records_found" FROM
"tmp" WHERE lower("tmp"."name") LIKE 'rs\' and others that do not match any
records, there are no errors at all.

This behaviour is not clear from the documentation. Is it a bug or
undocumented feature?


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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: BUG #15420: Server crash. Segmentation fault when parsing xml file
Следующее
От: Andrew Gierth
Дата:
Сообщение: Re: BUG #15420: Server crash. Segmentation fault when parsing xml file