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: f8abf6944b12c9ed01062a5163385f6c49f0f6ef
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2021-07-10T11:51:22Z
Releases: 9.6.23 
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