Horton

Fix numeric_mul() overflow due to too many digits after decimal point.

Dean Rasheed <dean.a.rasheed@gmail.com>

View on postgr.es
Commit: 06883d58ff29cf4fb8c32fd13ce9947796b9fb0f
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2021-07-10T11:45:00Z
Releases: 14.0 
Fix numeric_mul() overflow due to too many digits after decimal point.

This fixes an overflow error when using the numeric * operator if the
result has more than 16383 digits after the decimal point by rounding
the result. Overflow errors should only occur if the result has too
many digits *before* the decimal point.

Discussion: https://postgr.es/m/CAEZATCUmeFWCrq2dNzZpRj5+6LfN85jYiDoqm+ucSXhb9U2TbA@mail.gmail.com

Files

PathChange+/−
src/backend/utils/adt/numeric.c modified +9 −1
src/test/regress/expected/numeric.out modified +6 −0
src/test/regress/sql/numeric.sql modified +2 −0

Discussion