Project

General

Profile

Actions

Bug #7641

open

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

Added by Juliana Fajardini Reichow 3 days ago. Updated 3 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

Actions #1

Updated by Juliana Fajardini Reichow 3 days ago

We do have tests with multiple-statement queries, but still thinking this deserves a review.

Actions

Also available in: Atom PDF