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 1tlXkq-00Cry6-JH for pgsql-committers@arkaria.postgresql.org; Fri, 21 Feb 2025 18:28:04 +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 1tlXkp-00EELI-A8 for pgsql-committers@arkaria.postgresql.org; Fri, 21 Feb 2025 18:28:03 +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 1tlXkp-00EEJI-0w for pgsql-committers@lists.postgresql.org; Fri, 21 Feb 2025 18:28:03 +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.96) (envelope-from ) id 1tlXkn-0029Kq-0g for pgsql-committers@lists.postgresql.org; Fri, 21 Feb 2025 18:28:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=Oo0mbAmDZzLOjzTS7OJW8f/lSeg2Ar0W4zanhOJ148c=; b=UGeqA5hLklcLakFOaA1V+vFISi +hL7laIo7LJNSwABXhjSFYcuvTl66h+zpDr/AyHESzKSXmw9CxUh7b4Er38CHoGiSzu7kR+A5Ygva oTvXFS2jB09SZ94+Jj5Gh+qTdWmnGmMCkAffjEm87a7Ah6csGTDNI53QtA/e+7WK7mVnRskalxgtA G6zX+KklZJmvfwB8pvD3P2XGXEujZSaL2wGfIUrXmJgObVHSOTNQu/gG6apvMJ6CRng88TwAMMJH6 Q/ooMjjtrQMu/czrDfqRLnZhK+5i4u8McRQUPOE6FOsTfQTn/Axc58vCyQKSQlzwfPRlEGmGOqzTZ BY3+G6Ug==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tlXkm-007Mhk-N0 for pgsql-committers@lists.postgresql.org; Fri, 21 Feb 2025 18:28:00 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tlXkn-000VZr-2D for pgsql-committers@lists.postgresql.org; Fri, 21 Feb 2025 18:28:00 +0000 Content-Type: multipart/mixed; boundary="===============1397782192222018749==" MIME-Version: 1.0 From: Masahiko Sawada To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix an issue with index scan using pg_trgm due to char signednes X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 21 Feb 2025 18:28:00 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1397782192222018749== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGFuIGlzc3VlIHdpdGggaW5kZXggc2NhbiB1c2luZyBwZ190cmdtIGR1ZSB0byBjaGFyIHNp Z25lZG5lc3Mgb24gZGlmZmVyZW50IGFyY2hpdGVjdHVyZXMuCgpHSU4gYW5kIEdpU1QgaW5kZXhl cyB1dGlsaXppbmcgcGdfdHJnbSdzIG9wY2xhc3NlcyBzdG9yZSBzb3J0ZWQKdHJpZ3JhbXMgd2l0 aGluIGluZGV4IHR1cGxlcy4gV2hlbiBjb21wYXJpbmcgYW5kIHNvcnRpbmcgZWFjaCB0cmlncmFt LApwZ190cmdtIHRyZWF0cyBlYWNoIGNoYXJhY3RlciBhcyBhICdjaGFyWzNdJyB0eXBlIGluIEMu IEhvd2V2ZXIsIHRoZQpjaGFyIHR5cGUgaW4gQyBjYW4gYmUgaW50ZXJwcmV0ZWQgYXMgZWl0aGVy IHNpZ25lZCBjaGFyIG9yIHVuc2lnbmVkCmNoYXIsIGRlcGVuZGluZyBvbiB0aGUgcGxhdGZvcm0s IGlmIHRoZSBzaWduZWRuZXNzIGlzIG5vdCBleHBsaWNpdGx5CnNwZWNpZmllZC4gQ29uc2VxdWVu dGx5LCBkdXJpbmcgcmVwbGljYXRpb24gYmV0d2VlbiBkaWZmZXJlbnQgQ1BVCmFyY2hpdGVjdHVy ZXMsIHRoZXJlIHdhcyBhbiBpc3N1ZSB3aGVyZSBpbmRleCBzY2FucyBvbiBzdGFuZGJ5IHNlcnZl cnMKY291bGQgbm90IGxvY2F0ZSBtYXRjaGluZyBpbmRleCB0dXBsZXMgZHVlIHRvIHRoZSBkaWZm ZXJpbmcgdHJlYXRtZW50Cm9mIGNoYXJhY3RlciBzaWduZWRuZXNzLgoKVGhpcyBjaGFuZ2UgaW50 cm9kdWNlcyBjb21wYXJpc29uIGZ1bmN0aW9ucyBmb3IgdHJnbSB0aGF0IGV4cGxpY2l0bHkKaGFu ZGxlIHNpZ25lZCBjaGFyIGFuZCB1bnNpZ25lZCBjaGFyLiBUaGUgYXBwcm9wcmlhdGUgY29tcGFy aXNvbgpmdW5jdGlvbiB3aWxsIGJlIGR5bmFtaWNhbGx5IHNlbGVjdGVkIGJhc2VkIG9uIHRoZSBj aGFyYWN0ZXIKc2lnbmVkbmVzcyBzdG9yZWQgaW4gdGhlIGNvbnRyb2wgZmlsZS4gVGhlcmVmb3Jl LCB1cGdyYWRlZCBjbHVzdGVycwpjYW4gdXRpbGl6ZSB0aGUgaW5kZXhlcyB3aXRob3V0IHJlYnVp bGRpbmcsIHByb3ZpZGVkIHRoZSBjbHVzdGVyCnVwZ3JhZGUgb2NjdXJzIG9uIHBsYXRmb3JtcyB3 aXRoIHRoZSBzYW1lIGNoYXJhY3RlciBzaWduZWRuZXNzIGFzIHRoZQpvcmlnaW5hbCBjbHVzdGVy IGluaXRpYWxpemF0aW9uLgoKVGhlIGRlZmF1bHQgY2hhciBzaWduZWRuZXNzIGluZm9ybWF0aW9u IHdhcyBpbnRyb2R1Y2VkIGluIDQ0ZmUzMGZkYWI2LApzbyBubyBiYWNrcGF0Y2guCgpSZXZpZXdl ZC1ieTogTm9haCBNaXNjaCA8bm9haEBsZWFkYm9hdC5jb20+CkRpc2N1c3Npb246IGh0dHBzOi8v cG9zdGdyLmVzL20vQ0IxMUFEQkMtMEMzRi00RkUwLUE2NzgtNjY2RUU4MENCQjA3JTQwYW1hem9u LmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5w b3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2RmZDhlNmM3M2VlYWE4YTRkNTM4NTFiYTAxZThk N2IxYzBiZWYwZTMKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmNvbnRyaWIvcGdfdHJn bS90cmdtLmggICAgfCAgNSArLS0tLQpjb250cmliL3BnX3RyZ20vdHJnbV9vcC5jIHwgNDQgKysr KysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysKMiBmaWxlcyBjaGFuZ2Vk LCA0NSBpbnNlcnRpb25zKCspLCA0IGRlbGV0aW9ucygtKQoK --===============1397782192222018749==--