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
|
Список | 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 по дате отправления: