BUG #18218: NOT LIKE ANY returns same result as LIKE ANY when array items are wrapped into E''

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #18218: NOT LIKE ANY returns same result as LIKE ANY when array items are wrapped into E''
Дата
Msg-id 18218-8cbdd922e41ea291@postgresql.org
обсуждение исходный текст
Ответы RE: BUG #18218: NOT LIKE ANY returns same result as LIKE ANY when array items are wrapped into E''  (Orlov Aleksej <al.orlov@cft.ru>)
Re: BUG #18218: NOT LIKE ANY returns same result as LIKE ANY when array items are wrapped into E''  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      18218
Logged by:          Baurzhan Sakhariyev
Email address:      baurzhansahariev@gmail.com
PostgreSQL version: 15.0
Operating system:   MacOS
Description:

https://www.db-fiddle.com/f/cpNjWRLmQT6UFb2wEo2LoG/0

select 'TextToMatch' like any (array[E'Te\%tch', E'nomatch']); -- true,
correct
select 'TextToMatch' NOT like any (array[E'Te\%tch', E'nomatch']); -- true
but must be false because it's a negated version of the expression above

Please note, that versions without E'' work as expected. 
select 'TextToMatch' like any (array['Te\%tch', 'nomatch']); -- false
select 'TextToMatch' NOT like any (array['Te\%tch', 'nomatch']); -- true


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

Предыдущее
От: Andrei Lepikhov
Дата:
Сообщение: Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN
Следующее
От: Orlov Aleksej
Дата:
Сообщение: RE: BUG #18218: NOT LIKE ANY returns same result as LIKE ANY when array items are wrapped into E''