pgsql: Add overflow checks to money type.

From: Nathan Bossart <nathan(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add overflow checks to money type.
Date: 2024-07-19 16:55:34
Message-ID: E1sUqtK-000I14-0R@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add overflow checks to money type.

None of the arithmetic functions for the the money type handle
overflow. This commit introduces several helper functions with
overflow checking and makes use of them in the money type's
arithmetic functions.

Fixes bug #18240.

Reported-by: Alexander Lakhin
Author: Joseph Koshakow
Discussion: https://postgr.es/m/18240-c5da758d7dc1ecf0%40postgresql.org
Discussion: https://postgr.es/m/CAAvxfHdBPOyEGS7s%2Bxf4iaW0-cgiq25jpYdWBqQqvLtLe_t6tw%40mail.gmail.com
Backpatch-through: 12

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/4f962815871f6ac4eb3b516832b5c95a2f628f1b

Modified Files
--------------
src/backend/utils/adt/cash.c | 174 +++++++++++++++++++-----------------
src/test/regress/expected/money.out | 19 ++++
src/test/regress/sql/money.sql | 11 +++
3 files changed, 124 insertions(+), 80 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Noah Misch 2024-07-20 11:24:19 pgsql: Refactor PinBufferForBlock() to remove checks about persistence.
Previous Message Nathan Bossart 2024-07-19 16:55:33 pgsql: Add overflow checks to money type.