Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:61116
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.214.42 as permitted sender)
Mime-Version: 1.0 (Apple Message framework v1278)
Content-Type: text/plain; charset=iso-8859-1
In-Reply-To: <1341829022.3766.19.camel@guybrush>
Date: Mon, 9 Jul 2012 16:49:17 +0400
Cc: Rasmus Lerdorf <rasmus@lerdorf.com>,
 PHP internals <internals@lists.php.net>
Content-Transfer-Encoding: quoted-printable
Message-ID: <5A04F34F-A25C-43D7-A1A5-DA29976C91D4@gmail.com>
References: <4FF853C6.4030503@lerdorf.com> <1341829022.3766.19.camel@guybrush>
To: =?iso-8859-1?Q?Johannes_Schl=FCter?= <johannes@schlueters.de>
Subject: Re: [PHP-DEV] MYSQL_OPT_RECONNECT
From: indeyets@gmail.com (Alexey Zakhlestin)


On 09.07.2012, at 14:17, Johannes Schl=FCter wrote:

> an example like this:
>=20
>    $pdo =3D new PDO("mysql:...");
>    $select =3D $pdo->prepare("SELECT * FROM t WHERE id =3D ?");
>    /* do something ... connection break in between */
>    $delete =3D $pdo->prepare("DELETE FROM t WHERE id =3D ?");
>    $select->execute([1]);
>=20
> This will in fact do a DELETE, not a SELECT as the statement handle
> effectively is nothing but a per-connection counted unsigned long.

Well, this sounds like a bug

Prepared statements should become invalid once connection is lost and =
further attempts to execute them should lead to exception=