All tables were using InnoDB and a raw ROLLBACK TO query works with this extension.
On Sat, Aug 7, 2021, 6:05 AM Christoph M. Becker <cmbecker69@xxxxxx> wrote:
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
