[MySQL] Some non-transactional changed tables couldn ' t be rolled back

When using peewee transactions, a depressed problem is encountered and the transaction seems to be invalid!

This simplifies the model, writes a simple test code, and discovers the problem, as shown in title.

Find answers to:

https://github.com/etianen/django-reversion/issues/362

Https://dev.mysql.com/doc/refman/5.0/en/nontransactional-tables.html

The reason is that the database table engine needs to be set to InnoDB to support things, and the workaround is as follows:

Http://dev.mysql.com/doc/refman/5.6/en/converting-tables-to-innodb.html

That is, the engine that will need to support the things table is set to Innodb,sql as follows:

ALTER TABLE my_table ENGINE=INNODB;

[MySQL] Some non-transactional changed tables couldn ' t be rolled back