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 1sZ4tP-00GGiJ-Id for pgsql-bugs@arkaria.postgresql.org; Wed, 31 Jul 2024 08:41:07 +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 1sZ4tO-003aiq-28 for pgsql-bugs@arkaria.postgresql.org; Wed, 31 Jul 2024 08:41:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZ1Fw-000ZeB-AR for pgsql-bugs@lists.postgresql.org; Wed, 31 Jul 2024 04:48:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZ1Ft-002Jjm-Mn for pgsql-bugs@lists.postgresql.org; Wed, 31 Jul 2024 04:48:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=6kJKgnWdp9anUxsXWIUGIhUP0MNhNm2hkoQ5bsClE+w=; b=LVF7JHAHHn2Kov6Be6ATnpQBWb M37SdxVD59CHwjR9d9TStZqso4sGoQPmErQI9ehUzZHMKfnIe33T07mAJmVJGNLlhWMvk4x6Do+3p pZM9/sxsC+SHTO5x+xDLgmBtEFlvnz9qNE58Q4PndZ9QTFci+k9JrMLGAQXn3hBfkbwDogaK73Q8F 9qAMlkk5k7+/9MZ7dS67s7pST0n+d6tjwCPnQQhxuQKJ/WEieBR0AWq8cIdqoLHaWq5kBiy2qM2/L 3+UVc+Y9UsMXFb/Zdg5HjIXYHvdZtwYBdFSkrhmtBVjV7Y3dbGQSbd7ObSjbFsp8TrB43Cuokv5UE fuSwNRFQ==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZ1Fs-007Fji-1I for pgsql-bugs@lists.postgresql.org; Wed, 31 Jul 2024 04:48:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sZ1Fp-00Ae1l-MS for pgsql-bugs@lists.postgresql.org; Wed, 31 Jul 2024 04:48:02 +0000 Content-Type: multipart/mixed; boundary="===============2923837402044244441==" MIME-Version: 1.0 Subject: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: ammmkilo@163.com Reply-To: ammmkilo@163.com, pgsql-bugs@lists.postgresql.org Date: Wed, 31 Jul 2024 04:47:23 +0000 Message-ID: <18560-c6c21c3b8d5c3f9b@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2923837402044244441== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODU2MApMb2dnZWQgYnk6ICAgICAgICAgIEhhbmcgYW1tbWtpbG8KRW1h aWwgYWRkcmVzczogICAgICBhbW1ta2lsb0AxNjMuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTYu MwpPcGVyYXRpbmcgc3lzdGVtOiAgIHVidW50dSAyMC4wNApEZXNjcmlwdGlvbjogICAgICAgIAoK YGBgY3JlYXRlIHRhYmxlDQpEUk9QIFRBQkxFIElGIEVYSVNUUyB0MDsNCkNSRUFURSBUQUJMRSB0 MChjMCBJTlQgTk9UIE5VTEwsIGMxIENIQVIoMSkgVU5JUVVFKTsNCklOU0VSVCBJTlRPIHQwIFZB TFVFUyAoMCwgJzEnKTsNCklOU0VSVCBJTlRPIHQwIFZBTFVFUyAoMCwgJycpOw0KYGBgDQoNCi0t LXNxbDENCnNlbGVjdCAoJycgbGlrZSAnJyksKCcxJyBsaWtlICcxJyk7DQoNCiA/Y29sdW1uPyB8 ID9jb2x1bW4/IA0KLS0tLS0tLS0tLSstLS0tLS0tLS0tDQogdCAgICAgICAgfCB0DQooMSByb3cp DQoNCi0tLXNxbDINCnNlbGVjdCBjMSwoYzEgbGlrZSBjMSkgZnJvbSB0MDsNCg0KIGMxIHwgP2Nv bHVtbj8gDQotLS0tKy0tLS0tLS0tLS0NCiAxICB8IHQNCiAgICB8IGYNCigyIHJvd3MpDQoNCklu IHNxbDEsIHRoZSByZXN1bHQgb2YgdGhlICgiIGxpa2UgIikgcXVlcnkgcmV0dXJucyB0cnVlLiBJ biBzcWwyIChjMSBsaWtlCmMxKSB0aGUgcmV0dXJuIHZhbHVlIGlzIGZhbHNlIHdoZW4gYzEgaXMg Ii4gDQpJIHRoaW5rIHRoaXMgaXMgY29udHJhZGljdG9yeSBhbmQgdGhlcmUgbWF5IGJlIHNvbWUg YnVnIGJldHdlZW4gdGhlICdsaWtlJwphbmQgdGhlIHF1ZXJ5IGNvbHVtbi4NCg0KDQogIA0KLS0t c2VsZWN0IHZlcnNpb24oKToNCiAgDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgdmVyc2lvbiAgICAgICAgICAgICAgCiAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIFBvc3RncmVTUUwgMTYuMyAoRGViaWFu IDE2LjMtMS5wZ2RnMTIwKzEpIG9uIHg4Nl82NC1wYy1saW51eC1nbnUsIGNvbXBpbGVkCmJ5IGdj YyAoRGViaWFuIDEyLjIuMC0xNCkgMTIuMi4wLCA2NC1iaXQNCigxIHJvdykKCg== --===============2923837402044244441==--