pgsql: Add missing connection validation in ECPG - Mailing list pgsql-committers

From Andrew Dunstan
Subject pgsql: Add missing connection validation in ECPG
Date
Msg-id E1wItNN-003dJu-2I@gemulon.postgresql.org
Whole thread
List pgsql-committers
Add missing connection validation in ECPG

ECPGdeallocate_all(), ECPGprepared_statement(), ECPGget_desc(), and
ecpg_freeStmtCacheEntry() could crash with a SIGSEGV when called
without an established connection (for example, when EXEC SQL CONNECT
was forgotten or a non-existent connection name was used), because
they dereferenced the result of ecpg_get_connection() without first
checking it for NULL.

Each site is fixed in the style of the surrounding code.

New tests are added for these conditions.

Author: Shruthi Gowda <gowdashru@gmail.com>
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Reviewed-by: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Mahendra Singh Thalor <mahi6run@gmail.com>
Reviewed-by: Nishant Sharma <nishant.sharma@enterprisedb.com>
Discussion: https://postgr.es/m/3007317.1765210195@sss.pgh.pa.us
Backpatch-through: 14

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/6916f44100515b7d939f034a2c78caef4047209e

Modified Files
--------------
src/interfaces/ecpg/ecpglib/descriptor.c           |  12 +-
src/interfaces/ecpg/ecpglib/prepare.c              |  32 +++--
src/interfaces/ecpg/test/connect/.gitignore        |   2 +
src/interfaces/ecpg/test/connect/Makefile          |   3 +-
src/interfaces/ecpg/test/connect/test6.pgc         |  68 ++++++++++
src/interfaces/ecpg/test/ecpg_schedule             |   1 +
src/interfaces/ecpg/test/expected/connect-test6.c  | 146 +++++++++++++++++++++
.../ecpg/test/expected/connect-test6.stderr        |  50 +++++++
.../ecpg/test/expected/connect-test6.stdout        |   9 ++
9 files changed, 311 insertions(+), 12 deletions(-)


pgsql-committers by date:

Previous
From: Andrew Dunstan
Date:
Subject: pgsql: Only show signal-sender PID/UID detail in server log
Next
From: Alexander Korotkov
Date:
Subject: pgsql: Use barrier semantics when reading/writing writtenUpto