There is no such limitation in MariaDB as well as no limitation on CREATE TABLE ... SELECT. Although beware that mixing statements changing MyISAM and InnoDB tables in statement binlog mode you may get different results from the statements on slaves. Pavel On Sat, May 10, 2014 at 3:48 AM, Peter Laursen <peter_laursen@webyog.com> wrote:
GTID implementation in MySQL 5.6 has the limitation as described here: https://dev.mysql.com/doc/refman/5.6/en/replication-gtids-restrictions.html
"nontransactional storage engines such as MyISAM cannot be made in the same statement or transaction as updates to tables using transactional storage engines such as InnoDB."
If you try you will get the error: Error Code: 1785 When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
Is there same or similar/other limitations with GTID in MariaDB 10?
-- Peter Laursen -- Webyog
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp