Re: mysqli savepoint rollback support missing

[email protected] ("Christoph M. Becker")
Newsgroups php.general
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.