HomePhabricator

Use auto-commit for temporary table operations

Authored by TK-999 on Sep 4 2017, 12:02 PM.

Description

Use auto-commit for temporary table operations

When running MySQL 5.7 with the --enforce-gtid-consistency option, operations on temporary tables are only permitted in auto-commit mode, outside of any transaction.
As such, we must make sure that Semantic Drilldown performs all temporary table operations by properly committing any open transactions and setting the
DBO_TRX flag for the query.

See also: https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-restrictions.html

Bug: T174908
Change-Id: I51268b3eeaddb7cc0d49a19bc501117d5c248479

Details