Project

General

Profile

Actions

Bug #7641

open

pgsql: can the parser handle multi-statement in simple query

Added by Juliana Fajardini Reichow about 1 month ago. Updated 2 days ago.

Status:
New
Priority:
Normal
Target version:
Affected Versions:
Effort:
Difficulty:
Label:

Description

According to the protocol specifications, even in SimpleQuery mode/ subprotocol, it is possible to have multiple statements in a Simple Query.
Get some pcaps with this scenario and see how the parser behaves.

(cf https://www.postgresql.org/docs/13/protocol-flow.html#id-1.10.5.7.4)

We'll currently create a new transaction when we receive a SimpleQuery message. But what happens with multiple statements for:
- parsing
- consolidating data, if need be
- logging


Files

TLPW-psql-SimpleQueryCornerCase.pcap (4.42 KB) TLPW-psql-SimpleQueryCornerCase.pcap pcap showcasing 2 queries in a simple query Juliana Fajardini Reichow, 05/06/2025 01:37 PM
Actions

Also available in: Atom PDF