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 1x1Jjc-00573F-2J for pgsql-committers@arkaria.postgresql.org; Tue, 01 Sep 2026 08:20:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x1Jjb-004ysh-2B for pgsql-committers@arkaria.postgresql.org; Tue, 01 Sep 2026 08:20:47 +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 1x1Jjb-004ysY-1Q for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:20:47 +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 1x1JjZ-00000003RHY-3Gsu for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:20:46 +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=QwoX9GeQXbWzLvR/vwx5zPdFw86F97uYm1lSU/sol4Y=; b=XSwuuka8yDhYOPMYgOORmCpuji YvXe9WZo0gVYjOokBZAqjMD/Xq/8wMA09eGfX898gXRcbJbiFL0szsUqjtt9VKrCR3NmfFzA8xv6D 2f+hGWeAox1KZtz9dTEPegNxCx9XkHlNCMi3sXSVus0S14p4WNSO3o8/ZiM5pE3bXIgk79HxG8Kkk r+NhMZRvuwnRGOZ4b8ra6+SpQospYY10eKzDh7l1lC79Ma+TnC8ouRODymCS+2p3ymm3+vSatG59r WuA32sTnyi4AYDQYt3s9lcB9GWhWshZe2FQAw5Ee7qkiFdJpVhF9rJ4DsO0RMTz6uPLDdHivftotb /P4YYSsw==; 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 1x1JjZ-00ASaP-21 for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:20:45 +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 1x1JjY-000000030Zz-1ciU for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:20:45 +0000 Content-Type: multipart/mixed; boundary="===============8475094705472591020==" 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:45 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8475094705472591020== 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 CkJhY2twYXRjaC10aHJvdWdoOiAxNAoKQnJhbmNoCi0tLS0tLQpSRUxfMThfU1RBQkxFCgpEZXRh aWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9iZmIw OGQwOTQ2ZTkxY2Y3M2QxYTNiY2E4YzkwOGQ2ZGNjYjgwNzM1CgpNb2RpZmllZCBGaWxlcwotLS0t LS0tLS0tLS0tLQpzcmMvYmFja2VuZC91dGlscy9hZHQvdmFybGVuYS5jICAgIHwgMTIgKysrKysr KysrKystCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvdGV4dC5vdXQgfCAgOCArKysrKysrKwpz cmMvdGVzdC9yZWdyZXNzL3NxbC90ZXh0LnNxbCAgICAgIHwgIDMgKysrCjMgZmlsZXMgY2hhbmdl ZCwgMjIgaW5zZXJ0aW9ucygrKSwgMSBkZWxldGlvbigtKQoK --===============8475094705472591020==--