Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:121815
Feedback-ID: ie60946b7:Fastmail
Message-ID: <e5a76f43-2e44-415c-b5a7-3bd9f4e36bf3@beccati.com>
Date: Mon, 27 Nov 2023 10:50:35 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Content-Language: it
To: Saki Takamachi <saki@sakiot.com>
Cc: PHP internals <internals@lists.php.net>
References: <17F3158B-EB1C-4546-A24D-F7DA957BA4B7@sakiot.com>
 <e8cb91cf-07f3-4206-8c42-5360767f002e@beccati.com>
 <07141C6E-8677-484C-9F31-EC35367536B4@sakiot.com>
In-Reply-To: <07141C6E-8677-484C-9F31-EC35367536B4@sakiot.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] [PDO] I want to unify the behavior when changing the
 autocommit mode setting while a transaction is open.
From: matteo@beccati.com (Matteo Beccati)

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/