MySQL Error 1787 – ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION

MySQL Error Message

Statement violates GTID consistency: CREATE TEMPORARY
TABLE and DROP TEMPORARY TABLE can only be executed outside
transactional context. These statements are also not allowed in a
function or trigger because functions and triggers are also
considered to be multi-statement transactions.

Reason for the Error

ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION
was removed after 8.0.12.