Project

General

Profile

Actions
Copy link

Bug #10348

closed

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

Added by Roel Standaert over 2 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Roel Standaert
Target version:
4.7.3
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.

Actions
Copy link
 #1

Updated by Roel Standaert over 2 years ago

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

Updated by Roel Standaert over 2 years ago

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

Updated by Roel Standaert over 2 years ago

  • Status changed from Implemented @Emweb to Resolved
Actions
Copy link
 #4

Updated by Roel Standaert over 2 years ago

  • Target version changed from 4.8.0 to 4.7.3
Actions
Copy link
 #5

Updated by Roel Standaert over 2 years ago

  • % Done changed from 0 to 100
Actions
Copy link
 #6

Updated by Roel Standaert over 2 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF