Description:
Since MySQL5.7 use InnoDB for temporary tables; however, we still can't use
"CREATE TABLE ... SELECT" command for creating a new table.
If it is possible, please remove this restriction in future.
Best Regard
Shinya
How to repeat:
root@localhost [REPLI]> select @@version;
+-------------------------------------------+
| @@version |
+-------------------------------------------+
| 5.7.10-enterprise-commercial-advanced-log |
+-------------------------------------------+
1 row in set (0.00 sec)
root@localhost [REPLI]> create table T_REPLI04 select * from T_REPLI03;
ERROR 1786 (HY000): Statement violates GTID consistency: CREATE TABLE ... SELECT.
root@localhost [REPLI]> show variables like '%tmp%storage%';
+----------------------------------+--------+
| Variable_name | Value |
+----------------------------------+--------+
| default_tmp_storage_engine | InnoDB |
| internal_tmp_disk_storage_engine | InnoDB |
+----------------------------------+--------+
2 rows in set (0.00 sec)
root@localhost [REPLI]>
