Project

General

Profile

Bug #10348

Postgres: reentrant statement use with bound parameters results in "Binding too many parameters" exception

Added by Roel Standaert 7 months ago. Updated 5 months ago.

Status:
Closed
Priority:
Normal
Target version:
Start date:
05/13/2022
Due date:
% Done:

100%

Estimated time:

Description

Whenever a particular statement is already in use for a particular connection, we make a new statement with the same SQL, so it can be run concurrently.

However, we use SqlStatement::sql() for that, which isn't necessarily the same as the original SQL.

Notably the Postgres backend replaces questionmarks with $1 etc. This causes the parameter count to be off for the copy of the statement.

#1

Updated by Roel Standaert 7 months ago

  • Status changed from InProgress to Review
  • Assignee deleted (Roel Standaert)
#2

Updated by Roel Standaert 5 months ago

  • Status changed from Review to Implemented @Emweb
  • Assignee set to Roel Standaert
#3

Updated by Roel Standaert 5 months ago

  • Status changed from Implemented @Emweb to Resolved
#4

Updated by Roel Standaert 5 months ago

  • Target version changed from 4.8.0 to 4.7.3
#5

Updated by Roel Standaert 5 months ago

  • % Done changed from 0 to 100
#6

Updated by Roel Standaert 5 months ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF