Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:121599
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.700.6\))
In-Reply-To: <5F393F67-5615-4238-803A-729591ECE405@sakiot.com>
Date: Mon, 6 Nov 2023 22:57:39 +0900
Cc: PHP internals <internals@lists.php.net>
Content-Transfer-Encoding: quoted-printable
Message-ID: <5BE939AD-9E03-43CE-B08D-9B9A30CA507A@sakiot.com>
References: <129fb16f-8d38-4951-b84d-f25799158e2b@beccati.com>
 <5F393F67-5615-4238-803A-729591ECE405@sakiot.com>
To: Matteo Beccati <php@beccati.com>
Subject: Re: [PHP-DEV] Fix the inconsistent behavior of PDO::PARAM_XXX
From: saki@sakiot.com (Saki Takamachi)

Hi,

I think this is probably the same problem that Matteo ran into, but when =
using emulate mode, pgsql errors out with code like this:

```
<?php
$db =3D new PDO(
    pgsql:/* dsn */,
    /* username */,
    /* password */,
    [
        PDO::ATTR_EMULATE_PREPARES =3D> true,
    ],
);

$db->exec('CREATE TABLE test2 (val BOOLEAN)');

$stmt =3D $db->prepare('INSERT INTO test2 VALUES(:val)');
$stmt->bindValue(':val', 1, PDO::PARAM_INT);
$stmt->execute();
```

```
Fatal error: Uncaught PDOException: SQLSTATE[42804]: Datatype mismatch: =
7 ERROR:  column "val" is of type boolean but expression is of type =
integer
```

It seems a little strange that whether an error occurs or not depends on =
whether you are in emulation mode or not.

Saki=