Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:113534
Message-ID: <163c35c6-90ba-c343-b64d-d17f2e2b7766@beccati.com>
Date: Mon, 15 Mar 2021 14:12:31 +0100
MIME-Version: 1.0
Content-Language: en-GB
To: Benjamin Morel <benjamin.morel@gmail.com>,
 PHP Internals <internals@lists.php.net>
References: <CAG9XoMS5QySfvO5eZv=vTiGefcynkOL3mGwq8K5Knq1OQRqWSQ@mail.gmail.com>
In-Reply-To: <CAG9XoMS5QySfvO5eZv=vTiGefcynkOL3mGwq8K5Knq1OQRqWSQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] PDO::PARAM_INT and pgsql driver
From: php@beccati.com (Matteo Beccati)

Hi,

On 14/03/2021 21:18, Benjamin Morel wrote:
> This is because the pgsql driver seems to treat everything as PARAM_STR,
> despite being explicitly requested to bind the value as PARAM_INT; the
> placeholder is therefore replaced with the string '4326' instead of the
> integer 4326. >
> [...]
>
> Is there any reason why the pgsql driver doesn't respect PDO::PARAM_STR?

Looks like a bug to me. I thought this had been fixed a while back, but 
apparently it wasn't. I'll try to find some time to investigate in the 
next few days.


Cheers
-- 
Matteo Beccati

Development & Consulting - http://www.beccati.com/