Re: mysqli savepoint rollback support missing

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux