The problem I’m having
I get a MySQL ERROR :
Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context.
The context of why I’m trying to do this
I’m trying to use dbt snapshot feature on a replicated MySQL instance with GTID constraint activated.
What I’ve already tried
The problem does not appear on a non-replicated instance.
The problem occurs when using either the “check” or the “timestamp” strategy.