Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8gUd-00B9FN-Oi for pgsql-bugs@arkaria.postgresql.org; Thu, 30 Nov 2023 12:50:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r8gUc-00HOHW-GP for pgsql-bugs@arkaria.postgresql.org; Thu, 30 Nov 2023 12:50:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8gUb-00HOHO-W7 for pgsql-bugs@lists.postgresql.org; Thu, 30 Nov 2023 12:50:10 +0000 Received: from email.ftc.ru ([194.85.126.43]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8gUY-009M5Y-9T for pgsql-bugs@lists.postgresql.org; Thu, 30 Nov 2023 12:50:08 +0000 Received: from mail.cft.ru (nut-exch-3.ftc.ru [172.29.95.83]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mail-gate-2.ftc.ru (Postfix) with ESMTPS id 8F90E2C00B8; Thu, 30 Nov 2023 19:50:03 +0700 (+07) DKIM-Filter: OpenDKIM Filter v2.11.0 mail-gate-2.ftc.ru 8F90E2C00B8 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cft.ru; s=relay; t=1701348603; bh=pDR5EErGuMrXDsEY0fV70Vc5m1od5WnnyXXNGucJBIE=; h=From:To:Subject:Date:Message-ID:From:Sender:To:CC:Subject: Message-Id:Date; b=Xs1gFgDW1OnMSJZP40wJtFblT4I3c1+mwxccmQunQbsFNWX2gfCmNzouMpur/KWRP cub2JvH5hUJl+8FpIcWpNQUZ2+zp8Pe6cgK6+zJtCC4rxJecHzyAuNqbwacWKzslY3 oHHh2P8sbdeBEpu18VxHbsePBVTFrR+rqBFZee2w= Received: from nut-exch-1.win.ftc.ru (172.29.95.118) by nut-exch-4.win.ftc.ru (172.29.95.84) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1258.28; Thu, 30 Nov 2023 19:50:03 +0700 Received: from nut-exch-1.win.ftc.ru ([fe80::da47:9e28:db14:1765]) by nut-exch-1.win.ftc.ru ([fe80::da47:9e28:db14:1765%5]) with mapi id 15.02.1258.028; Thu, 30 Nov 2023 19:50:03 +0700 From: Orlov Aleksej To: "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'' Thread-Topic: BUG #18218: NOT LIKE ANY returns same result as LIKE ANY when array items are wrapped into E'' Thread-Index: AQHaI4ICYW/N/9ZA9UeuzbWHjQKhsbCSxPEw Date: Thu, 30 Nov 2023 12:50:03 +0000 Message-ID: <8bd8a9eece0945c79b120dca149a1165@cft.ru> References: <18218-8cbdd922e41ea291@postgresql.org> In-Reply-To: <18218-8cbdd922e41ea291@postgresql.org> Accept-Language: ru-RU, en-US Content-Language: ru-RU X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [192.168.94.8] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-KLMS-Rule-ID: 1 X-KLMS-Message-Action: clean X-KLMS-AntiSpam-Lua-Profiles: 181735 [Nov 30 2023] X-KLMS-AntiSpam-Version: 6.0.0.2 X-KLMS-AntiSpam-Envelope-From: al.orlov@cft.ru X-KLMS-AntiSpam-Rate: 0 X-KLMS-AntiSpam-Status: not_detected X-KLMS-AntiSpam-Method: none X-KLMS-AntiSpam-Auth: dkim=none X-KLMS-AntiSpam-Info: LuaCore: 5 0.3.5 98d108ddd984cca1d7e65e595eac546a62b0144b, {Tracking_b2b_test_cert_from_list}, {Tracking_uf_ne_domains}, {Tracking_from_domain_doesnt_match_to}, cft.ru:7.1.1;127.0.0.199:7.1.2;d41d8cd98f00b204e9800998ecf8427e.com:7.1.1;www.db-fiddle.com:7.1.1;mail.cft.ru:7.1.1, FromAlignment: s X-MS-Exchange-Organization-SCL: -1 X-KLMS-AntiSpam-Interceptor-Info: scan successful X-KLMS-AntiPhishing: Clean, bases: 2023/11/30 10:41:00 X-KLMS-AntiVirus: Kaspersky Security for Linux Mail Server, version 8.0.3.30, bases: 2023/11/30 08:41:00 #22581173 X-KLMS-AntiVirus-Status: Clean, skipped List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGksIEJhdXJ6aGFuIQ0KDQpJJ3ZlIGNoZWNrZWQgdGhlIHJlcXVlc3RzIGFuZCBoZXJlJ3Mgd2hh dCBJIHRoaW5rIGFib3V0IGl0LiANClRoZXJlIGlzIG5vIG1pc3Rha2UgaGVyZS4gDQoNCkhlcmUn cyBob3cgSSB0ZXN0ZWQgDQoNCjEuIHNlbGVjdCAnVGV4dFRvTWF0Y2gnIGxpa2UgRSdUZVwldGNo JyByZXR1cm5zIHRydWUuDQoyLiBzZWxlY3QgJ1RleHRUb01hdGNoJyBsaWtlIEUnbm9tYXRjaCcg IHJldHVybnMgZmFsc2UuIA0KMy4gc2VsZWN0ICdUZXh0VG9NYXRjaCcgbm90IGxpa2UgRSdUZVwl dGNoJyByZXR1cm5zIGZhbHNlLg0KNC4gc2VsZWN0ICdUZXh0VG9NYXRjaCcgbm90IGxpa2UgRSdu b21hdGNoJyByZXR1cm5zIHRydWUuDQoNCkxJS0UgQU5ZIDEsIDIgZXF1YWxzIHRydWUuIA0KTElL RSBOT1QgQU5ZIDMsIDQgZXF1YWxzIHRydWUuICANCg0KTWF5YmUgeW91IG5lZWQgdG8gdXNlIE5P VCBBTEw/DQoNCg0KPlRoZSBmb2xsb3dpbmcgYnVnIGhhcyBiZWVuIGxvZ2dlZCBvbiB0aGUgd2Vi c2l0ZToNCg0KPkJ1ZyByZWZlcmVuY2U6ICAgICAgMTgyMTgNCj5Mb2dnZWQgYnk6ICAgICAgICAg IEJhdXJ6aGFuIFNha2hhcml5ZXYNCj5FbWFpbCBhZGRyZXNzOiAgICAgIGJhdXJ6aGFuc2FoYXJp ZXZAZ21haWwuY29tDQo+UG9zdGdyZVNRTCB2ZXJzaW9uOiAxNS4wDQo+T3BlcmF0aW5nIHN5c3Rl bTogICBNYWNPUw0KPkRlc2NyaXB0aW9uOiAgICAgICAgDQoNCj5odHRwczovL3d3dy5kYi1maWRk bGUuY29tL2YvY3BOaldSTG1RVDZVRmIyd0VvMkxvRy8wDQoNCj5zZWxlY3QgJ1RleHRUb01hdGNo JyBsaWtlIGFueSAoYXJyYXlbRSdUZVwldGNoJywgRSdub21hdGNoJ10pOyAtLSB0cnVlLCBjb3Jy ZWN0IHNlbGVjdCAnVGV4dFRvTWF0Y2gnIE5PVCBsaWtlIGFueSAoYXJyYXlbRSdUZVwlPnRjaCcs IEUnbm9tYXRjaCddKTsgLS0gdHJ1ZSBidXQgbXVzdCBiZSBmYWxzZSBiZWNhdXNlIGl0J3MgYSBu ZWdhdGVkIHZlcnNpb24gb2YgdGhlIGV4cHJlc3Npb24gYWJvdmUNCg0KPlBsZWFzZSBub3RlLCB0 aGF0IHZlcnNpb25zIHdpdGhvdXQgRScnIHdvcmsgYXMgZXhwZWN0ZWQuIA0KPnNlbGVjdCAnVGV4 dFRvTWF0Y2gnIGxpa2UgYW55IChhcnJheVsnVGVcJXRjaCcsICdub21hdGNoJ10pOyAtLSBmYWxz ZSBzZWxlY3QgJ1RleHRUb01hdGNoJyBOT1QgbGlrZSBhbnkgKGFycmF5WydUZVwldGNoJywgPidu b21hdGNoJ10pOyAtLSB0cnVlDQoNCg==