In this post, you’ll learn more about the MariaDB Error 1786 ER_GTID_UNSAFE_CREATE_SELECT with the details of the error message and why you receive this error
Maria DB Error Description
MariaDB Error 1786 – ER_GTID_UNSAFE_CREATE_SELECT with the sqlState HY000
Error Description for the MariaDB Error ER_GTID_UNSAFE_CREATE_SELECT
CREATE TABLE … SELECT is forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.