ERROR 1786 (HY000): CREATE TABLE ... SELECT is forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.

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，则不允许非事务性的表复制操作。