pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Add overflow checks to money type. 7+ messages / 1 participants [nested] [flat]
* pgsql: Add overflow checks to money type. @ 2024-07-19 16:55 Nathan Bossart <nathan@postgresql.org> 0 siblings, 0 replies; 7+ messages in thread From: Nathan Bossart @ 2024-07-19 16:55 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/34e9dce69c4687f8c22831d6b0a1f65fa40c83b1 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(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Add overflow checks to money type. @ 2024-07-19 16:55 Nathan Bossart <nathan@postgresql.org> 0 siblings, 0 replies; 7+ messages in thread From: Nathan Bossart @ 2024-07-19 16:55 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/c5321e9651c5a9306ffe0d4488a0bb3607534920 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(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Add overflow checks to money type. @ 2024-07-19 16:55 Nathan Bossart <nathan@postgresql.org> 0 siblings, 0 replies; 7+ messages in thread From: Nathan Bossart @ 2024-07-19 16:55 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/e8dfe0430fad922948f56889a84af41da532c853 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(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Add overflow checks to money type. @ 2024-07-19 16:55 Nathan Bossart <nathan@postgresql.org> 0 siblings, 0 replies; 7+ messages in thread From: Nathan Bossart @ 2024-07-19 16:55 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 ------ master Details ------- https://git.postgresql.org/pg/commitdiff/22b0ccd65d275d227a7d911aede12d34e1b5dfc9 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(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Add overflow checks to money type. @ 2024-07-19 16:55 Nathan Bossart <nathan@postgresql.org> 0 siblings, 0 replies; 7+ messages in thread From: Nathan Bossart @ 2024-07-19 16:55 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_17_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/3764ee47f78c5a332ee6720bdf2e72c8fc9aac35 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(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Add overflow checks to money type. @ 2024-07-19 16:55 Nathan Bossart <nathan@postgresql.org> 0 siblings, 0 replies; 7+ messages in thread From: Nathan Bossart @ 2024-07-19 16:55 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b82791c8fc2c6bc9d69f4362d7b7f46b9876fa46 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(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Add overflow checks to money type. @ 2024-07-19 16:55 Nathan Bossart <nathan@postgresql.org> 0 siblings, 0 replies; 7+ messages in thread From: Nathan Bossart @ 2024-07-19 16:55 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2024-07-19 16:55 UTC | newest] Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-07-19 16:55 pgsql: Add overflow checks to money type. Nathan Bossart <nathan@postgresql.org> 2024-07-19 16:55 pgsql: Add overflow checks to money type. Nathan Bossart <nathan@postgresql.org> 2024-07-19 16:55 pgsql: Add overflow checks to money type. Nathan Bossart <nathan@postgresql.org> 2024-07-19 16:55 pgsql: Add overflow checks to money type. Nathan Bossart <nathan@postgresql.org> 2024-07-19 16:55 pgsql: Add overflow checks to money type. Nathan Bossart <nathan@postgresql.org> 2024-07-19 16:55 pgsql: Add overflow checks to money type. Nathan Bossart <nathan@postgresql.org> 2024-07-19 16:55 pgsql: Add overflow checks to money type. Nathan Bossart <nathan@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox