Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:121817
MIME-Version: 1.0
References: <e5a76f43-2e44-415c-b5a7-3bd9f4e36bf3@beccati.com> <34198326-0244-4856-BF74-503D9A4D00D4@sakiot.com>
In-Reply-To: <34198326-0244-4856-BF74-503D9A4D00D4@sakiot.com>
Date: Mon, 27 Nov 2023 18:02:12 +0700
Message-ID: <CANLbj-oud06=_pY20uHcNwrbEbi5NS0m=Pho-_MaN9Bz3SNNKA@mail.gmail.com>
To: Saki Takamachi <saki@sakiot.com>
Cc: PHP internals <internals@lists.php.net>
Content-Type: text/plain; charset="UTF-8"
Subject: Re: [PHP-DEV] [PDO] I want to unify the behavior when changing the
 autocommit mode setting while a transaction is open.
From: ayesh@php.watch (Ayesh Karunaratne)

>
> Hi,
>
> > In the latter case, I suppose they would expect the behaviour to be compliant with the database standards.
>
> I may not have had this perspective. And this is a strong basis for explaining that different drivers behave differently.
>
> I will continue with the current implementation and consider the optimal method for each driver.
>
>

I wanted to mention a recent RFC that passed its vote
(https://wiki.php.net/rfc/pdo_driver_specific_subclasses). It proposes
to add a PDO subclass for each driver, so we can make individual
driver-specific functions and changes more visible at the API level.

Unfortunately it did not make it to PHP 8.3, but the RFC vote
indicates the trajectory everyone hopes to have in PDO. It was voted
yes unanimously, so there is definitely a preference in majority of us
to iron out the differences, but perhaps in a non-BC way, preferably
making these inconsistencies obvious from the API level and not at the
test/doc levels.