From: Orlov Aleksej <al.orlov@cft.ru>
To: baurzhansahariev@gmail.com <baurzhansahariev@gmail.com>
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: RE: BUG #18218: NOT LIKE ANY returns same result as LIKE ANY when array items are wrapped into E''
Date: Thu, 30 Nov 2023 12:50:03 +0000
Message-ID: <8bd8a9eece0945c79b120dca149a1165@cft.ru> (raw)
In-Reply-To: <18218-8cbdd922e41ea291@postgresql.org>
References: <18218-8cbdd922e41ea291@postgresql.org>
Hi, Baurzhan!
I've checked the requests and here's what I think about it.
There is no mistake here.
Here's how I tested
1. select 'TextToMatch' like E'Te\%tch' returns true.
2. select 'TextToMatch' like E'nomatch' returns false.
3. select 'TextToMatch' not like E'Te\%tch' returns false.
4. select 'TextToMatch' not like E'nomatch' returns true.
LIKE ANY 1, 2 equals true.
LIKE NOT ANY 3, 4 equals true.
Maybe you need to use NOT ALL?
>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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: al.orlov@cft.ru, baurzhansahariev@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: RE: BUG #18218: NOT LIKE ANY returns same result as LIKE ANY when array items are wrapped into E''
In-Reply-To: <8bd8a9eece0945c79b120dca149a1165@cft.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox