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 1x1JjQ-005732-16 for pgsql-committers@arkaria.postgresql.org; Tue, 01 Sep 2026 08:20:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x1JjP-004ySp-1A for pgsql-committers@arkaria.postgresql.org; Tue, 01 Sep 2026 08:20:35 +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 1x1JjP-004ySh-0Q for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:20:35 +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 1x1JjM-00000002L5u-1DIJ for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:20:34 +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=R6cY5xchiaieMLC/Jnl3wHhjaVR1VQf9w9zycM/5bJc=; b=EsEEXH/11unfk512qUdXJi7bwn UGlhTpiTTvq5TOLTNKRJnG/sWPatLFbr/E0kWnZJf3usP7/lTAwa16qXG73N1Y4O3zH/qMNeWhwrT djB9O8vk88GcE5YR/KSA7k6NV9ZSAl5ykryeh8Wr/mQTFWVsIQ+UkasnnNoyneiHjD1XozHOzFDuw 9BMShNrgohMWiNKXJO8QMiAwfjpFAypLTjqpcBTdbJ01iX00EX1NnDeH1dAtHFDUWr/n+1XYaVjRD PxRZI19Xm/Ina2Ik7VTK/Jt6uCFchB6qFwvcIixFB3S7goam8rkYi6W1wyEn6iHnUXSb+Xw1/a7r7 eBOJYiTA==; 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 1x1JjL-00ASaB-08 for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:20:31 +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 1x1JjJ-000000030Yj-3IUU for pgsql-committers@lists.postgresql.org; Tue, 01 Sep 2026 08:20:30 +0000 Content-Type: multipart/mixed; boundary="===============5765080404365506527==" 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:30 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5765080404365506527== 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 CkJhY2twYXRjaC10aHJvdWdoOiAxNAoKQnJhbmNoCi0tLS0tLQpSRUxfMTlfU1RBQkxFCgpEZXRh aWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8yMjkx YjZmZmJlMjM1MWRlYWFkYTBmOWJmNzk2N2M0ZGIyMWE4NmU5CgpNb2RpZmllZCBGaWxlcwotLS0t LS0tLS0tLS0tLQpzcmMvYmFja2VuZC91dGlscy9hZHQvdmFybGVuYS5jICAgIHwgMTIgKysrKysr KysrKystCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvdGV4dC5vdXQgfCAgOCArKysrKysrKwpz cmMvdGVzdC9yZWdyZXNzL3NxbC90ZXh0LnNxbCAgICAgIHwgIDMgKysrCjMgZmlsZXMgY2hhbmdl ZCwgMjIgaW5zZXJ0aW9ucygrKSwgMSBkZWxldGlvbigtKQoK --===============5765080404365506527==--