Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:130656
Message-ID: <9c129841-9ec5-48e5-b6a1-b2589acdd04d@varteg.nz>
Date: Thu, 16 Apr 2026 12:23:38 +1200
Precedence: list
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: [PHP-DEV] [RFC][Discussion] Add MariaDB-specific features to
 mysqlnd and mysqli
To: internals@lists.php.net
References: <CAANVRFiatY+SJdmEf56wzOvY5_9QmH7BtMB6yPzbt1xatYc_1A@mail.gmail.com>
 <CAGBsUrezVkQNtYbKENJ-emZY-ccZvEVhnjPmnL9YBofsXJmjcw@mail.gmail.com>
 <CAANVRFgDsmw2v=ue=hyJTgE57k1qEQNZ_immxjCWZY0hQv08dg@mail.gmail.com>
 <CAGBsUrc++XbrVcMMcc6WzwBvD8ui87CXVhXSR6uTC_YbfziE0Q@mail.gmail.com>
 <CAANVRFgd5A4PdHWhA0pNG6Jz1CfVRxWf-nFMJ_7-NNQ2D8RKsg@mail.gmail.com>
Content-Language: en-GB
In-Reply-To: <CAANVRFgd5A4PdHWhA0pNG6Jz1CfVRxWf-nFMJ_7-NNQ2D8RKsg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
From: Weedpacket@varteg.nz (Morgan)

On 2026-04-16 01:39, Georg Richter wrote:
> 
> If mysqli were to automatically inject START TRANSACTION and COMMIT, it 
> could unexpectedly commit a user's existing work or interfere with their 
> manual transaction logic.
 >
Couldn't a SAVEPOINT command be injected instead, with a RELEASE 
SAVEPOINT on success and ROLLBACK TO SAVEPOINT on error? Of course now 
the driver has to be aware of any current transaction to know it's to 
use savepoints instead of a whole transaction...

> Furthermore, an 'automatic' transaction would 
> be a false promise on engines like MyISAM, where BEGIN and COMMIT are 
> simply ignored, still resulting in partial inserts.
> 
At which point the recommendation to users to wrap bulk executions in 
such commands is ineffective anyway. But if they're using a 
nontransactional engine they should already be aware of these pitfalls.