MySQL Bugs: #86619: You cannot create teporary tables inside transactions when GTID is enabled

Bug #86619	You cannot create teporary tables inside transactions when GTID is enabled
Submitted:	8 Jun 2017 9:46	Modified:	9 Jun 2017 8:49
Reporter:	Thomas Johansson	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S4 (Feature request)
Version:	5.6 5.7 8.0	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	GTID, temporary tables, transactions

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
MySQL with GTID enabled will not allow the creation of temporary tables inside a transaction, this is an issue preventing some from making the transition to GTID. If this could be allowed by perhaps not recording it in the binlog or something similar, we would be really happy!

How to repeat:
Make sure GTID is enabled

mysql> BEGIN;
mysql> CREATE TEMPORARY TABLE awesome( id int(1) );

This will fail.

Suggested fix:
Maybe exclude this from binlog?