pgsql: Fix libpq state machine in pipeline mode - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: Fix libpq state machine in pipeline mode
Date
Msg-id E1lyJ42-0001gC-7v@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix libpq state machine in pipeline mode

The original coding required that PQpipelineSync had been called before
the first call to PQgetResult, and failure to do that would result in an
unexpected NULL result being returned.  Fix by setting the right state
when a query is sent, rather than leaving it unchanged and having
PQpipelineSync apply the necessary state change.

A new test case to verify the behavior is added, which relies on the new
PQsendFlushRequest() function added by commit a7192326c74d.

Backpatch to 14, where pipeline mode was added.

Reported-by: Boris Kolpackov <boris@codesynthesis.com>
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
Discussion: https://postgr.es/m/boris.20210616110321@codesynthesis.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/b71a9cb31e46b08aeac35a4355936165648b3c49

Modified Files
--------------
src/interfaces/libpq/fe-exec.c                     | 19 ++---
src/test/modules/libpq_pipeline/libpq_pipeline.c   | 90 +++++++++++++++++++++
.../modules/libpq_pipeline/t/001_libpq_pipeline.pl |  2 +-
.../modules/libpq_pipeline/traces/nosync.trace     | 92 ++++++++++++++++++++++
4 files changed, 188 insertions(+), 15 deletions(-)


pgsql-committers by date:

Previous
From: Alvaro Herrera
Date:
Subject: pgsql: Add PQsendFlushRequest to libpq
Next
From: Alexander Korotkov
Date:
Subject: pgsql: Fixes for multirange selectivity estimation