Error 1785: When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, updates to non-transactional tables can only
Error Code
SQLSTATE
Error
Description
1785
HY000
ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
Possible Causes and Solutions
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
PreviousError 1784: Found a Gtid_log_event or Previous_gtids_log_event when @@GLOBAL.GTID_MODE = OFFNextError 1786: CREATE TABLE ... SELECT is forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1
Last updated
Was this helpful?