Horton

Fix range check in ECPG numeric to int conversion

John Naylor <john.naylor@postgresql.org>

View on postgr.es
Commit: cfcb0ceabde11dc6bf57185f72a2b14132631dfd
Author: John Naylor <john.naylor@postgresql.org>
Date: 2021-07-30T20:34:33Z
Releases: 9.6.23 
Fix range check in ECPG numeric to int conversion

The previous coding guarded against -INT_MAX instead of INT_MIN,
leading to -2147483648 being rejected as out of range.

Per bug #17128 from Kevin Sweet

Discussion: https://www.postgresql.org/message-id/flat/17128-55a8a879727a3e3a%40postgresql.org
Reviewed-by: Tom Lane
Backpatch to all supported branches

Files

PathChange+/−
doc/src/sgml/ecpg.sgml modified +1 −1
src/interfaces/ecpg/pgtypeslib/numeric.c modified +6 −1
src/interfaces/ecpg/test/expected/pgtypeslib-num_test.c modified +16 −5
src/interfaces/ecpg/test/expected/pgtypeslib-num_test.stderr modified +1 −1
src/interfaces/ecpg/test/expected/pgtypeslib-num_test.stdout modified +2 −0
src/interfaces/ecpg/test/pgtypeslib/num_test.pgc modified +12 −1

Documentation touched

Discussion