Re: [PDO] I want to unify the behavior when changing the autocommit mode setting while a transaction is open.
| From: | Matteo Beccati | Date: | Mon, 27 Nov 2023 09:50:35 +0000 |
| Subject: | Re: [PDO] I want to unify the behavior when changing the autocommit mode setting while a transaction is open. | ||
| References: | 1 2 3 | Groups: | php.internals |
| Request: | Send a blank email to internals+get-121815@lists.php.net to get a copy of this message | ||
Hi,
Il 27/11/2023 10:23, Saki Takamachi ha scritto:
As you say, such behavior varies from DB to DB. However, with the current implementation of PDO, we don't know how it will work until you actually try it, and each driver has different behavior, so it is important to describe how it works in the documentation is also in a difficult situation. Personally, I think it would be better if specifications could be standardized to a certain extent, within reason, but what do you think?Realistically, I would think it is extremely rare that anyone is both usin autocommit and is planning to switch database type from mysql to firebird or others. Even turning on autocommit after having already made operations on the database seems either an application bug or something that is done on purpose. In the latter case, I suppose they would expect the behaviour to be compliant with the database standards. Cheers -- Matteo Beccati Development & Consulting - http://www.beccati.com/