| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | baurzhansahariev(at)gmail(dot)com |
| Subject: | BUG #18218: NOT LIKE ANY returns same result as LIKE ANY when array items are wrapped into E'' |
| Date: | 2023-11-30 10:54:36 |
| Message-ID: | 18218-8cbdd922e41ea291@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 18218
Logged by: Baurzhan Sakhariyev
Email address: baurzhansahariev(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Orlov Aleksej | 2023-11-30 12:50:03 | RE: BUG #18218: NOT LIKE ANY returns same result as LIKE ANY when array items are wrapped into E'' |
| Previous Message | Andrei Lepikhov | 2023-11-30 07:21:50 | Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN |