[php-src] Issue #14244: pdo_pgsql: question marks seen as parameter placeholders in dollar-quoted string
| From: | outtersg | Date: | Wed, 15 May 2024 11:04:59 +0000 |
| Subject: | [php-src] Issue #14244: pdo_pgsql: question marks seen as parameter placeholders in dollar-quoted string | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-246919@lists.php.net to get a copy of this message | ||
Issue: https://github.com/php/php-src/issues/14244
Author: outtersg
### Description
Dollar-quoting is a PostgreSQL way of quoting strings, and "no characters inside a
dollar-quoted string are ever escaped" (see [the official
docs](https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING)).
pdo_pgsql however sees ? as parameter placeholders (and **replaces them with $1**, $2, etc., when
emulating prepares).
### PHP Version
PHP 8.2.1
### Operating System
_No response_