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.96) (envelope-from ) id 1x1Jio-00572b-2x for pgsql-committers@arkaria.postgresql.org; Tue, 01 Sep 2026 08:19:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x1Jin-004y2M-2v for pgsql-committers@arkaria.postgresql.org; Tue, 01 Sep 2026 08:19:57 +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.96) (envelope-from ) id 1x1Jin-004y2E-29 for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:19:57 +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.98.2) (envelope-from ) id 1x1Jil-00000003RG5-48U2 for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:19:56 +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=bZ6HZ0WE5Jhqk1ITHasSg4qxG/kHZgvdcHeL8NkY2GY=; b=S1/PLOM9v71OuASHeSEpGjftA8 /66V/8sDLTPUP2rd77PmKVm9z7g5wY+0yuGKLQ1cXHxgUZun1oQ+DmghRhYYf2GJvvVeegwoP7Ojn Egx9HZaKqVPRvT7f4kh3UbUBu6M1BXuLis1OXoNyLX2VcvMCwYJoCeDOaMR0MNq+3g6CtA7XbWEcs +MDqPay9Q4bzqixDnwrA5sS+DFUarUHkcYRa6e9Fim1Y3ZipEknRR234U6+gweZdsWIUJ9CC6vypn DRKlJOzFTB03c5pnlEEE6WFfjt3VnrYMKxN6jMIBQZVz3yY8TxSYURQUNxwhYFMphixkF0QurAcRd bvpCurqg==; 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.96) (envelope-from ) id 1x1Jil-00ASZH-2T for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:19:55 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1x1Jik-000000030X4-0jji for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:19:55 +0000 Content-Type: multipart/mixed; boundary="===============1355883848679462799==" MIME-Version: 1.0 From: Daniel Gustafsson To: pgsql-committers@lists.postgresql.org Subject: pgsql: Handle PG_INT32_MIN negation overflow in right() X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 01 Sep 2026 08:19:55 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1355883848679462799== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SGFuZGxlIFBHX0lOVDMyX01JTiBuZWdhdGlvbiBvdmVyZmxvdyBpbiByaWdodCgpCgpBIG5lZ2F0 aXZlIG4gbWVhbnMgInJldHVybiBhbGwgYnV0IHRoZSBmaXJzdCB8bnwgY2hhcmFjdGVycyIsIHNv CnRleHRfcmlnaHQoKSBuZWdhdGVzIG4gYmVmb3JlIGNsaXBwaW5nLiAgTmVnYXRpbmcgUEdfSU5U MzJfTUlOCm92ZXJmbG93czsgd2l0aCAtZndyYXB2IHRoZSByZXN1bHQgaXMgUEdfSU5UMzJfTUlO IGFnYWluLCBzdGlsbApuZWdhdGl2ZSwgYW5kIHBnX21iY2hhcmNsaXBsZW4oKSB0aGVuIHJldHVy bnMgYW4gb2Zmc2V0IG9mIHplcm8sCnNvIHRoZSB3aG9sZSBzdHJpbmcgaXMgcmV0dXJuZWQgd2hl cmUgdGhlIGNvcnJlY3QgYW5zd2VyIGlzIGFuCmVtcHR5IHN0cmluZzoKCiAgU0VMRUNUIHJpZ2h0 KCdhYmNkZWYnLCAoLTIxNDc0ODM2NDgpOjppbnQ0KTsgLS0gJ2FiY2RlZicsIHdhbnQgJycKICBT RUxFQ1QgcmlnaHQoJ2FiY2RlZicsIC0yMTQ3NDgzNjQ3KTsgICAgICAgICAtLSAnJywgY29ycmVj dAoKQ2xhbXAgdG8gUEdfSU5UMzJfTUFYIGluc3RlYWQuICBBbnkgbiB3aG9zZSBhYnNvbHV0ZSB2 YWx1ZSBpcyBhdApsZWFzdCB0aGUgc3RyaW5nJ3MgbGVuZ3RoIHNraXBzIGFsbCBvZiBpdCwgYW5k IGEgdGV4dCB2YWx1ZSBjYW5ub3QKYmUgbG9uZ2VyIHRoYW4gUEdfSU5UMzJfTUFYLCBzbyB0aGlz IGdpdmVzIHRoZSBzYW1lIGFuc3dlciBmb3IgZXZlcnkKb3RoZXIgaW5wdXQuICBFcnJvcmluZyBv dXQsIGFzIHRleHRfZm9ybWF0X3N0cmluZ19jb252ZXJzaW9uKCkgZG9lcwpmb3IgYSB3aWR0aCBv ZiBJTlRfTUlOLCB3b3VsZCBub3QgYmUgY29ycmVjdCBoZXJlOiB1bmxpa2UgYSBmb3JtYXQKd2lk dGgsIGFuIG91dC1vZi1yYW5nZSBza2lwIGNvdW50IGhhcyBhIHdlbGwtZGVmaW5lZCByZXN1bHQu CgpVc2luZyBwZ19uZWdfczMyX292ZXJmbG93KCkgd291bGQgYmUgYSBzbGlnaHRseSBtb3JlIG9w dGltYWwgZml4IGJ1dAphcyBpdCdzIG9ubHkgYXZhaWxhYmxlIGluIFBvc3RncmVTUUwgMTggYW5k IGxhdGVyIHRoZSBkZWNpc2lvbiB3YXMKdGFrZW4gdG8gYXBwbHkgdGhlIHNhbWUgZml4IHRvIGFs bCBiYWNrYnJhbmNoZXMuCgpCYWNrcGF0Y2ggdG8gYWxsIHN1cHBvcnRlZCB2ZXJzaW9ucy4KCkF1 dGhvcjogRXdhbiBZb3VuZyA8a2RiYXNlLmhhY2tAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogRGFu aWVsIEd1c3RhZnNzb24gPGRhbmllbEB5ZXNxbC5zZT4KUmV2aWV3ZWQtYnk6IERhZ2Zpbm4gSWxt YXJpIE1hbm5zw6VrZXIgPGlsbWFyaUBpbG1hcmkub3JnPgpSZXZpZXdlZC1ieTogRGF2aWQgUm93 bGV5IDxkZ3Jvd2xleW1sQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IENoYW8gTGkgPGxpLmV2YW4u Y2hhb0BnbWFpbC5jb20+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FPTjJ4SE5u QnotQWNQSmdEbWQ1XzM5KzhxUjVBVUtFWms0WDNaTS0wemRzQVRuOGtRQG1haWwuZ21haWwuY29t CkJhY2twYXRjaC10aHJvdWdoOiAxNAoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0t LS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2E2M2RmMjY2NDIy NWQwNmQ1YmVlNWRkOTE5NWY2ZDEwZTdmYTE1MDIKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0t LS0tCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC92YXJsZW5hLmMgICAgfCAxMiArKysrKysrKysrKy0K c3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC90ZXh0Lm91dCB8ICA4ICsrKysrKysrCnNyYy90ZXN0 L3JlZ3Jlc3Mvc3FsL3RleHQuc3FsICAgICAgfCAgMyArKysKMyBmaWxlcyBjaGFuZ2VkLCAyMiBp bnNlcnRpb25zKCspLCAxIGRlbGV0aW9uKC0pCgo= --===============1355883848679462799==--