Actions
Bug #7641
openpgsql: can the parser handle multi-statement in simple query
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
Updated by Juliana Fajardini Reichow about 2 months ago
We do have tests with multiple-statement queries, but still thinking this deserves a review.
Updated by Juliana Fajardini Reichow 24 days ago
Jason demonstrated that if a simple query message contains two queries, the parser will process the responses as if only one query existed.
Will add an SV soon.
Updated by Juliana Fajardini Reichow 24 days ago
Adding pcap shared by Jason
Actions