BUG #15084: Invalid LIKE pattern not always reported
От | PG Bug reporting form |
---|---|
Тема | BUG #15084: Invalid LIKE pattern not always reported |
Дата | |
Msg-id | 151941775547.1463.3686411361406861190@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15084: Invalid LIKE pattern not always reported
Re: BUG #15084: Invalid LIKE pattern not always reported |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 15084 Logged by: Tudor Bosman Email address: tudorb@gmail.com PostgreSQL version: 9.5.11 Operating system: Ubuntu 16.04 Description: PostgreSQL will not always detect an invalid LIKE pattern (one that ends with a backslash). Example: tudor=# select 'foo' like 'foo\'; ?column? ---------- f (1 row) tudor=# select 'foobar' like 'foo\'; ERROR: LIKE pattern must not end with escape character This probably happens because the pattern is only parsed lazily (as needed); if PostgreSQL detects that a match is impossible, it doesn't even look at the rest of the pattern. Still, it would be nice for error reporting to be consistent. Thanks, -Tudor.
В списке pgsql-bugs по дате отправления: