Re: mysqli savepoint rollback support missing

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@gmx.de> 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 >