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 1x1Jjx-00573g-0B for pgsql-committers@arkaria.postgresql.org; Tue, 01 Sep 2026 08:21:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x1Jjw-004zhz-08 for pgsql-committers@arkaria.postgresql.org; Tue, 01 Sep 2026 08:21:08 +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 1x1Jjv-004zhp-2c for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:21:07 +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 1x1Jju-00000003RHy-0qVQ for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:21:06 +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=z0btSxD+Pg2DFxL2n+/SfyCRr9JWRzDtfLvZhlbvbL4=; b=fGa727uxQn0OLeZJ750ROqKCOd S3ChKGNZxiotFZ43m7v3d4ebANOKbsr5mrIFG0ELqYbz0+pwlWVxFiMCPIUNaxKkZDpjTIy4uj1q6 EIXp//2UGIJrJno8uz9I+lC1NYOGRdlT9Y6wZz1dK/4JP3pVIUYaHbHPxsQqFiOUBJmqC/02LvXGX wo6r+4DwktNF3ezrIGOH1rkTL52fJLq/c0KsVbTQWjJ59jMnm2YMV80dZ5bGBltO8Rtg3XnMYtfor RiE+THGeYA+a6T96KS42RanvjotLRWw5//zWxsWVkee/yM2Jc7XsBUEzlt7xUe9kkjKh2+aR+PfFV rzU16wlA==; 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 1x1Jjt-00ASb6-3C for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:21:05 +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 1x1Jjs-000000030c9-37hF for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:21:05 +0000 Content-Type: multipart/mixed; boundary="===============1106967213683279456==" 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:21:05 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1106967213683279456== 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 CkJhY2twYXRjaC10aHJvdWdoOiAxNAoKQnJhbmNoCi0tLS0tLQpSRUxfMTZfU1RBQkxFCgpEZXRh aWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi80OGFm NDdkY2RkNTkxZDhkZWIwYmQ0ZDE0NjUyNzgwZDE2NWNhODc5CgpNb2RpZmllZCBGaWxlcwotLS0t LS0tLS0tLS0tLQpzcmMvYmFja2VuZC91dGlscy9hZHQvdmFybGVuYS5jICAgIHwgMTIgKysrKysr KysrKystCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvdGV4dC5vdXQgfCAgOCArKysrKysrKwpz cmMvdGVzdC9yZWdyZXNzL3NxbC90ZXh0LnNxbCAgICAgIHwgIDMgKysrCjMgZmlsZXMgY2hhbmdl ZCwgMjIgaW5zZXJ0aW9ucygrKSwgMSBkZWxldGlvbigtKQoK --===============1106967213683279456==--