Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:121811
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.700.6\))
Message-ID: <17F3158B-EB1C-4546-A24D-F7DA957BA4B7@sakiot.com>
Date: Sun, 26 Nov 2023 11:30:40 +0900
To: PHP internals <internals@lists.php.net>
Subject: [PDO] I want to unify the behavior when changing the autocommit mode
 setting while a transaction is open.
From: saki@sakiot.com (Saki Takamachi)

Hi internals,

The following code:

```
$db =3D new PDO(/* omission */, [PDO::ATTR_ATUOCOMMIT =3D> 0]);
$db->beginTransaction();
$db->setAttribute(PDO::ATTR_ATUOCOMMIT, 1);

```

The behavior in this case varies depending on the DB driver and is not =
unified. MySQL, OCI, ODBC, and Firebird currently support PDO autocommit =
mode.

- MySQL always sets the new mode regardless of the state of the =
transaction, resulting in an implicit commit.
- OCI does an explicit commit and sets the new autocommit mode.
- Firebird raises an error.
- ODBC does not implement this behavior in the first place (it is a bug)

I believe that code that changes the autocommit mode with a transaction =
open is usually just forgetting to close the transaction. Therefore, in =
such cases, I would like to unify the behavior by generating an error =
like Firebird.

I would appreciate any feedback on this proposal and whether this change =
requires an RFC.

Regards.

Saki=