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 1x1Jjj-00573S-2l for pgsql-committers@arkaria.postgresql.org; Tue, 01 Sep 2026 08:20:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x1Jji-004zI4-2o for pgsql-committers@arkaria.postgresql.org; Tue, 01 Sep 2026 08:20:54 +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.96) (envelope-from ) id 1x1Jji-004zHw-22 for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:20:54 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x1Jjg-00000002L6J-0g3e for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:20:54 +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=n6EG45vUqh3b+qoqti6n8aLvnCkOsvjhd6YT7jn9bwY=; b=RhjcJNMrDDLdXAXUEp7CHbWWYB uFazk2lUbmFEln61OJFcBpkdczPlC29yL6rFub0AAOuCCawd7VsB5QP3ijdyjDTHdVgqKCXFXBvtx /yXnFd/nrw06hJSfA2g6XzqPQEOA6tJWOVX8Bgisb0gt50BPe+Pi5/B7ifJYwvsbSK8G3qIulUlZn VgcwrTzn1+a8tcrkR8Gxj3D/VmXJNNBnedJIIHhN5YLgT7PSSiBe2MgADh3uNOSWEMzEFXy8IzQ+X r4JcSK0k1aDS/KPLss2n47B/FmU7SnCMNylgLyaxKoHPCsLgP0S5tfbalzkIyqhY2CEBG+eTRC13P /VaFy6ZA==; 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 1x1Jje-00ASad-38 for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:20:50 +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 1x1Jjd-000000030ad-34l7 for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:20:50 +0000 Content-Type: multipart/mixed; boundary="===============4798504810464992011==" 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:20:50 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4798504810464992011== 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 CkJhY2twYXRjaC10aHJvdWdoOiAxNAoKQnJhbmNoCi0tLS0tLQpSRUxfMTdfU1RBQkxFCgpEZXRh aWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8zMTAz YmRhZmRlNmIwZGZhOGVkYmNlZmI0OGFjNTEwOTdjNmE5YzFlCgpNb2RpZmllZCBGaWxlcwotLS0t LS0tLS0tLS0tLQpzcmMvYmFja2VuZC91dGlscy9hZHQvdmFybGVuYS5jICAgIHwgMTIgKysrKysr KysrKystCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvdGV4dC5vdXQgfCAgOCArKysrKysrKwpz cmMvdGVzdC9yZWdyZXNzL3NxbC90ZXh0LnNxbCAgICAgIHwgIDMgKysrCjMgZmlsZXMgY2hhbmdl ZCwgMjIgaW5zZXJ0aW9ucygrKSwgMSBkZWxldGlvbigtKQoK --===============4798504810464992011==--