Horton

Fix incorrect results for numeric data passed through an ECPG SQLDA.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: be38945c6e661cb1d14a3295f4c7608a169f56f3
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2018-11-13T20:46:08Z
Releases: 9.5.16 
Fix incorrect results for numeric data passed through an ECPG SQLDA.

Numeric values with leading zeroes were incorrectly copied into a
SQLDA (SQL Descriptor Area), leading to wrong results in ECPG programs.

Report and patch by Daisuke Higuchi.  Back-patch to all supported
versions.

Discussion: https://postgr.es/m/1803D792815FC24D871C00D17AE95905C71161@g01jpexmbkw24

Files

PathChange+/−
src/interfaces/ecpg/ecpglib/sqlda.c modified +15 −19
src/interfaces/ecpg/test/expected/sql-sqlda.c modified +54 −54
src/interfaces/ecpg/test/expected/sql-sqlda.stderr modified +280 −156
src/interfaces/ecpg/test/expected/sql-sqlda.stdout modified +28 −0
src/interfaces/ecpg/test/sql/sqlda.pgc modified +3 −1

Discussion