Re: mysqli savepoint rollback support missing
| From: | Christoph M. Becker | Date: | Sat, 07 Aug 2021 10:05:24 +0000 |
| Subject: | Re: mysqli savepoint rollback support missing | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-327605@lists.php.net to get a copy of this message | ||
On 07.08.2021 at 00:51, Curtis Conard wrote:
> Am I missing something or is rollback support for savepoints missing from
> the mysqli extension?
> The commit that added savepoint
> support (666a83566077d1db195fd17d088062434b6202fa) is named "Add savepoint
> and rollback to savepoint support" yet only adds the ability to create new
> savepoints and release them (remove without rollback or commit). It does
> not add the ability to rollback to a savepoint with a "ROLLBACK TO"
> statement, and the "rollback" method with the savepoint name as the "name"
> parameter doesn't seem to accomplish this goal either.
The mysqli::roolback() docs[1] note:
| This function does not work with non transactional table types (like
| MyISAM or ISAM).
Maybe this is the problem (or the docs are in error).
[1] <https://www.php.net/manual/en/mysqli.rollback.php>
--
Christoph M. Becker