5.6 版本
root@localhost : test_db 10:45:56> create table table_1 as select * from test_table;
ERROR 1786 (HY000): CREATE TABLE ... SELECT is forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.
root@localhost : test_db 10:47:41>
root@localhost : test_db 10:47:44> create table table_1 like test_table;
Query OK, 0 rows affected (0.00 sec)
root@localhost : test_db 10:51:41> insert into table_1 select * from test_table;
Query OK, 1988906 rows affected (6.06 sec)
Records: 1988906 Duplicates: 0 Warnings: 0
root@localhost : test_db 10:52:04> show variables like '%gtid_mode%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| gtid_mode | ON |
+---------------+-------+
1 row in set (0.00 sec)
root@localhost : test_db 11:04:32>
root@localhost : test_db 11:04:32> show variables like '%enforce_gtid_consistency%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| enforce_gtid_consistency | ON |
+--------------------------+-------+
1 row in set (0.00 sec)
root@localhost : test_db 11:04:33>
ENFORCE_GTID_CONSISTENCY的值为1,则不允许非事务性的表复制操作。