Fix incorrect results for numeric data passed through an ECPG SQLDA.
Tom Lane <tgl@sss.pgh.pa.us>
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
| Path | Change | +/− |
|---|---|---|
| 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
- [Bug Fix]ECPG: cancellation of significant digits on ECPG 10 messages · 2018-05-17 → 2018-11-14