Re: mysqli savepoint rollback support missing
[email protected] (Curtis Conard)
| Newsgroups | php.general |
|---|---|
| Message-ID | <CAJ0ifm9rkwJONs1QBdy0AN2CP4cXFPSBi98tc=jCOWTTNdtt9A@mail.gmail.com> |
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 <[email protected]> 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 >