pgsql: Fix libpq state machine in pipeline mode

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(at)codesynthesis(dot)com>
Author: Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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(-)