Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:130659
Precedence: list
MIME-Version: 1.0
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> <9c129841-9ec5-48e5-b6a1-b2589acdd04d@varteg.nz>
In-Reply-To: <9c129841-9ec5-48e5-b6a1-b2589acdd04d@varteg.nz>
Date: Thu, 16 Apr 2026 09:49:21 +0200
Message-ID: <CAANVRFgW331h2dUkGCKx+=sDJ5_3Gb0RkzNAcLrJqvHH-fB-uA@mail.gmail.com>
Subject: Re: [PHP-DEV] [RFC][Discussion] Add MariaDB-specific features to
 mysqlnd and mysqli
To: Weedpacket@varteg.nz
Cc: internals@lists.php.net
Content-Type: multipart/alternative; boundary="000000000000ac4a47064f8f12ae"
From: georg@mariadb.com (Georg Richter)

--000000000000ac4a47064f8f12ae
Content-Type: text/plain; charset="UTF-8"

Hi,


> 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...
>

Transaction safety should always be guaranteed in the application code, not
in the driver. The driver cannot know how transactions are handled by the
user, whether the underlying tables even support transactions, or what the
specific application logic requires.

Adding transaction logic into the driver leads to unpredictable state
management. For example, if the driver were to automatically issue a
RELEASE SAVEPOINT, the application would lose the ability to roll back the
execute_many operation as part of its own broader error-handling logic.

>
>
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.
>

Exactly!

/Georg


-- 
Georg Richter, Staff Software Engineer
Client Connectivity
MariaDB Corporation Ab

--000000000000ac4a47064f8f12ae
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Hi,</div><br><div class=3D"gmail_quote gm=
ail_quote_container"><blockquote class=3D"gmail_quote" style=3D"margin:0px =
0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br>
Couldn&#39;t a SAVEPOINT command be injected instead, with a RELEASE <br>
SAVEPOINT on success and ROLLBACK TO SAVEPOINT on error? Of course now <br>
the driver has to be aware of any current transaction to know it&#39;s to <=
br>
use savepoints instead of a whole transaction...<br></blockquote><div><br><=
/div><div><div>Transaction safety should always be guaranteed in the applic=
ation=20
code, not in the driver. The driver cannot know how transactions are=20
handled by the user, whether the underlying tables even support=20
transactions, or what the specific application logic requires.<br><br>Addin=
g
 transaction logic into the driver leads to unpredictable state=20
management. For example, if the driver were to automatically issue a=20
RELEASE SAVEPOINT, the application would lose the ability to roll back=20
the execute_many operation as part of its own broader error-handling=20
logic.=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px=
 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br></b=
lockquote><br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0=
px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
At which point the recommendation to users to wrap bulk executions in <br>
such commands is ineffective anyway. But if they&#39;re using a <br>
nontransactional engine they should already be aware of these pitfalls.<br>=
</blockquote><div><br></div><div>Exactly!</div><div><br></div><div>/Georg=
=C2=A0</div></div><div><br clear=3D"all"></div><br><span class=3D"gmail_sig=
nature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><di=
v dir=3D"ltr"><div><div dir=3D"ltr"><div>Georg Richter, Staff Software Engi=
neer</div><div>Client Connectivity<br></div><div>MariaDB Corporation Ab<br>=
</div></div></div></div></div></div>

--000000000000ac4a47064f8f12ae--