Benedict:
On Tue, Mar 12, 2019 at 4:56 PM Benedict Holland
<benedict.m.holland@gmail.com> wrote:
> When you create a table in a transaction, it will commit the transaction and prevent a rollback. MySQL is not ACID.
And when you call COMMIT in postgres it will commit and prevent a rollback.
This does not mean MySQL is not ACID, it means DDL cannot be transactioned.
It is, in fact, one of the reasons why I do not use MySql, but I think
InnoDb and friends are ACID, and the problem is the system catalogs
were Isam an not transactioned.
And, If I remember correctly, one of the features Oracle announced for
8.0 was transactional DDL ( althought not sure if it can be mixed with
other things in a transaction, these things are hairy due to the
multiple storage engines normally involved in a single mysql instance
). But I'm not going to test it.
regards.
Francisco Olarte.